Discussion:
SQL1034C The database is damaged.
(too old to reply)
xixi
2003-08-05 20:26:47 UTC
Permalink
hello, i have created a database using DMS container, all the user
table is on the DMS. it is created on volume E. Every time when i try
to do a runstats or reorgchk, i got this error SQL1034C The database
is damaged. The application has been disconnected from the database.
All applications processing the database have been stopped. The DMS is
assigned 6G and existing. After that i can't do anything. Why is
that.? thanks
xixi
2003-08-06 18:01:42 UTC
Permalink
Hello PM,I get the log(not complete, i hope could email to you but the
email address not correct) and hope you could gives me some hint since
I am quite new on DB2.

I am using db2 udb v8.1 on windows-64 bit. The database created on D:
volume, and the userspace1 is DMS type (use raw device, unformatted)
and created on E: volume, volume E: has 10g , and I only use 5g for
the database. this is the first time I use DMS.

We have a request to create same kind of tables on DB2 just like on
AS400, total data take 4.5g. During the data migration time, I use
the explain sql to run a query to compare with SMS type database for
the total cost, I found the sql only took 10 millisecond. After the
migration done, don't know why yesterday when I rerun the query, it
takes 600 millisecond. Is it related to the database damage? I was
able to restore database so I can use the database again. I try to
exert the best performance for using DMS but looks like it is not.

Could you please help? At the mean time I will take a look at db2dart

Thank you very much


2003-08-06-11.11.24.270000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.11.24.360000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.11.24.380000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.11.24.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.11.24.420000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.11.24.470000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161113
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.11.29.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.11.29.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.11.29.830001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.11.29.940000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.29.980000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.30.500000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.30.630000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.11.30.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D2F0 0C00 0000
......Ò.....

2003-08-06-11.11.30.930000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFA9A000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.31.090000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.31.300000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDBDEAB8 : 0x86020001 ....

2003-08-06-11.11.31.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.31.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.32.110000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.32.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.11.32.600000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D2F0 0C00 0000
......Ò.....

2003-08-06-11.11.32.840000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFA9A000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.33.070000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.33.170000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDBDEABC : 0x86020001 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.33.280000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDBDEAD8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.33.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.420000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.460000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.520000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:1376 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:1376 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.33.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161129
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.710000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.33.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.34.250000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.34.370000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.11.34.510000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.11.34.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAB2000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB2010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB2020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.34.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.11.34.970000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDFDDF08 : 0x86020001 ....

2003-08-06-11.11.35.110000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.35.160000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.35.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.35.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.11.36.070000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.11.36.240000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAB2000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB2010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB2020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.36.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.11.36.400000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDFDDF0C : 0x86020001 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.11.36.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDFDDF28 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.11.36.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.36.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.36.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.36.690000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.36.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:3860 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:3860 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.11.37.030000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.37.060000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldRedo Probe:3852 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.37.090000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldmrdo Probe:767 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.37.120000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of LSN:
0x000006FBF336B9D2 : 0000 0080 267A ....&z

2003-08-06-11.11.37.220000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of log record:

0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.11.37.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

REDO returns -2046689279 on log record:
0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.37.460000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

extra info:
0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.11.37.590000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.37.630000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

qEntry for 000000000080267AentryFlags 1 queueId 13 waitOthers
0000000000000000 numBlocked 0 lrHeader:

0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.37.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
recovery manager sqlpresr Probe:640 Database:TOOLSDB

Crash recovery failed with rc -2046689279
LowtranLSN 0000000000800248 MinbuffLSN 00000000007FA00C
Recovery started on log file S0000000.LOG.

2003-08-06-11.11.37.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities recover Probe:16 Database:TOOLSDB

DiagData
0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.11.38.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities recover Probe:16 Database:TOOLSDB

0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.11.38.090000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities recover Probe:60 Database:TOOLSDB

ADM1532E Crash recovery has failed with SQLCODE "-1042".

2003-08-06-11.11.38.130000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqleMarkDBad Probe:10 Database:TOOLSDB

ADM7518C "TOOLSDB " marked bad.

2003-08-06-11.11.38.190000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqleMarkDBad Probe:210 Database:TOOLSDB

Database logging stopped due to mark db bad.

