Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tivoli Storage Manager fails to start with ANR0131E SQL1585N and SQLSTATE=54048

ADSM/TSM Troubleshooting Tips

Tivoli Storage Manager fails to start with ANR0131E SQL1585N and SQLSTATE=54048

by  LED888  Posted    (Edited  )
Problem
ANR0131E SQL1585N and SQLSTATE=54048 can occur with Tivoli Storage Manager start failure

Operating System: Linux, Unix

Symptom
You may see the following startup failure when running server in the foreground:

ANR0131E tbrsql.c(1671): Server DB space exhausted.
ANR0162W Supplemental database diagnostic information: -1:54048:-1585
([IBM][CLI Driver][DB2/UnixLinux] SQL1585N A system temporary table space
with sufficient page size does not exist. SQLSTATE=54048 ).
ANR1912I Stopping the activity log because of a server shutdown.
ANR0369I Stopping the database manager because of a server shutdown.
ANR0991I Server shutdown complete.

You may also see the following errors in the db2diag.log:

2015-03-18-17.27.39.657215-300 I14006379A2082 LEVEL: Error (OS)
PID : 22778 TID : 18 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.150318222739
AUTHID : TSMINST1
EDUID : 18 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, mkdir
OSERR : EACCES (13) "Permission denied"
DATA #1 : String, 113 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission

Target file = /tmp/SQLDIR.LK0
DATA #2 : String, 192 bytes
Real user ID of current process = 44001
Effective user ID of current process = 44001
Real group ID of current process = 44001
Effective group ID of current process = 44001
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x00000001002b75c0
DATA #4 : String, 226 bytes
Information of each subdirectory leading up to the first inaccessible
one is shown in the format below :
<UID>:<GID>:<permissions> (subdirectories)
0:1:700 (tmp)
Cannot descend any further than the above subdirectory.

2015-03-18-17.27.39.660933-300 I14008462A624 LEVEL: Error
PID : 22778 TID : 18 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-7 APPID: *LOCAL.tsminst1.150318222739
AUTHID : TSMINST1
EDUID : 18 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code was "".
DATA #1 : <preformatted>
Cannot create /tmp/SQLDIR.LK0

Cause
Symptom is caused by a permission problem with directory "/tmp" or "/tmp/SQLDIR.LK0".
Root cause for the permission issue is not known.

Resolving the problem
Check the permissions for directory "/tmp" and "/tmp/SQLDIR.LK0". The "/tmp" directory should have permissions set to 1777 (rwxrwxrwt). "/tmp/SQLDIR.LK0" should have permissions set to 777 (rwxrwxrwx).
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top