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:
Command syntax
.-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:
- 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.