Troubleshooting
Problem
Applications connected to the z/OS DB2 V10 product might receive an error indicating that a database is damaged. For example: [
] [IBM][CLI Driver] SQL1034C The database is damaged. All applications processing the database have been stopped. SQLSTATE=58031 DB2 Connect Gateway servers see -1034 errors in db2diag.log file as: 2013-11-18-12.40.53.649321-300 E218048607E590 LEVEL: Error PID : 9238 TID : 48009819711808PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-50688 APPID: AUTHID : db2inst1 EDUID : 174 EDUNAME: db2agentg (SAMPLE ) FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:10 MESSAGE : DIA5000C A DRDA AS token "AGENT TERMINATING" was detected. The diagnostic data returned is (SRVDGN): "SQLERRP:SQLJRERM SQLCODE:-1034". 2013-11-18-12.40.53.650741-300 E218049198E841 LEVEL: Error PID : 9238 TID : 48009819711808PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-50688 APPID: AUTHID : db2inst1 EDUID : 174 EDUNAME: db2agentg (SAMPLE ) FUNCTION: DB2 UDB, DRDA Application Server, sqljsTermAgentReply, probe:11 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1034 sqlerrml: 0 sqlerrmc: sqlerrp : SQLJRERM sqlerrd : (1) 0x8037006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 58031 [] This error message might be followed by information that the z/OS timed out the connection due to IDTHOIN. JDBC applications will receive a -902 or SQL0902C error.Symptom
Non-Java Applications receive error indicating the database is damaged. For example, a CLI application might return the following error message:
The Java applications receive the SQL0902C error which indicates a system error.
[IBM][CLI Driver] SQL1034C The database is damaged. All applications
processing the database have been stopped. SQLSTATE=58031The Java applications receive the SQL0902C error which indicates a system error.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - Java","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21656615