2003-08-06-11.11.38.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.11.38.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.11.38.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.11.38.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.11.38.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.11.38.800000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161129
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.11.43.970000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.11.44.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.11.44.130001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.11.44.230000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.44.260000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.44.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.44.910000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.11.45.060000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D2F0 0C00 0000
......Ò.....

2003-08-06-11.11.45.190000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.45.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.45.590000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDBDEAB8 : 0x86020001 ....

2003-08-06-11.11.45.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.45.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.46.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.46.550000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.11.46.710000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D2F0 0C00 0000
......Ò.....

2003-08-06-11.11.46.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.46.970000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.47.070000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDBDEABC : 0x86020001 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.47.170000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDBDEAD8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.47.290000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.370000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.400000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:1376 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:1376 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.47.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161143
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.610000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.47.650000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:4036 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.48.180000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.48.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBF3A9DEC8 : 0x00000000 ....

2003-08-06-11.11.48.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBF3A9DF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.11.48.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAA4000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA4010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA4020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.48.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBF3A9DEB8 : 0x00000000 ....

PID:2088 TID:4036 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.11.49.100000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBF3A9DF08 : 0x86020001 ....

2003-08-06-11.11.49.270000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.49.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:4036 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.49.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.50.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBF3A9DEC8 : 0x00000000 ....

2003-08-06-11.11.50.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBF3A9DF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.11.50.220000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAA4000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA4010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA4020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.50.290000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBF3A9DEB8 : 0x00000000 ....

PID:2088 TID:4036 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.11.50.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBF3A9DF0C : 0x86020001 ....

PID:2088 TID:4036 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.11.50.510000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBF3A9DF28 : 0x00000000 ....

PID:2088 TID:4036 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.11.50.600000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.50.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.50.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.50.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.50.690000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:4036 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:4036 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

PID:2088 TID:4036 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

PID:2088 TID:4036 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:2088 TID:4036 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

PID:2088 TID:4036 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

PID:2088 TID:4036 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:2088 TID:4036 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

PID:2088 TID:4036 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.11.51.010000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.51.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldRedo Probe:3852 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.51.080000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldmrdo Probe:767 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.51.120000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of LSN:
0x000006FBF336B9D2 : 0000 0080 267A ....&z

2003-08-06-11.11.51.230000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of log record:

0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.11.51.360000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

REDO returns -2046689279 on log record:
0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.51.500000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

extra info:
0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.11.51.650000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.51.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

qEntry for 000000000080267AentryFlags 1 queueId 13 waitOthers
0000000000000000 numBlocked 0 lrHeader:

0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.51.850000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
recovery manager sqlpresr Probe:640 Database:TOOLSDB

Crash recovery failed with rc -2046689279
LowtranLSN 0000000000800248 MinbuffLSN 00000000007FA00C
Recovery started on log file S0000000.LOG.

2003-08-06-11.11.51.960000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities recover Probe:16 Database:TOOLSDB

DiagData
0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.11.52.110000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities recover Probe:16 Database:TOOLSDB

0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.11.52.160000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities recover Probe:60 Database:TOOLSDB

ADM1532E Crash recovery has failed with SQLCODE "-1042".

2003-08-06-11.11.52.180000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqleMarkDBad Probe:10 Database:TOOLSDB

ADM7518C "TOOLSDB " marked bad.

2003-08-06-11.11.52.200000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqleMarkDBad Probe:210 Database:TOOLSDB

Database logging stopped due to mark db bad.

2003-08-06-11.11.52.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.11.52.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.11.52.760000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.11.52.800000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.11.52.820000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.11.52.850000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161143
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.11.58.030000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.11.58.110000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.11.58.180001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.11.58.280000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.58.300000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.58.800000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.11.58.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.11.58.990000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F047 CEF0 0C00 0000
.....GÎ.....

2003-08-06-11.11.59.090000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.11.59.190000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.11.59.330000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDBDEAB8 : 0x86020001 ....

2003-08-06-11.11.59.440000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.11.59.500000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.00.030000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.00.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.12.00.240000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F047 CEF0 0C00 0000
.....GÎ.....

