May 12

Database backups fail on Tivoli Storage Manager V6.2 servers that were configured using the configuration wizard or upgrade wizard on Windows systems.

DB Backup No Comments »
Abstract
Tivoli Storage Manager V6.2 servers that were configured using the configuration wizard or upgrade wizard on Windows systems might have database backups that fail.When the database backup command is issued it might fail and display this message: “ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 406.”
 
 
Content
If the upgrade wizard or configuration wizard is used to configure or set up a Tivoli Storage Manager V6.2 server on a Windows system, when the BACKUP DB command is issued, it might fail due to a problem with the setup of the DSMI_api environment variable.
The database backup does not occur, and the server issues this message: “ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 406”.
To resolve this problem you must set the DSMI_api environment variable configuration for the database instance.Note: These examples use server1 for the database instance and d:\tsmserver1 for the Tivoli Storage Manager server instance directory. Replace these values with your actual values when issuing the commands.

Perform these steps to set the DSMI_ api environment-variable configuration for the database instance:

1. Navigate to the C:\Program Files\Tivoli\TSM\db2\bin directory, or if you installed Tivoli Storage Manager in a different location, go to the db2\bin subdirectory in your main installation directory and issue this command to open a DB2 command window:

db2cmd
2. Issue this command:
db2set -i server1 DB2_VENDOR_INI=d:\tsmserver1\tsmdbmgr.env

Additional information can be found in the Tivoli Storage Manager, Version 6.2 Information Center at: http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=/com.ibm.itsm.srv.install.doc/t_srv_prep_dbmgr.html.

written by Bosse