IBM Support

Startup of server fails after restoring database to a new machine

Technote (troubleshooting)


Problem(Abstract)

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

Related information

Resolving version 6 Startup problems
If version 6 server is started with Domain User

Product Alias/Synonym

TSM

Document information

More support for: Tivoli Storage Manager
Server

Software version: All Versions

Operating system(s): Windows

Reference #: 1500760

Modified date: 10 March 2017


Translate this page: