Chapter 2. DB2 server deployment 37
[DB>ZAIRE01:ITSODB]
Dir_entry_type=REMOTE
Authentication=NOTSPEC
DBName=ITSODB
[DB>!LOCAL:SAMPLE]
Dir_entry_type=INDIRECT
Drive=/home/db2inst1/db2home
DBName=SAMPLE
db2cfexp and db2cfimp
The export and import of configuration profile can also be performed from the
command line using the DB2 utilities db2cfexp and db2cfimp. The db2cfexp is
used to do export, while db2cfimp is used to do import.
DB2 Configuration Assistant provides other functionalities besides exporting and
importing a configuration profile. The db2cfexp and db2cfimp commands focus
on connectivity information and a few other associated configurations. The
configuration information that can be exported and imported using the db2cfexp
and db2cfimp commands are:
򐂰Database information (including DCS and ODBC information)
򐂰Node information
򐂰Protocol information
򐂰Database manager configuration settings
򐂰Registry settings
򐂰Common ODBC/CLI settings
The db2cfexp and db2cfimp commands are handy on platforms where the DB2
Configuration Assistant cannot be installed — for example, AIX and other UNIX
platforms, where tools based on the command line are more often utilized.
Table2-1 shows the three available options for db2cfexp.
Table 2-1 Options for db2cfexp
Option Explanation
TEMPLATE Creates a generic export profile to transfer this configuration to
another workstation. (Includes configuration, catalog, and ODBC
information.)
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.
MAINTAIN Creates a database export profile to transfer the database catalog
information to another workstation.