Backing up client configuration information

Before you upgrade your client, back up the database manager configuration parameter settings of your client instance and the information details about all of your cataloged databases. With this information, you can restore your previous client configuration and cataloged databases after upgrade, if necessary.

Before you begin

Ensure that you have SYSADM or SYSCTRL authority to run the db2cfexp command.


Restrictions

This procedure describes how to back up the configuration information for only one client. If you have different configuration settings on each client, you must back up the configuration information for each client.

Procedure

To back up your client configuration information:

  1. Back up your database manager configuration parameter settings.
    Use the GET DATABASE MANAGER CONFIGURATION command to list your settings for the parameters and redirect the command output to a file as shown in the following example: 
       db2 GET DBM CFG > D:\upgrade\dbm_client.cfg
  2. Back up the information of cataloged databases to export your configuration profile.