2003-08-06-11.12.00.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.00.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.00.510000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDBDEABC : 0x86020001 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.00.610000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDBDEAD8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.00.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.00.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.00.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.00.810000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.00.840000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:1376 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:1376 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.01.010000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161157
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.01.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.01.080000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.01.610000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.01.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.12.01.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.12.02.010000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFABC000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFABC010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFABC020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.02.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.02.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDFDDF08 : 0x86020001 ....

2003-08-06-11.12.02.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.02.540000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.03.100000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.03.260000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.12.03.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.12.03.370000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFABC000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFABC010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFABC020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.03.430000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.03.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDFDDF0C : 0x86020001 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.03.610000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDFDDF28 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.03.690000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.03.710000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.03.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.03.760000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.03.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:3860 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:3860 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.04.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.04.080000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldRedo Probe:3852 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.04.110000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldmrdo Probe:767 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.04.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of LSN:
0x000006FBF336B9D2 : 0000 0080 267A ....&z

2003-08-06-11.12.04.240000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of log record:

0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.04.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

REDO returns -2046689279 on log record:
0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.04.460000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

extra info:
0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.04.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.04.630000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

qEntry for 000000000080267AentryFlags 1 queueId 13 waitOthers
0000000000000000 numBlocked 0 lrHeader:

0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.04.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
recovery manager sqlpresr Probe:640 Database:TOOLSDB

Crash recovery failed with rc -2046689279
LowtranLSN 0000000000800248 MinbuffLSN 00000000007FA00C
Recovery started on log file S0000000.LOG.

2003-08-06-11.12.04.870000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities recover Probe:16 Database:TOOLSDB

DiagData
0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.04.940000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities recover Probe:16 Database:TOOLSDB

0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.04.960000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities recover Probe:60 Database:TOOLSDB

ADM1532E Crash recovery has failed with SQLCODE "-1042".

2003-08-06-11.12.04.990000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqleMarkDBad Probe:10 Database:TOOLSDB

ADM7518C "TOOLSDB " marked bad.

2003-08-06-11.12.05.010000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqleMarkDBad Probe:210 Database:TOOLSDB

Database logging stopped due to mark db bad.

2003-08-06-11.12.05.470000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.12.05.560000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.12.05.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.12.05.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.12.05.650000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.12.05.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161157
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.12.10.870000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.12.10.960000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.12.11.040000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.12.11.130000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.11.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.11.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.11.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDEA78 : 0x00000000 ....

2003-08-06-11.12.11.910000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDEACC : 0000 0000 F007 D1F0 0C00 0000
......Ñ.....

2003-08-06-11.12.12.040000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.12.170000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDEA68 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.12.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDFDEAB8 : 0x86020001 ....

2003-08-06-11.12.12.510000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.12.550000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.13.120000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.13.280000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDEA78 : 0x00000000 ....

2003-08-06-11.12.13.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDEACC : 0000 0000 F007 D1F0 0C00 0000
......Ñ.....

2003-08-06-11.12.13.420000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.13.540000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDEA68 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.13.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDFDEABC : 0x86020001 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.13.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDFDEAD8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.13.850000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.13.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.13.910000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.13.940000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.13.970000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:3860 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:3860 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.14.140000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161210
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.14.180000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.14.210000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.14.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.14.890000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDDEC8 : 0x00000000 ....

2003-08-06-11.12.15.030000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDDF1C : 0000 0000 B414 5D11 0C00 0000
....´.].....

2003-08-06-11.12.15.190000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAB6000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB6010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB6020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.15.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDDEB8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.15.550000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDBDDF08 : 0x86020001 ....

2003-08-06-11.12.15.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.15.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.16.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.16.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDDEC8 : 0x00000000 ....

2003-08-06-11.12.16.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDDF1C : 0000 0000 B414 5D11 0C00 0000
....´.].....

2003-08-06-11.12.16.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAB6000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB6010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAB6020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.16.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDDEB8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.16.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDBDDF0C : 0x86020001 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.16.920000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDBDDF28 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.17.070000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.100000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.140000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.170000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.210000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:1376 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:1376 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:2088 TID:1376 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:2088 TID:1376 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.17.660000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldRedo Probe:3852 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldmrdo Probe:767 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.17.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of LSN:
0x000006FBF336B9D2 : 0000 0080 267A ....&z

2003-08-06-11.12.17.940000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of log record:

0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.18.100000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

