This is a discussion on SQL1034C creating a stored procedure on 8.1 Fixpak 5 within the DB2 forums, part of the Database Server Software category; --> Running 8.1 w/FP5 on Windows 2000. Everytime I try to create a stored procedure, I get the following error ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2004-05-07-13.30.45.015000 Instance 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 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 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 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 PID:1828 TID:2992 Node:000 Title: SQLP_DBCB Dump File 2004-05-07-13.30.45.125000 Instance 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 PID:1828 TID:2988 Node:000 Title: SQLP_DBCB Dump File PID:1828 TID:2992 Node:000 Title: cr_error: 0x042558D4 : 0x00000001 .... 2004-05-07-13.30.45.203000 Instance 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 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 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 2004-05-07-13.30.45.343000 Instance 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 2004-05-07-13.30.45.406000 Instance 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 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 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 2004-05-07-13.30.45.500000 Instance 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 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 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 2004-05-07-13.30.45.656000 Instance 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 PID:1828 TID:2992 Node:000 Title: cr_error: 0x042558D4 : 0x00000001 .... 2004-05-07-13.30.45.796000 Instance 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 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 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 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 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 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 PID:1828 TID:2992 Node:000 Title: SQLP_ACB Dump File PID:1828 TID:2992 Node:000 Title: SQLP_DBCB Dump File 2004-05-07-13.30.46.062000 Instance 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 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 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 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 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 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 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 PID:1828 TID:2992 Node:000 Title: SQLP_ACB Dump File PID:1828 TID:2992 Node:000 Title: SQLP_DBCB Dump File 2004-05-07-13.30.46.359000 Instance 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 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 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 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 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". |