IBM Tivoli Storage Manager, Version 7.1

Resolving incorrect environment variables for BACKUP DB and RESTORE DB

Many of the BACKUP DB or RESTORE DB processing problems are as a result of incorrectly set DSMI_CONFIG or DSMI_DIR,DSMI_LOG environment variables.

About this task

Requirement:

The environment variables are used by the Tivoli® Storage Manager client API to locate API codes and the options files. The DB2® instance must be running in a shell with correctly set environmental variables.

AIX operating systems HP-UX operating systems Linux operating systems Oracle Solaris operating systems The DSMI_* variables are set in the instance's userprofile file. For example: /home/tsminst1/sqllib/userprofile

Windows operating systems The DSMI_* variables are set in the file that the DB2 instance registry variable, DB2_VENDOR_INI, points to. For example, this file might be c:\tsminst1\tsmdbmgr.env. You can verify the file name and location by issuing the db2set -i tsminst1 DB2_VENDOR_INI command, where tsminst1 is the DB2 instance.

The DSMI_* variables are initially set up automatically by the Tivoli Storage Manager instance configuration wizard. They can be set up manually, though, as described in the IBM Tivoli Storage Manager Installation Guide.

Procedure

Open the /home/tsminst1/sqllib/userprofile file and review the statements. If you change this file, stop and restart the DB2 instance so that the changes are included. For example, consider the following scenario. The userprofile file has statements like the following example text:

export DSMI_CONFIG=/tsminst1/tsmdbmgr.opt
export DSMI_DIR=/opt/tivoli/tsm/server/bin/dbbkapi
export DSMI_LOG=/tsminst1

The /home/tsminst1/tsminst1/tsmdbmgr.opt file has the following text:

SERVERNAME TSMDBMGR_TSMINST1

The /opt/tivoli/tsm/server/bin/dbbkapi/dsm.sys file has the following text:

SERVERNAME TSMDBMGR_TSMINST1
commmethod tcpip
tcpserveraddr localhost
errorlogname /tsminst1/tsmdbmgr.log

Verify that the SERVERNAME entry in the tsmdbmgr.opt file matches the SERVERNAME entry in the dsm.sys file.

Linux operating systems Do not add the PASSWORDACCESS generate option to the dsm.sys configuration file. This option can cause the database backup to fail.

Feedback