REDO returns -2046689279 on log record:
0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.18.250000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

extra info:
0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.18.410000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.18.460000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

qEntry for 000000000080267AentryFlags 1 queueId 13 waitOthers
0000000000000000 numBlocked 0 lrHeader:

0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.18.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
recovery manager sqlpresr Probe:640 Database:TOOLSDB

Crash recovery failed with rc -2046689279
LowtranLSN 0000000000800248 MinbuffLSN 00000000007FA00C
Recovery started on log file S0000000.LOG.

2003-08-06-11.12.18.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities recover Probe:16 Database:TOOLSDB

DiagData
0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.18.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities recover Probe:16 Database:TOOLSDB

0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.18.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities recover Probe:60 Database:TOOLSDB

ADM1532E Crash recovery has failed with SQLCODE "-1042".

2003-08-06-11.12.18.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqleMarkDBad Probe:10 Database:TOOLSDB

ADM7518C "TOOLSDB " marked bad.

2003-08-06-11.12.18.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqleMarkDBad Probe:210 Database:TOOLSDB

Database logging stopped due to mark db bad.

2003-08-06-11.12.19.190000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.12.19.230000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.12.19.250000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.12.19.280000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.12.19.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.12.19.330000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161210
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.12.24.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.12.24.560000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.12.24.620001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.12.24.710000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.24.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.25.220000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.25.320000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.12.25.410000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D1F0 0C00 0000
......Ñ.....

2003-08-06-11.12.25.540000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFA9A000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.25.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.25.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDBDEAB8 : 0x86020001 ....

2003-08-06-11.12.25.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.25.940000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.26.470000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.26.570000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000 ....

2003-08-06-11.12.26.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDBDEACC : 0000 0000 F007 D1F0 0C00 0000
......Ñ.....

2003-08-06-11.12.26.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFA9A000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFA9A020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.26.890000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDBDEA68 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.27.030000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDBDEABC : 0x86020001 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.27.160000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDBDEAD8 : 0x00000000 ....

PID:2088 TID:1376 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.27.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.430000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.480000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:1376 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:1376 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

PID:2088 TID:1376 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881376.000

2003-08-06-11.12.27.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161224
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.27.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.28.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.28.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.12.28.690000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.12.28.860000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAA0000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA0010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA0020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.29.040000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.29.270000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDFDDF08 : 0x86020001 ....

2003-08-06-11.12.29.480000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.29.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.30.040000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDDFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDDFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDDFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDDFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDDFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.30.120000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDDEC8 : 0x00000000 ....

2003-08-06-11.12.30.210000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDDF1C : 0000 0000 0000 0000 0C00 0000
............

2003-08-06-11.12.30.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAA0000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA0010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAA0020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.30.400000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDDEB8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.30.520000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDFDDF0C : 0x86020001 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.30.630000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDFDDF28 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.30.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.30.770000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.30.790000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.30.820000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.30.860000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:3860 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:3860 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:2088 TID:3860 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.31.390000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.31.680000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldRedo Probe:3852 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.32.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldmrdo Probe:767 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.33.120000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of LSN:
0x000006FBF336B9D2 : 0000 0080 267A ....&z

2003-08-06-11.12.34.800000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
data management sqldmrdo Probe:767 Database:TOOLSDB

Error during REDO of log record:

0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.37.630000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

REDO returns -2046689279 on log record:
0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.38.480000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpRecDbRedo Probe:160 Database:TOOLSDB

extra info:
0x000006FBF4A9968E : 0176 0000 0F00 0000 2705 0000 4900 2F04
.v......'...I./.
0x000006FBF4A9969E : 7F04 0000 4900 0100 1B00 1B00 0800 2300
....I.........#.
0x000006FBF4A996AE : 0800 2B00 0800 3300 0E00 FFFE 5947 4747
..+...3.....YGGG
0x000006FBF4A996BE : 4747 4747 5553 5953 4942 4D20 2041 444D
GGGGUSYSIBM ADM
0x000006FBF4A996CE : 494E 2020 2053 5953 544F 4F4C 534D 4453 IN
SYSTOOLSMDS
0x000006FBF4A996DE : 4348 4544 4556 454E 5430 30
CHEDEVENT00

2003-08-06-11.12.39.800000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.41.450000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpPRecProcLog Probe:250 Database:TOOLSDB

