Skip to Content
0
Feb 24, 2011 at 09:41 AM

Unable to start DB2 9.5 in Solaris due to SQL1042C

171 Views

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