DB2 10.5 for Linux, UNIX, and Windows

db2cfexp - Connectivity configuration export tool command

Exports connectivity configuration information to an export profile, which can later be imported at another DB2® database workstation instance of similar instance type (that is, client instance to client instance). The resulting profile will contain only configuration information associated with the current DB2 database instance. This profile can be referred to as a client configuration profile or a configuration profile of an instance.
This utility exports connectivity configuration information into a file known as a configuration profile. It is a non-interactive utility that packages all of the configuration information needed to satisfy the requirements of the export options specified. Items that can be exported are:
  • Database information (including DCS and ODBC information)
  • Node information
  • Protocol information
  • database manager configuration settings
  • registry settings
  • Common ODBC/CLI settings.

This utility is especially useful in situations where multiple similar remote DB2 clients are to be installed, configured, and maintained (for example, cloning or making templates of client configurations).

Authorization

One of the following authorities:
  • SYSADM
  • SYSCTRL

Command syntax

Read syntax diagramSkip visual syntax diagram
                       .-TEMPLATE-.   
>>-db2cfexp--filename--+-BACKUP---+----------------------------><
                       '-MAINTAIN-'   

Command parameters

filename
Specifies the fully qualified name of the target export file. This file is known as a configuration profile.
TEMPLATE
Creates a configuration profile that is used as a template for other instances of the same instance type (that is, client instance to client instance). The profile includes information about:
  • 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.
BACKUP
Creates a configuration profile of the DB2 database instance for local backup purposes. This profile contains all of the instance configuration information, including information of a specific nature relevant only to this local instance. The profile includes information about:
  • 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.
MAINTAIN
Creates a configuration profile containing only database- and node-related information for maintaining or updating other instances.

Note:

The db2cfexp command will not export the File data source location information from a client.

If you use the default location, no action is required. If you change the default location on a client, you will need to manually copy this location when exporting connectivity information.

To copy the File data source location from one client to another:
  1. On the client you are exporting connectivity information, locate the %DB2PATH%\TOOLS directory.
  2. Copy the CA.properties file.
  3. On the client you are importing connectivity information, locate the %DB2PATH%\TOOLS directory.
  4. Overwrite the existing CA.properties file with the copy taken from the originating client.

You have duplicated the File data source location from one client to another.