qEntry for 000000000080267AentryFlags 1 queueId 13 waitOthers
0000000000000000 numBlocked 0 lrHeader:

0x000006FBF336B9D8 : 5B00 0000 4E00 0000 0000 0080 2626 0000
[...N.......&&..
0x000006FBF336B9E8 : 0000 00E0 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.44.340000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
recovery manager sqlpresr Probe:640 Database:TOOLSDB

Crash recovery failed with rc -2046689279
LowtranLSN 0000000000800248 MinbuffLSN 00000000007FA00C
Recovery started on log file S0000000.LOG.

2003-08-06-11.12.45.340001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities recover Probe:16 Database:TOOLSDB

DiagData
0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.45.410000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities recover Probe:16 Database:TOOLSDB

0x000006FBF369CB3C : 0x86020001 ....

2003-08-06-11.12.45.430000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities recover Probe:60 Database:TOOLSDB

ADM1532E Crash recovery has failed with SQLCODE "-1042".

2003-08-06-11.12.45.460000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqleMarkDBad Probe:10 Database:TOOLSDB

ADM7518C "TOOLSDB " marked bad.

2003-08-06-11.12.45.480000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqleMarkDBad Probe:210 Database:TOOLSDB

Database logging stopped due to mark db bad.

2003-08-06-11.12.45.990000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqleInitEngineComponents Probe:202
Database:TOOLSDB

If 'DATALINK: file server not registered' appears above and
DATALINKS=NO, set DATALINKS=YES and try RESTART again

2003-08-06-11.12.47.510000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqlesrsu Probe:140 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBEE".

2003-08-06-11.12.47.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
data protection sqlpthrd Probe:440 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.12.49.490000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
buffer pool services sqlbTerminateAgent Probe:837 Database:TOOLSDB

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.12.49.880000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqleAgentDissociate Probe:90 Database:TOOLSDB

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.12.50.260000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:956 Appid:none
data protection sqlpgsck Probe:100

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".

2003-08-06-11.12.50.420000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161224
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.12.56.270000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161256
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.12.56.350000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161256
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.12.56.400001 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1616 Appid:*LOCAL.DB2.003A46161256
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.12.56.480000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.56.500000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.57.010000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.57.080000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDEA78 : 0x00000000 ....

2003-08-06-11.12.57.160000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDEACC : 0000 0000 F047 D0F0 0C00 0000
.....GÐ.....

2003-08-06-11.12.57.230000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.57.300000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDEA68 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.57.400000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBEDFDEAB8 : 0x86020001 ....

2003-08-06-11.12.57.470000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.57.500000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:3860 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.57.970000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDFDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDFDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDFDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDFDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDFDEB98 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.58.050000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDFDEA78 : 0x00000000 ....

2003-08-06-11.12.58.150000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBEDFDEACC : 0000 0000 F047 D0F0 0C00 0000
.....GÐ.....

2003-08-06-11.12.58.220000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFAAA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFAAA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.58.290000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBEDFDEA68 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.58.380000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbReadPage Probe:73 Database:TOOLSDB

** Second read was also unsucessful **
0x000006FBEDFDEABC : 0x86020001 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE2
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.58.530000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBEDFDEAD8 : 0x00000000 ....

PID:2088 TID:3860 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.58.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.650000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.700000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.720000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:2088 TID:3860 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:2088 TID:3860 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

PID:2088 TID:3860 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20883860.000

2003-08-06-11.12.58.840000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:3860 Appid:*LOCAL.DB2.003A46161256
data management sqldFixTCBObj Probe:1927 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.870000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.58.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:4036 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.59.410000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.12.59.520000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBF3A9DEC8 : 0x00000000 ....

2003-08-06-11.12.59.590000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB

DiagData
0x000006FBF3A9DF1C : 0000 0000 B414 5D11 0C00 0000
....´.].....

2003-08-06-11.12.59.660000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:74 Database:TOOLSDB

DiagData
0x000006FBEFADA000 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFADA010 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEFADA020 : 0000 0000 0000 0000 0000 0000 0000 0000
................

2003-08-06-11.12.59.730000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:75 Database:TOOLSDB

DiagData
0x000006FBF3A9DEB8 : 0x00000000 ....

