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
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:
- On the client you are exporting connectivity information, locate the %DB2PATH%\TOOLS directory.
- Copy the CA.properties file.
- On the client you are importing connectivity information, locate the %DB2PATH%\TOOLS directory.
- 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.