Hello,
What do you see in your db2diag.log?
Quite a lot.
I assume that the reboot might have resulted in a DB2 crash, and the
subsequent attempts to connect initiated the crash recovery mechanisms.
The db2diag.log should tell you that and also what happened before.
I think you a right... and the log has a lot of entries since the crash.
But what can I do to fix it?
Crash recovery started. LowtranLSN 00000002D7BB800C MinbuffLSN
00000002D7BB800C
2004-09-27-17.09.15.523689 Instance:db2inst1 Node:000
PID:1426(db2agent (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
recovery manager sqlprecm Probe:125 Database:TISYS
Using parallel recovery with 3 agents 4 QSets 28 queues and 8 chunks
2004-09-27-17.09.15.712260 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
buffer pool services sqlbFreeUpSlot Probe:122 Database:TISYS
ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in use.
Refer to the documentation for SQLCODE -1218.
PID:1435 TID:16384 Node:000 Title: Not available!
Could not fix page for objID=42, tbspaceID=2, objType=1, parentObjID=42
parentTbspaceID=2.
PID:1435 TID:16384 Node:000 Title: Not available!
Current size of bufferpool #4096: 16 slots.
2004-09-27-17.09.16.336416 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
index manager sqliRedo Probe:811 Database:TISYS
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8502002C".
PID:1435 TID:16384 Node:000 Title: SQLP_LSN
0002 d7bb 8124 .....$
PID:1435 TID:16384 Node:000 Title: SQLI_LRH
028d 0200 2a00 0200 2a00 0100 1500 0000 ....*...*.......
2004-09-27-17.09.16.376109 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
data management sqldmrdo Probe:765 Database:TISYS
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8502002C".
2004-09-27-17.09.16.392407 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
data management sqldmrdo Probe:765 Database:TISYS
Error during REDO of LSN: 0002 d7bb 8124
......$
2004-09-27-17.09.16.417418 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
data management sqldmrdo Probe:765 Database:TISYS
Error during REDO of log record:
028d 0200 2a00 0200 2a00 0100 1500 0000 ....*...*.......
1600 0000 0001 0000 0300 0000 0100 0400 ................
0402 0004 0000 43 ......C
2004-09-27-17.09.16.422757 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
recovery manager sqlpRecDbRedo Probe:160 Database:TISYS
REDO returns -2063466452 on log record: 2700 0000 4e00 0000 0002 d7bb
800c 0000 '...N...........
0008 a8b5 0000 0000 0000 0000 0000 0000 ................
2004-09-27-17.09.16.427703 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
recovery manager sqlpRecDbRedo Probe:160 Database:TISYS
extra info: 028d 0200 2a00 0200 2a00 0100 1500 0000 ....*...*.......
1600 0000 0001 0000 0300 0000 0100 0400 ................
0402 0004 0000 43 ......C
2004-09-27-17.09.16.433605 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
recovery manager sqlpPRecProcLog Probe:250 Database:TISYS
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8502002C".
2004-09-27-17.09.16.435746 Instance:db2inst1 Node:000
PID:1435(db2agnsc (TISYS)) TID:16384 Appid:*LOCAL.db2inst1.0C5007150914
recovery manager sqlpPRecProcLog Probe:250 Database:TISYS
qEntry for 00000002D7BB8124entryFlags 1 queueId 1 waitOthers (nil)
numBlocked 0 lrHeader:
2700 0000 4e00 0000 0002 d7bb 800c 0000 '...N...........
0008 a8b5 0000 0000 0000 0000 0000 0000 ................