IBM Support

ANR0298S Authority is insufficient to access the database

Technote (troubleshooting)


Problem(Abstract)

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

  1. Log on with the user ID that created the Tivoli Storage Manager server instance.
  2. Open a DB2 command window by selecting Start > All Programs > IBM DB2 > Command Line Tools > Command Window - Administrator
  3. 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\"

Document information

More support for: Tivoli Storage Manager
Server

Software version: 6.2, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.3, 6.3.2, 6.3.3, 6.3.4, 6.4, 6.4.1, 7.1, 7.1.1, All Supported Versions

Operating system(s): Windows

Reference #: 1427232

Modified date: 04 March 2011


Translate this page: