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 for exporting connectivity
configuration information at workstations that do not have the DB2 Configuration Assistant installed,
and in situations where multiple similar remote DB2 clients are to be installed, configured,
and maintained (for example, cloning or making templates of client
configurations).
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.