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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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:\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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.45.015000 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000

PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.45.125000 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

PID:1828 TID:2988 Node:000 Title: SQLP_DBCB
Dump File:\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 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000

2004-05-07-13.30.45.343000 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282988.000

2004-05-07-13.30.45.406000 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.45.500000 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.45.656000 InstanceB2 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:\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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.46.062000 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

PID:1828 TID:2992 Node:000 Title: SQLP_ACB
Dump File:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

PID:1828 TID:2992 Node:000 Title: SQLP_DBCB
Dump File:\PROGRA~1\IBM\SQLLIB\DB2\18282992.000

2004-05-07-13.30.46.359000 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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".