Provision SAP HANA operations via CLI

The operations explained in this documentation section can also be performed through the Delphix Engine’s Command Line Interface (CLI). The available operations are as follows: 

• Create 

• Disable 

• Enable 

• Stop 

• Start 

• Delete 

To create a VDB via CLI, you must first create a dSource. For more information on creating a dSource, refer to the Link operation via CLI section. 

Prerequisites 

To create a VDB and perform operations via CLI, log in to the Delphix Continuous Data Engine using the admin user account. 

ssh admin@<CONTINUOUS-DATA-FQDN-or-IP>

Creating a VDB

Run the following commands to create (provision) a VDB. The following example uses testdb dSource. 

Example

 database provision 
set type=AppDataProvisionParameters 
set container.name=testvdb 
set container.group=Untitled 
set source.allowAutoVDBRestartOnHostReboot=true 
set timeflowPointParameters.container=HDB-rh86-hana2sp6-s1.dlpxdc.co 
set sourceConfig.name=testscfgv 
set sourceConfig.repository="centos-tgt.dlpxdc.co/'HANA 2.00.052.00.1599235305 /usr/sap/HDB/HDB00'" 
set source.parameters="{\"mountLocation\":\"/tmp/test\", \"tDatabaseName\":\"TEST\",\"tSystemUserName\":\"SYSTEM\",\"tSystemUserPassword\":\"PASS\", \"configServices\":[]}" 
commit 

set sourceConfig.repository="centos-tgt.dlpxdc.co/'HANA 2.00.052.00.1599235305 /usr/sap/HDB/HDB00'"
set source.parameters="{\"mountLocation\":\"/tmp/test\", \"tDatabaseName\":\"TEST\",\"tSystemUserName\":\"SYSTEM\",\"tSystemUserPassword\":\"PASS\", \"configServices\":[]}"
commit

set source.parameters="{\"mountLocation\":\"/tmp/test\", \"tDatabaseName\":\"DatabaseName\",\"tSystemUserName\":\"UserName\",\"tSystemUserPassword\":\"Password\", \"configServices\":[], \"encryptionParameters\":[{\"rootKeyBackupPass\":\"Password\",\"tenantUserName\":\"UserName\",\"tenantDatabasePass\":\"Password\"}]}"

Disabling the VDB

Run the following commands to disable a dSource. You must select the same sourceConfig name that was given during VDB creation. 

Example

Example -  
source 
select testscfgv 
disable 
commit 

Enabling the VDB

Run the following command to enable a dSource. 

Example

Example -  
source 
select testscfgv 
enable 
commit

Stopping the VDB 

Run the following command to stop a dSource. 

Example

Example -  
source 
select testscfgv 
stop 
commit

Starting the VDB 

Run the following command to start a dSource. 

Example

Example -  
source 
select testscfgv 
start 
commit

Deleting the VDB 

Run the following command to delete a VDB. 

Example 

source 
select testscfgv 
delete 
Commit