Loading...

Enabling Database Configuration Parameters

Each DB2 database has its own configuration. To back up DB2 data successfully in some cases, you must enable the appropriate database configuration parameters. You must set these parameters based on the state of the database, backup type, and/or data type as follows:

Before you change any configuration parameter, ensure that no applications are currently using the affected database. Also, be sure to consult your database administrator regarding business requirements for the database.

Note: Perform an offline backup to update the database configuration parameters.

Procedure

Backups in General

To back up any type of DB2 data online or offline, update the LOGARCHOPT1, LOGARCHMETH2 and VENDOROPT database configuration parameters by entering the following commands:

For DB2 DPF

Run the following DB2 commands on each DB2 DPF node.

  1. From the DB2 Console, enter the command to set the LOGARCHOPT1 parameter.

    db2 update db cfg for <database name> DBPARTITIONNUM (n) using LOGARCHOPT1 "'CvClientName=<DB2ClinetNameOnNode(n)>,CvDpfClientName=<Db2MultiNode_PesudeoClientName>,CvInstanceName= <Commvault_InstanceName>'"

  2. Enter the command to set the VENDOROPT parameter.

    db2 update db cfg for <database name> DBPARTITIONNUM (n) using VENDOROPT "'CvClientName=<DB2ClinetNameOnNode(n)>,CvDpfClientName=<CvClientName> <Db2MultiNode_PesudeoClientName>,CvInstanceName= <Commvault_InstanceName>'"

For DB2 pureScale

  1. From the DB2 Console, enter the command to set the LOGARCHOPT1 parameter.

    db2 update db cfg for <database name> using LOGARCHOPT1 "'CvDpfClientName=<Db2MultiNode_PesudeoClientName>,CvInstanceName=<Commvault_InstanceName>'"

  2. Enter the command to set the VENDOROPT parameter.

    db2 update db cfg for <database name> using VENDOROPT "'CvDpfClientName=<Db2MultiNode_PesudeoClientName>,CvInstanceName=<Commvault_InstanceName>'"

    Where:

    <database_name> = DB2 Database Name which you want to configure for Backup

    (n) = DB2 Node Number of DB2 DPF

    CvClientName = DB2 Client Name

    CvDpfClientName = DB2 DPF Pesudeo Client Name in the Commvault CommServe

    CvInstanceName = Commvault Instance Name in DB2 Client ( for example, Instance001)

    VENDOR:/opt/Commvault/Base/libDb2Sbt.so = Commvault SBT library

Last modified: 7/10/2018 3:32:01 PM