November 12th, 2005, 07:23 AM
| | |  SQL1034C creating a stored procedure on 8.1 Fixpak 5
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".
|
November 12th, 2005, 07:23 AM
| | | Re: SQL1034C creating a stored procedure on 8.1 Fixpak 5
Call support. Need to get to the bottom om this.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
|
November 12th, 2005, 07:23 AM
| | | Re: SQL1034C creating a stored procedure on 8.1 Fixpak 5
Call support. Need to get to the bottom om this.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
|
November 12th, 2005, 11:03 AM
| | | Re: SQL1034C creating a stored procedure on 8.1 Fixpak 5
Did you ever get the solution? I am having the same problem.
|
| Thread Tools | Search this Thread | | | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | |
| | | What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 205,248 network members.
|