PID:2088 TID:4036 Node:000 Title: SQLB_PAGE
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20884036.000

2003-08-06-11.12.59.830000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbReadPage Probe:71 Database:TOOLSDB

** Failure on first attempt to read the page **

0x000006FBF3A9DF08 : 0x86020001 ....

2003-08-06-11.12.59.900000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.12.59.920000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:4036 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.13.00.410000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBF3A9DFA8 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBF3A9DFB8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBF3A9DFC8 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBF3A9DFD8 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBF3A9DFE8 : 103C 23F4 FB06 0000 50BE CFF5 FB06 0000
.<#.....P¾Ï.....

2003-08-06-11.13.00.550000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBF3A9DEC8 : 0x00000000 ....

2003-08-06-11.13.00.620000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:4036 Appid:*LOCAL.DB2.003A46161256
buffer pool services sqlbrdpg Probe:73 Database:TOOLSDB
Fan Ruo Xin
2003-08-07 00:47:35 UTC
Permalink
1. The best way is do a restore db.

2. If this is a production system, and there is no any backup available,
or for what ever reason you can't do a restore. You'd better contact IBM
support, even they will ask you do the same thing as the people tell you
here.

3. If you can connect to the database (NJIDATA), connect to this db. If
you can't, use "restart database njidata"
If you don't care the table which has bad pages, or it is easy for you
to rebuild it. You can just drop this table. If you still want to save as
much data as possible, then export the data from this table to an external
file before you drop it.
Restart the database. Check the db2diag.log to see if there is still
some error. You can also do a whole db check:
shut down the database.
db2dart njidata /DB
check the db2dart report.

4. In most cases when the data pages got bad - this is because the
hardware problems - and I do suspect this is your case too. When this
happened, db2 server need to gurantee the consistence of the db data, it
has to mark the database as bad and prevent you change the table which has
bad pages.

5. If the tablespaces after you drop the table still have problem, post
snapshot result:
get snapshot for tablespaces


Regards,
FRX
xixi
2003-08-07 19:18:36 UTC
Permalink
hello fan, i keep getting some file with ext .0 or .000 at the
directory Program Files\IBM\SQLLIB\DB2, and db2diag.log size keeps
increasing, the error basically like this as below, do i need to
reinstall the toolsdb. can i delete the .0 or .000 file? since they
take too much space. i don't know what is the problem with database
toolsdb. please help. thanks

2003-08-07-10.23.37.820000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
buffer pool services sqlbReadPage Probe:74 Database:TOOLSDB

** Page off disk *****
0x000006FBA739DF28 : 0x00000000 ....

PID:1116 TID:3124 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

2003-08-07-10.23.37.920000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
buffer pool services sqlbReadPage Probe:1140 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-07-10.23.37.950000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
data management loadSMSDesc Probe:1171 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-07-10.23.37.980000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
data management loadSMSDesc Probe:1268 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-07-10.23.38.000000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-07-10.23.38.050000 Instance:DB2 Node:000
PID:1116(db2syscs.exe) TID:3124 Appid:*LOCAL.DB2.00F407152328
data management sqldLoadTCBObjDesc Probe:1744 Database:TOOLSDB

Error loading object descriptor.

PID:1116 TID:3124 Node:000 Title: SQLD_TCB:
Perm Table(0:15)=TBSPACEID=0.TABLEID=15

PID:1116 TID:3124 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

PID:1116 TID:3124 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

PID:1116 TID:3124 Node:000 Title: SQLD_IXCB:
rootPage=2, itoken=0

PID:1116 TID:3124 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

PID:1116 TID:3124 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

PID:1116 TID:3124 Node:000 Title: SQLD_IXCB:
rootPage=3, itoken=0

PID:1116 TID:3124 Node:000 Title: SQLD_IXCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000

PID:1116 TID:3124 Node:000 Title: SQLD_IDEF
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\11163124.000
xixi
2003-08-07 22:39:04 UTC
Permalink
hello fan, based on post, i am not sure i should drop toolsdb database
and recreate it to fix the bad page error. is this the right way? will
it affect the existing database? is create tools catalog right
command? create tools catalog catalog create new database toolsdb?

right now when i try to view the tooldb from control center, i always
get SQL1042C An unexpected system error occurred.

