IBM Support

ANR0298S Authority is insufficient to access the database

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

  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\"

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU010","label":"Systems - Storage"},"Component":"Server","Platform":[{"code":"PF033","label":"Windows"}],"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","Edition":""}]

Document Information

Modified date:
17 June 2018

UID

swg21427232