By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,638 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

SQL1034C creating a stored procedure on 8.1 Fixpak 5

P: n/a
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".
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Call support. Need to get to the bottom om this.

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Call support. Need to get to the bottom om this.

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
Did you ever get the solution? I am having the same problem.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.