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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.