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.

CODE

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

Provision

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

Common commands

CODE

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

CODE

set source.parameters="{\"databaseAliasName\":\"testvdb\",\"config_settings_prov\":[{\"propertyName\":\"NUM_DB_BACKUPS\",\"value\":\"11\"}]}";

VDB with custom mount base

CODE

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.

CODE

commit

Disable

Run the following commands to disable a VDB.

CODE

source
select testvdb
disable
commit

Enable

Run the following command to enable a VDB.

CODE

source
select testvdb
enable
commit

Stop

Run the following command to stop a VDB.

CODE

source
select testvdb
stop
commit

Start

Run the following command to start a VDB.

CODE

source
select testvdb
start
commit

Refresh

Run the following to refresh a VDB to the latest snapshot, where the parent dsource is testdb.

CODE

database
select testvdb
refresh
set timeflowPointParameters.container=testdb
commit