Provisioning operations of IBM Db2 via CLI
To create a VDB via CLI, you must first create a dSource. For more information on creating a dSource, refer to Link operation via CLI section.
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>
Provision
Run the following commands to provision a VDB. The following example uses testdb
dSource.
Common commands
database provision
set type=AppDataProvisionParameters
set container.name=testvdb
set container.group=Untitled
set source.allowAutoVDBRestartOnHostReboot=true
set sourceConfig.name=""
set sourceConfig.repository="dlpxdb21 - 11.5.8.0 - db2adv"
set sourceConfig.environmentUser=dlpxdb21
set timeflowPointParameters.container=testdb
With default mount base
set source.parameters="{\"databaseAliasName\":\"testvdb\",\"config_settings_prov\":[{\"propertyName\":\"NUM_DB_BACKUPS\",\"value\":\"11\"}]}";
VDB with custom mount base
set source.parameters="{\"databaseAliasName\":\"testvdb\",\"VDBmountLocation\":\"/vdb_mount_base/test\",\"config_settings_prov\":[{\"propertyName\":\"NUM_DB_BACKUPS\",\"value\":\"11\"}]}";
Commit
Run the following command to commit the change.
commit
Disable
Run the following commands to disable a VDB.
source
select testvdb
disable
commit
Enable
Run the following command to enable a VDB.
source
select testvdb
enable
commit
Stop
Run the following command to stop a VDB.
source
select testvdb
stop
commit
Start
Run the following command to start a VDB.
source
select testvdb
start
commit
Refresh
Run the following to refresh a VDB to the latest snapshot, where the parent dsource is testdb
.
database
select testvdb
refresh
set timeflowPointParameters.container=testdb
commit