Hi Seniors, Seeking assistance or clue on the below issue we facing recently. My QAS ERP is completely down for sometime due to this issue.
Error message when starting DB2:-
bash-3.00$ db2start
02/24/2011 17:21:57 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
bash-3.00$ db2 connect to QAS
SQL1042C An unexpected system error occurred. SQLSTATE=58004
bash-3.00$ db2 get db cfg
SQL1024N A database connection does not exist. SQLSTATE=08003
db2diag.log:- - Not full logs, need to deleted due to maximum length constrain.
2011-02-24-17.02.15.689455+480 I1A1233 LEVEL: Event
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 152 bytes
Instance "db2qas" uses "64" bits and DB2 code release "SQL09054"
with level identifier "06050107".
Informational tokens are "DB2 v9.5.0.4", "special_21925", "U825479_21925", Fix Pack "4".
DATA #2 : System Info, 1592 bytes
System: SunOS CSQT5ERP 5.10 Generic_142900-05 sun4v
CPU: total:128 online:128 Cores per socket:8 Threading degree per core:1
Physical Memory(MB): total:32544 free:28992
Virtual Memory(MB): total:177962 free:174410
Swap Memory(MB): total:145418 free:145418
Cur data size (bytes) = 0xFFFFFFFFFFFFFFFD
Cur stack size (bytes) = 0x0000000000800000
Cur core size (bytes) = 0x00000000FFFFFFFF
nofiles (descriptors) = 0x0000000000010000
2011-02-24-17.02.18.543076+480 I1700A429 LEVEL: Warning
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2011-02-24-17.02.20.992821+480 I3036A492 LEVEL: Warning
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 00000174E561AA75 MinbuffLSN
00000174E561AA75
2011-02-24-17.02.20.993782+480 E3529A446 LEVEL: Warning
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.
2011-02-24-17.02.21.530927+480 E4469A486 LEVEL: Warning
PID : 23743 TID : 293 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 293 EDUNAME: db2redom (QAS) 0
FUNCTION: DB2 UDB, recovery manager, sqlpParallelRecovery, probe:880
DATA #1 : <preformatted>
Resetting max shredder memory to 100045238 from 468172800
2011-02-24-17.02.21.574941+480 I4956A625 LEVEL: Severe
PID : 23743 TID : 174 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 174 EDUNAME: db2redow (QAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbFixDataEMP, probe:830
MESSAGE : ZRC=0x84020019=-2080243687=SQLB_EMP_INDIRECT_NOT_FOUND
"EMP INDIRECT NOT FOUND"
DATA #1 : <preformatted>
emp->n_entries = 3
emAddr[lvl].slot = 5
emp->allocations[emAddr[lvl].slot] = 0
emp->unFmtChild = 0.
2011-02-24-17.02.21.577057+480 I6088A522 LEVEL: Error
PID : 23743 TID : 174 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 174 EDUNAME: db2redow (QAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc, probe:820
DATA #1 : String, 89 bytes
Obj= State=x27 Parent={30;9032}, EM=51452, PP0=51454 Page=51453
2011-02-24-17.02.21.577899+480 I6611A969 LEVEL: Error
PID : 23743 TID : 174 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 174 EDUNAME: db2redow (QAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 72 bytes
Obj: Parent={30;9032}
lifeLSN: 00002CC0415B
tid: 0 0 0
extentAnchor: 51452
initEmpPages: 0
poolPage0: 51454
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 16384
extentSize: 2
bufferPoolID: 1
partialHash: 591921182
bufferPool: 0x0000010001ebb280
2011-02-24-17.02.21.579571+480 I8710A504 LEVEL: Error
PID : 23743 TID : 174 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 174 EDUNAME: db2redow (QAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbCheckAllocation, probe:800
MESSAGE : ZRC=0x84020019=-2080243687=SQLB_EMP_INDIRECT_NOT_FOUND
"EMP INDIRECT NOT FOUND"
2011-02-24-17.02.23.605521+480 I27354A552 LEVEL: Severe
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::RestartDatabase, probe:202
MESSAGE : If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again
2011-02-24-17.02.23.607663+480 I28352A477 LEVEL: Warning
PID : 23743 TID : 25 PROC : db2sysc 0
INSTANCE: db2qas NODE : 000 DB : QAS
APPHDL : 0-7 APPID: *LOCAL.db2qas.110224090215
AUTHID : DB2QAS
EDUID : 25 EDUNAME: db2agent (QAS) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbCleanupBeforeTerm, probe:826
DATA #1 : String, 41 bytes
Recovery failed, dirty pages not flushed.
Thanks in advance.
Devan
Edited by: Mdevan on Feb 24, 2011 10:41 AM Sorry the messages was not in a good format to read.
Edited by: Mdevan on Feb 24, 2011 10:43 AM
Edited by: Mdevan on Feb 24, 2011 10:44 AM