How to replicate instance configuration parameters in DB2?

db2cfexp – Connectivity Confg Export tool command

It'll export the database manager and all the instance level configuration, registry variables, node details, database details including remote databases and protocol information details into an external file.

Syntax:

db2cfexp <file-name> template

* Here template creates the file with the below mentioned details

-         All databases, including related ODBC and DCS information

-         All nodes associated with the exported databases

-         Common ODBC/CLI settings

-         Common client settings in the database manager configuration

-         Common client settings in the DB2 registry.

db2cfexp <file-name> backup

* Here backup creates the file with the below mentioned details.

-         All databases including related ODBC and DCS information

-         All nodes associated with the exported databases

-         Common ODBC/CLI settings

-         All settings in the database manager configuration

-         All settings in the DB2 registry

-         All protocol information.

db2cfexp <file-name> maintain

* Here maintain creates the file with the below mentioned details

-         Creates a configuration profile containing only database- and node-related information for maintaining or updating other instances.

db2cfimp - Connectivity configuration import tool command

Imports connectivity configuration information from a file known as a configuration profile. It is a non-interactive utility that will attempt to import all the information found in the configuration profile.

Syntax:

db2cfimp <file-name>