please help.
P. Saint-Jacques
2003-08-08 02:26:29 UTC
Permalink
Xixi, dropping the tools db will not affect your actual db. It is used
to track,amongst other things, the tasks that you build and schedule
using the task center. It does not touch your db or its objects.

From the online docs, here's the command:

The user must also have DASADM authority to update the DB2
administration server configuration parameters.

Required connection

A database connection is temporarily established by this command during
processing. This command will optionally stop and restart the database
manager if new table spaces are created.

Command syntax
-CREATE TOOLS CATALOG--catalog-name--------------------------->
--+-CREATE NEW
DATABASE--database-name-----------------------------------------+-->
'-USE
EXISTING--+---------------------------------+--DATABASE--database-name-'
'-TABLESPACE--tablespace-name--IN-'
--+-------+--+---------------+--------------------------------><
'-FORCE-' '-KEEP INACTIVE-'

HTH, Pierre.
hello fan, based on post, i am not sure i should drop toolsdb database
and recreate it to fix the bad page error. is this the right way? will
it affect the existing database? is create tools catalog right
command? create tools catalog catalog create new database toolsdb?
right now when i try to view the tooldb from control center, i always
get SQL1042C An unexpected system error occurred.
please help.
xixi
2003-08-06 21:03:49 UTC
Permalink
hello PM, more info. i look at the db2diag.log. Found that
DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.13.09.780000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
buffer pool services sqlbrdpg Probe:1143 Database:NJIDATA

Obj={pool:2;obj:4;type:0} State=x25 Parent={2;4}, EM=48, PP0=64
Page=64 Cont=0 Offset=80 BlkSize=12

then i use this query

select tabname, tabschema from syscat.tables
where tbspaceid = 2 and tableid = 4

to find out which tables exist on the page. so what should i do with
that? how the bad page happened?

when i encounter the database is damaged error, i thougth because of
the database manager not installed properly. but after i try to do
reorgchk on other database on the same server, i don't encounter the
error. looks like it happened to the database with DMS container on
different volume . please help.

i found the bad page error happened to toolsdb and njidata. toolsdb
created when the db2 install. njidata is the one i care. so do i need
to drop database toolsdb.

for database njidata, i found this error
buffer pool services sqlbTerminateAgent Probe:837 Database:NJIDATA

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-08-06-11.13.27.240000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
base sys utilities sqleAgentDissociate Probe:90 Database:NJIDATA

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".

2003-08-06-11.13.27.300000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
base sys utilities sqleTermDbConnect Probe:110

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.13.27.380000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:none
DRDA Application Server sqljsCleanup Probe:60

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".

2003-08-06-11.13.29.310000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.003A46161329
base sys utilities sqledint Probe:30

Crash Recovery is needed.

2003-08-06-11.13.29.520000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.003A46161329
recovery manager sqlpresr Probe:410 Database:TOOLSDB

Crash recovery started. LowtranLSN 0000000000909EC4 MinbuffLSN
00000000007FA00C

2003-08-06-11.13.29.750000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.003A46161329
recovery manager sqlprecm Probe:125 Database:TOOLSDB

Using parallel recovery with 3 agents 5 QSets 35 queues and 2 chunks


2003-08-06-11.13.29.920000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161329
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.13.29.980000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161329
buffer pool services sqlbrdpg Probe:1143 Database:TOOLSDB

Obj={pool:0;obj:15;type:0} State=x4 Page=0 Cont=0 Offset=0 BlkSize=12
BadPage

PID:2088 TID:1376 Node:000 Title: SQLB_OBJECT_DESC
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 5090 D2F0 FB06 0000 7093 D2F0 FB06 0000
P.Ò.....p.Ò.....

2003-08-06-11.13.30.590000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161329
buffer pool services sqlbrdpg Probe:71 Database:TOOLSDB

DiagData
0x000006FBEDBDEB58 : 0000 0F00 0000 0F00 0000 0000 0000 0000
................
0x000006FBEDBDEB68 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x000006FBEDBDEB78 : 0000 0000 0101 0000 0400 0000 0000 0000
................
0x000006FBEDBDEB88 : 0010 0000 2000 0000 0100 0000 0000 0F00 ....
...........
0x000006FBEDBDEB98 : 5090 D2F0 FB06 0000 7093 D2F0 FB06 0000
P.Ò.....p.Ò.....

