Troubleshooting
Problem
The following message will be seen when trying to start the Tivoli Storage Manager server: ANR0100E adminit.c(2564): Error 105 creating table "OccupancyT".
Symptom
Unable to start the Tivoli Storage Manager server.
Diagnosing The Problem
Attempt to start the Tivoli Storage Manager server in the foreground (dsmserv -k instancename) will show the error. Also the following commands can be run from a DB2 command line to verify what accounts have the needed authority.
set db2instance=server1
db2 connect to TSMDB1
db2 "select grantee,securityadmauth from syscat.dbauth"
This should show that only the system accounts has the authority to create the table
Resolving The Problem
There have been a few solutions reported for this error. These solutions will assume a database restore or server migration (moving of the Tivoli Storage Manager server) were not recently done.
1. Rebooting the system may resolve this issue. After a reboot, attempt to start the server again.
2. This error was maybe caused by using the wrong user. Use the same user that did the installation or use instance user.
3. The following can also be done to grant authority to the needed account.
For Windows 2008
- Download psexec
http://technet.microsoft.com/en-us/sysinternals/bb897553
- Once extracted, you can run the following command from a Windows command prompt in the directory where you extracted it.
psexec -i -s cmd.exe
For Windows 2003
- From a Windows command prompt enter:
sc create testsvc binpath= "cmd /K start" type= own type= interact
sc start testsvc
You should then have a new command prompts at c:\Windows\system32 running whoami at this command prompt should show:
nt authority\system
You can then start the db2 command line prompt under this window:
"C:\Program Files\Tivoli\TSM\db2\BIN\DB2CW.BAT"
Then to grant the needed authority, run the following commands
set db2instance=<instance>
db2 connect to TSMDB1
db2 grant dbadm with dataaccess with accessctrl on database to user XXX
db2 grant secadm on database to user XXX
Historical Number
1497882
Product Synonym
TSM IBM Spectrum Protect
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21512211