Restoring and recovering a DB2 database - with a catalog name that has been specified
A catalog name can be specified for a database backup and an archive log backup. If a user specified a catalog name during a backup, there are certain setup actions you must follow during restore operations. Follow the following options for use in a Windows and UNIX environment.
Windows:
If the catalog name is equal to the name of the client performing the restore, no special setup is needed.
If the primary and the client are the same server and if the catalog name does not equal the name of the client performing the restore, update the
db2.confas follows:DATABASE and ARCHIVE stanzas:
CLIENT <catalog name>
ARCHIVE stanza only:
FORCE_BACKUP_CLIENT <name of the host performing the restore>
The newer releases of the DB2 database want to perform a backup of the archive logs after a restore.
If the client is a different server than where the backup has occurred and if the catalog name does not equal the name of the client performing the restore:
db2.confDATABASE and ARCHIVE stanzas:
CLIENT <catalog name>
ARCHIVE stanza only:
FORCE_BACKUP_CLIENT <name of the host performing the restore>
The newer releases of the DB2 database want to perform a backup of the archive logs after a restore.
The
altnamesdirectory must be set up:install_path\netbackup\db\altnames
UNIX:
If the catalog name is equal to the name of the client performing the restore, no special setup is needed.
If the catalog name does not equal the client name performing the restore, update the
db2.confas follows:db2.confDATABASE and ARCHIVE stanzas:
CLIENT <catalog name>
ARCHIVE stanza only:
FORCE_BACKUP_CLIENT <name of the host performing the restore> The newer releases of DB2 want to perform a backup of the archive logs after a restore
The
altnamesdirectory must be set up:/usr/openv/netbackup/db/altnames
More Information