2003-08-06-11.13.30.670000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1376 Appid:*LOCAL.DB2.003A46161329
buffer pool services sqlbrdpg Probe:72 Database:TOOLSDB

DiagData
0x000006FBEDBDEA78 : 0x00000000

i found the whole log with error the database is damaged happend to
toolsdb except this one to njidata. does that related? please advise.
xixi
2003-08-06 21:11:20 UTC
Permalink
hello pm, more info from the log.

2003-08-06-11.13.17.420000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
buffer pool services sqlbReadPage Probe:74 Database:NJIDATA

** Page off disk *****
0x000006FBF82A51A8 : 0x00000000 ....

PID:2088 TID:1944 Node:000 Title: SQLB_PAGE3
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881944.000

2003-08-06-11.13.17.580000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
buffer pool services sqlbReadPage Probe:1140 Database:NJIDATA

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.13.17.600000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
data management loadDMSDescFromOTR Probe:11 Database:NJIDATA

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.13.17.640000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
data management loadDMSDescFromOTR Probe:12 Database:NJIDATA

Page 0 of object cannot be accessed!

0x000006FBF422BAD8 : 0200 0400 0200 0400 0000 0000 0000 006D ...............m
0x000006FBF422BAE8 : 65A0 0000 0000 0000 3000 0000 0000 0000 e.......0.......
0x000006FBF422BAF8 : 4000 0000 0201 0000 2501 0000 0000 0000 @.......%.......
0x000006FBF422BB08 : 0010 0000 1000 0000 0100 0000 0200 0400 ................
0x000006FBF422BB18 : B091 66F4 FB06 0000 D094 66F4 FB06 0000 ..f.....Ð.f.....

2003-08-06-11.13.17.740000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
data management loadDMSDesc Probe:1637 Database:NJIDATA

DIA8400C A bad page was encountered.
ZRC=0x86020001

PID:2088 TID:1944 Node:000 Title: Object descriptor:
0x000006FBF422BAD8 : 0200 0400 0200 0400 0000 0000 0000 006D ...............m
0x000006FBF422BAE8 : 65A0 0000 0000 0000 3000 0000 0000 0000 e.......0.......
0x000006FBF422BAF8 : 4000 0000 0201 0000 2701 0000 0000 0000 @.......'.......
0x000006FBF422BB08 : 0010 0000 1000 0000 0100 0000 0200 0400 ................
0x000006FBF422BB18 : B091 66F4 FB06 0000 D094 66F4 FB06 0000 ..f.....Ð.f.....

2003-08-06-11.13.17.810000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
data management sqldLoadTCB Probe:4196 Database:NJIDATA

DIA8400C A bad page was encountered.
ZRC=0x86020001

2003-08-06-11.13.17.840000 Instance:DB2 Node:000
PID:2088(db2syscs.exe) TID:1944 Appid:*LOCAL.DB2.014F46161049
data management sqldLoadTCB Probe:4196 Database:NJIDATA

Error loading TCB. tcbFlags =
0x000006FBF82A5A80 : 0x00000014 ....

PID:2088 TID:1944 Node:000 Title: SQLD_TCB:
Perm Table(2:4)=TBSPACEID=2.TABLEID=4

PID:2088 TID:1944 Node:000 Title: SQLD_TCB_NAME
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881944.000

PID:2088 TID:1944 Node:000 Title: SQLD_TCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\20881944.000

can you tell me what dump file means?


Error loading TCB. what is TCB?

what is Page 0 of object cannot be accessed!

thank you very much
xixi
2003-08-06 22:52:43 UTC
Permalink
hi PM, i got this , can you tell me what the 8012007E represent? thanks

2003-08-06-11.19.28.090000 Instance:DB2 Node:000
PID:1748(db2syscs.exe) TID:2480 Appid:*LOCAL.DB2.011B06161900
relation data serv sqlrr_rds_common_post Probe:140 Database:NJIDATA

0x000006FBF0B3D028 : 0x8012007E ~...

PID:1748 TID:2480 Node:000 Title: UCstate:
0x000006FBF5CF7178 : 0x04000142 B...

PID:1748 TID:2480 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1034 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrco1~
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Loading...