CLI cookbook: provisioning a SAP ASE VDB

This topic describes how to provision an SAP ASE VDB using the command line interface.

Prerequisites

You will need the following information:

• The name of the VDB you want to create

• The group in which to create the VDB

• The SAP ASE database name for the VDB

• The source dSource or VDB from which you wish to provision

• The semanticLocation, LSN, or timestamp of the point you want to provision from (if not using the most recent). You can run these commands to get the list of snapshots or timeflow ranges:

  CODE

  snapshot list database=dexample
  snapshot list timeflow=dexample
  snapshot list fromDate="2020-03-01T00:00:00.000Z" toDate="2020-03-04T11:31:27.883Z"

• The target host on which you want to create the VDB. You can list the hosts with the /host list command.

• The source repository (SAP ASE instance on the target host) in which to create the VDB. These can be listed with the /repository list command.

Procedure

1. Execute the database provision command.

   CODE

   delphix> database provision

2. Set the type for the new VDB

   CODE

   delphix database provision *> set type=ASEProvisionParameters

3. Use defaults to fill in most of the information and then customize any additional information that you do not want defaulted, for what information has been filled in after defaults you can do an ls for all fields: 

   CODE

   delphix database provision *> defaults
   delphix database provision *> ls
   Properties:
       type: TimeflowPointSemantic
       container: (unset)
       location: LATEST_POINT
   delphix database provision *> set container=<dexample>
   delphix database provision *> commit

4. Set the name and group for the new VDB.

   CODE

   delphix database provision *> set container.name=<vexample>
   delphix database provision *> set container.group="<New Group>"

5. Set the name of the new VDB.

   CODE

   delphix database provision *> set sourceConfig.databaseName=<vexample>

6. Set the target Dataset Home.

   CODE

   delphix database provision *> set sourceConfig.repository=<Dataset Home>
   delphix database provision *> set sourceConfig.environmentUser=<Host environment name/sybase>

7. Set the source container from which to provision.

   CODE

   delphix database provision *> set timeflowPointParameters.container=<dexample>

8. Set the desired value for truncateLogOnCheckpoint

   CODE

   delphix database provision *> set truncateLogOnCheckpoint=false

9. Commit the configuration and start the DB_PROVISION job

   CODE

   delphix database provision *> commit