Troubleshooting
Problem
Database Backup returns error "ANR2983e... sqlerrmc 168" when running Tivoli Storage Manager Server version 7.1.x
Symptom
On Tivoli Storage Manager server 7.1 it may occur that the database backup returns the following error in the activity log:
ANR2983E Database backup terminated due to environment or setup issue related to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168. (SESSION: 108, PROCESS: 3)
ANR1361I Output volume /tsm/fsname/94712603.DBV closed.(SESSION: 108, PROCESS: 3)
ANR0515I Process 3 closed volume /tsm/fsname/94712603.DBV. (SESSION: 108, PROCESS: 3)
ANR0985I Process 3 for Database Backup running in the BACKGROUND completed with completion state FAILURE at 01:10:04 PM. (SESSION: 108, PROCESS: 3)
Environment
Tivoli Storage Manager 7.1 on all Platforms
Diagnosing The Problem
The sqlerrmc 168 mean:
Password file is needed, but user is not root. This message is
often generated when the DSMI_DIR environment variable points
to a directory that contains a 32-bit version of the dsmtca
program, yet the DB2 instance is 64-bit, or vice-versa.
In version 7.1 the configuration for the database backup has been changed.
-The environment variables points to different values compared with version 6.3.x.
- It is not longer necessary to set the API password during a manual configuration
- Passworddir and passwordaccess options are not allowed to be set in dsm.sys compared with version 6.3.x
It will be necessary to review the "DSMI_DIR" environment variable on the system as well as the configuration files used by the database backup operation.
Resolving The Problem
Review the following manual pages for verifying if the database backup configuration is correct:
- Linux platform:
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.srv.install.doc%2Ft_srv_prep_dbmgr-linux.html
- AIX platform:
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.srv.install.doc%2Ft_srv_prep_dbmgr-aix.html
- Microsoft Windows platform:
http://pic.dhe.ibm.com/infocenter/tsminfo/v7r1/index.jsp?topic=%2Fcom.ibm.itsm.srv.install.doc%2Ft_srv_prep_dbmgr-windows.html
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21668435