When I tried to backup the database this morning it aborted.
This was in the DB2error log
2007-09-14-07.27.29.656000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSDoContainerOp Probe:815 Database:ARCHIVE
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8402001E".
2007-09-14-07.27.29.656001 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSDoContainerOp Probe:815 Database:ARCHIVE
Error checking container 0 (I:\arsdbsms\ARCHIVE\odadmin\ZZD1.0.0) for
tbsp 1090. Rc = 870F0011
2007-09-14-07.27.29.656002 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSStartPool Probe:105 Database:ARCHIVE
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8402001E".
2007-09-14-07.27.29.671000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbStartPools Probe:30 Database:ARCHIVE
ADM6023I The table space "ODADMIN_ZZD1" (ID "1090") is in state
0x"4000". The
table space cannot be accessed. Refer to the documentation for SQLCODE
-290.
2007-09-14-07.27.29.671001 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbStartPools Probe:30 Database:ARCHIVE
rc =
0x04FE91CC : 0x8402001E ...?
2007-09-14-07.27.30.750000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSDoContainerOp Probe:815 Database:ARCHIVE
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8402001E".
2007-09-14-07.27.30.750001 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSDoContainerOp Probe:815 Database:ARCHIVE
Error checking container 1 (I:\arsdbsms\ARCHIVE\odadmin\ZZC1.1.0) for
tbsp 1747. Rc = 870F0011
2007-09-14-07.27.30.765000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbSMSStartPool Probe:105 Database:ARCHIVE
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8402001E".
2007-09-14-07.27.30.765001 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbStartPools Probe:30 Database:ARCHIVE
ADM6023I The table space "ODADMIN_ZZC1" (ID "1747") is in state
0x"4000". The
table space cannot be accessed. Refer to the documentation for SQLCODE
-290.
2007-09-14-07.27.30.765002 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
buffer pool services sqlbStartPools Probe:30 Database:ARCHIVE
rc =
0x04FE91CC : 0x8402001E ...?
2007-09-14-07.27.33.000000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
database utilities sqlubcka Probe:0 Database:ARCHIVE
Starting a full database backup.
2007-09-14-07.27.39.171000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
database utilities sqlubBuildAppTbsp Probe:60 Database:ARCHIVE
0x04FEA5A0 : 0x8002014E N..?
2007-09-14-07.27.39.171001 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
database utilities sqlubBuildAppTbsp Probe:70 Database:ARCHIVE
DiagData
0x0503087C : 00F8 FFFF 4204 0000 0600 0000 .???B.......
2007-09-14-07.27.39.187000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
database utilities sqlubBuildAppTbsp Probe:70 Database:ARCHIVE
0x0503087C : 00F8 FFFF 4204 0000 0600 0000 .???B.......
2007-09-14-07.27.45.171000 Instance:DB2 Node:000
PID:5884(db2syscs.exe) TID:6860 Appid:*LOCAL.DB2.039CC4122727
database utilities sqlubcka Probe:140 Database:ARCHIVE
Backup Terminated.
Can anyone help me fix this problem?
Thank you,
Jim