Running 8.1 w/FP5 on Windows 2000. Everytime I try to create a stored
procedure, I get the following error saying that my database is
damaged:
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1034C The database is damaged. All applications processing the
database
have been stopped. SQLSTATE=58031
Here's what's in my db2diag.log...any ideas...this is driving me nuts.
2004-05-07-13.30.43.515000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
global services sqlzerdm Probe:40 Database:GIM
0x06579C80 : 0x860F000A ...†
2004-05-07-13.30.44.328000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
relation data serv sqlrr_rds_common_post Probe:140 Database:GIM
0x0657D46C : 0x860F000A ...†
PID:1828 TID:3468 Node:000 Title: UCstate:
0x044D3A50 : 0x04000042 B...
PID:1828 TID:3468 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -980 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLND04F
sqlerrd : (1) 0x860F000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF60 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2004-05-07-13.30.44.390000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
base sys utilities sqleMarkDBad Probe:10 Database:GIM
ADM7518C "GIM " marked bad.
2004-05-07-13.30.44.468000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
base sys utilities sqleMarkDBad Probe:210 Database:GIM
Database logging stopped due to mark db bad.
2004-05-07-13.30.44.531000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
DRDA Application Server sqljsTermAgentReply Probe:10 Database:GIM
DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The
diagnostic data
returned is (SRVDGN): "SQLERRP:SQLND04F SQLCODE:-980".
ALERT :26
PID:1828 TID:3468 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -980 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLND04F
sqlerrd : (1) 0x860F000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF60 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2004-05-07-13.30.44.593000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
relation data serv sqlrr_rds_common_post Probe:140 Database:GIM
0x0657D18C : 0x8012007E ~..€
PID:1828 TID:3468 Node:000 Title: UCstate:
0x044D3A50 : 0x04000142 B...
PID:1828 TID:3468 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:
2004-05-07-13.30.44.640000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
base sys utilities sqlesrsp Probe:90 Database:GIM
DiagData
0x0657D540 : 0xFFFFFBF6 öûÿÿ
2004-05-07-13.30.44.718000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
base sys utilities sqlesrsp Probe:90 Database:GIM
0x0657D540 : 0xFFFFFBF6 öûÿÿ
2004-05-07-13.30.44.796000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:3468 Appid:*LOCAL.DB2.017047173020
DRDA Application Server sqljsCleanup Probe:60 Database:GIM
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".
2004-05-07-13.30.44.796001 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
relation data serv sqlrr_rds_common_post Probe:140 Database:GIM
0x05BDD18C : 0x8012007E ~..€
2004-05-07-13.30.44.796002 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpgild Probe:310 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
PID:1828 TID:2988 Node:000 Title: UCstate:
0x0428F890 : 0x04000142 B...
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2988 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:
2004-05-07-13.30.44.921000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpEndUowRuntime Probe:2450 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.44.937000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
base sys utilities sqlesrsp Probe:90 Database:GIM
DiagData
0x05BDD540 : 0xFFFFFBF6 öûÿÿ
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.45.015000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
base sys utilities sqlesrsp Probe:90 Database:GIM
0x05BDD540 : 0xFFFFFBF6 öûÿÿ
2004-05-07-13.30.45.031000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpxrbk Probe:6910 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.046000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
data protection sqlpgild Probe:310 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.078000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpxrbk Probe:4440 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
PID:1828 TID:2988 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.45.125000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
data protection sqlpEndUowRuntime Probe:2450 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2988 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000
PID:1828 TID:2992 Node:000 Title: cr_error:
0x042558D4 : 0x00000001 ....
2004-05-07-13.30.45.203000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
data protection sqlpxrbk Probe:6910 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.218000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrrbck_dps Probe:20 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.265000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
data protection sqlpxrbk Probe:4440 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
PID:1828 TID:2992 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:
PID:1828 TID:2988 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000
2004-05-07-13.30.45.343000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
global services sqlzerdm Probe:40 Database:GIM
0x05C3D1C4 : 0x8610000D ...†
PID:1828 TID:2988 Node:000 Title: SQLP_ACB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000
2004-05-07-13.30.45.406000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
data protection sqlptfrg Probe:2200 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.421000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrrbck Probe:40 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
2004-05-07-13.30.45.453000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
relation data serv sqlrr_appl_term Probe:110 Database:GIM
DIA8414C Logging can not continue due to an error.
ZRC=0x8610000Dÿ
PID:1828 TID:2992 Node:000 Title: SQLP_TENTRY
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.45.500000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
relation data serv sqlrr_appl_term Probe:999 Database:GIM
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:
2004-05-07-13.30.45.531000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpxrbk Probe:2050 Database:GIM
DIA8039C XA error with request type of "". XA protocol error.
ZRC=0x80100027ÿ
2004-05-07-13.30.45.593000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
base sys utilities sqlesrsp Probe:57 Database:GIM
DiagData
0x05BDD544 : 0x8610000D ...†
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.45.656000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2988 Appid:*LOCAL.DB2.018947172756
DRDA Application Server sqljsCleanup Probe:60 Database:GIM
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".
PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2992 Node:000 Title: cr_error:
0x042558D4 : 0x00000001 ....
2004-05-07-13.30.45.796000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrrbck_dps Probe:20 Database:GIM
DIA8039C XA error with request type of "". XA protocol error.
ZRC=0x80100027ÿ
PID:1828 TID:2992 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -984 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrbkd
sqlerrd : (1) 0x8610000D (2) 0xFFFFFC2C (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2004-05-07-13.30.45.843000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrrbck Probe:40 Database:GIM
DIA8039C XA error with request type of "". XA protocol error.
ZRC=0x80100027ÿ
2004-05-07-13.30.45.875000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrr_rds_common_post Probe:78 Database:GIM
DIA8039C XA error with request type of "". XA protocol error.
ZRC=0x80100027ÿ
2004-05-07-13.30.45.890000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrr_rds_common_post Probe:140 Database:GIM
0x05C3D18C : 0x8012007E ~..€
PID:1828 TID:2992 Node:000 Title: UCstate:
0x04256DC0 : 0x04000142 B...
PID:1828 TID:2992 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -984 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrbkd
sqlerrd : (1) 0x8610000D (2) 0xFFFFFC2C (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2004-05-07-13.30.45.937000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqlesrsp Probe:90 Database:GIM
DiagData
0x05C3D540 : 0xFFFFFBF6 öûÿÿ
2004-05-07-13.30.45.984000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqlesrsp Probe:90 Database:GIM
0x05C3D540 : 0xFFFFFBF6 öûÿÿ
PID:1828 TID:2992 Node:000 Title: SQLP_TENTRY
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.46.062000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlptfrg Probe:1390 Database:GIM
DIA8526C A fatal error occurred in data protection services.
ZRC=0x8710001Dÿ
2004-05-07-13.30.46.078000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrr_appl_term Probe:110 Database:GIM
DIA8526C A fatal error occurred in data protection services.
ZRC=0x8710001Dÿ
2004-05-07-13.30.46.093000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
relation data serv sqlrr_appl_term Probe:999 Database:GIM
SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -984 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlrrbkd
sqlerrd : (1) 0x8610000D (2) 0xFFFFFC2C (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2004-05-07-13.30.46.156000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqlesrsp Probe:57 Database:GIM
DiagData
0x05C3D544 : 0x8710001D ...‡
2004-05-07-13.30.46.203000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpthrd Probe:440 Database:GIM
DIA8427C The database has been marked as being damaged.
ZRC=0x8602001Aÿ
2004-05-07-13.30.46.234000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
buffer pool services sqlbTerminateAgent Probe:837 Database:GIM
DIA8427C The database has been marked as being damaged.
ZRC=0x8602001Aÿ
2004-05-07-13.30.46.265000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqleAgentDissociate Probe:90 Database:GIM
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x06000000".
PID:1828 TID:2992 Node:000 Title: SQLP_TENTRY
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000
2004-05-07-13.30.46.359000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlptfrg Probe:1390 Database:GIM
DIA8526C A fatal error occurred in data protection services.
ZRC=0x8710001Dÿ
2004-05-07-13.30.46.375000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
data protection sqlpdenv Probe:650 Database:GIM
DIA8526C A fatal error occurred in data protection services.
ZRC=0x8710001Dÿ
2004-05-07-13.30.46.390000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqleAgentDissociate Probe:120 Database:GIM
DIA8526C A fatal error occurred in data protection services.
ZRC=0x8710001Dÿ
2004-05-07-13.30.46.406000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
base sys utilities sqleTermDbConnect Probe:110 Database:GIM
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".
2004-05-07-13.30.47.140000 Instance:DB2 Node:000
PID:1828(db2syscs.exe) TID:2992 Appid:*LOCAL.DB2.018947172757
DRDA Application Server sqljsCleanup Probe:60 Database:GIM
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF6".