IBM Support

Startup of server fails after restoring database to a new machine

Troubleshooting


Problem

ANR0298S Authority is insufficient to access the database error and Server can fail to start after restoring the database to a new machine.

Symptom

Perform a Tivoli Storage Manager database backup on one machine, install the same code level on new machine and restore the database. The server will fail to start.

Cause

The server instance name on the source server is different than the instance name on the target instance.

Resolving The Problem

To fix this problem:

1) On the target server, create a new account for the instance name that was used on the source server.

2) Grant Admin, DB2USER, and DB2ADMN rights to this new account on the target machine.

Use the following commands to grant these rights to the new account on the target server.

C:\Program Files\Tivoli\TSM\db2\BIN>set db2instance=server1


C:\Program Files\Tivoli\TSM\db2\BIN>db2 connect to TSMDB1
C:\Program Files\Tivoli\TSM\db2\BIN>db2 "select grantee,securityadmauth from syscat.dbauth"
C:\Program Files\Tivoli\TSM\db2\BIN>db2 grant dbadm with dataaccess with accessctrl on database to user INSTANCENAME
C:\Program Files\Tivoli\TSM\db2\BIN>db2 grant secadm on database to user INSTANCENAME

The Tivoli Storage Manager server should now start.

For more information on resolving server startup issues, reference the following articles:
http://www-01.ibm.com/support/docview.wss?uid=swg21445245

and, if the Tivoli Storage Manager server is started as domain user:
http://www-01.ibm.com/support/docview.wss?uid=swg21497342

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Document Information

Modified date:
17 June 2018

UID

swg21500760

Page Feedback