DB2 v8 z/OS Websphere application : SQLCODE = -5000002

Mae Bruce

DB2 v8 z/OS Websphere application : SQLCODE = -5000002
We have encountered the following error a couple of times in our
Websphere server.

2005-12-08 09:22:03,162 ERROR - [WebSphere t=009a0448][DF3192]
[SDCIPO41134055323162] [struts.commons] [CMMN0010E] Caught a runtime
Exception.

Caused by:

javax.ejb.TransactionRolledbackLocalException: ; nested exception is:
com.ibm.db2.jcc.t2zos.y:
[IBM/DB2][T2zos/2.5.36]T2zosPreparedStatement.readOpenQueryInternal:nati
veOpen:4109:Abend occurred in DB2, Driver successfully retry, SQLCODE =
-5000002, SQLSTATE = FFFFF, error tokens =
signal:8,acode:00000000,reas:00000000,con:4E0582A8,tcb:4E0268F8

com.ibm.db2.jcc.t2zos.y:
[IBM/DB2][T2zos/2.5.36]T2zosPreparedStatement.readOpenQueryInternal:nati
veOpen:4109:Abend occurred in DB2, Driver sucessfully retry, SQLCODE =
-5000002, SQLSTATE = FFFFF, error tokens =
signal:8,acode:00000000,reas:00000000,con:4E0582A8,tcb:4E0268F8

Can anyone shed any light on what the -5000002 sqlcode is? We have been
unable to find a description of it anywhere. The "signal:8" we know is
similar to an 0C7 abend. But because of the way they have done the
application and using a common id on everything, they are having a hard
time pinpointing what code is actually responsible for the abend. Is
there info on the SMF records that we could use to help determine what
was going on at the time of the abend? Any suggestions on other things
to look at? I am also posting this to a websphere list to see if they
have any ideas.

TIA.
Mae Bruce
State of MO/State Data Center
DB2 Support




***********************************
CONFIDENTIALITY STATEMENT:
This e-mail and any attachments are intended only for those to which it is addressed and may contain information which is privileged, confidential and prohibited from disclosure and unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination, or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system.



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm