Troubleshooting
Problem
On a Windows system, a Tivoli Storage Manager server instance is installed with one user ID, but is started with a different user ID. When started with the different user ID, the ANR0298S message is logged.
Cause
The user ID that is being used to start the server instance does not have sufficient authority to the DB2 database.
Diagnosing The Problem
Open a DB2 command window by selecting Start > All Programs > IBM DB2 > Command Line Tools > Command Window - Administrator
From the Command Window, run the following commands:
set db2instance=server1
db2 connect to TSMDB1
db2 "select grantee,securityadmauth from syscat.dbauth"
The output from the select command returns the user ID that is authorized to the database.
Resolving The Problem
- Log on with the user ID that created the Tivoli Storage Manager server instance.
- Open a DB2 command window by selecting Start > All Programs > IBM DB2 > Command Line Tools > Command Window - Administrator
- From the command window, enter the following commands:
set db2instance=server1
db2 connect to TSMDB1
db2 grant dbadm with dataaccess with accessctrl on database to user XXX
db2 grant secadm on database to user XXX
In the two grant commands, XXX is the user ID from which the Tivoli Storage Manager server is to be run (different from the user ID that was used to create the server instance).
When special characters such as "." and "\" are used in the user id, the user id must be quoted with the quotation marks escaped. For example, the following command :
db2 grant dbadm with dataaccess with accessctrl on database to user "my.user"
fails with the following error :
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "." was found following "database to user svc". Expected tokens may include: ",". SQLSTATE=42601
The correct syntax for the command is:
db2 grant dbadm with dataaccess with accessctrl on database to user \"my.user\"
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21427232