CLI Cookbook: Provisioning a SAP ASE VDB
Reference / Command Line Interface Guide / CLI Cookbook: Common Workflows, Tasks, and Examples / CLI Cookbook: VDBs / 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:

    snapshot list database=dexample
timeflow "dexample" timeflowRanges; commit
  • 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.

    delphix> database provision

  2. Set the type for the new VDB

    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: 

    delphix database provision *> defaults
delphix database provision *> ls


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

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

  5. Set the name of the new VDB.

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

  6. Set the source configuration properties on the target SAP ASE instance

    delphix database provision *> edit sourceConfig.instance
delphix database provision sourceConfig.instance *> set host=<targethost>
delphix database provision sourceConfig.instance *> back

  7. Set the target Dataset Home.

    delphix database provision *> set sourceConfig.repository=<Dataset Home>

  8. Set the source container from which to provision.

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

  9. Set the desired value for truncateLogOnCheckpoint

    delphix database provision *> set truncateLogOnCheckpoint=false

  10. Commit the configuration and start the DB_PROVISION job

    delphix database provision *> commit