V8 z/OS progam interrupt processing

Jim Irwin

V8 z/OS progam interrupt processing
Does anyone here know how a program interrupt 0C7 is processed in DB2
thread when the request is coming from a JAVA application through a
Websphere application server using RRSAF. Specifically what happens to
the DB2 thread after the 0C7 has been detected. From what I can tell
the thread is not aborted but seems to be marked unusable somehow but I
can't find any documentation the clearly defines what happens. Does
Websphere and/or the application need to catch the exception and issue a
rollback command to clean things up? Thanks in advance for any help.




****************************
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

Avram Friedman

Re: V8 z/OS progam interrupt processing
(in response to Jim Irwin)
Jim
Way too much information.

I think what you mean is an application external to the z/OS based DB2 system routes a SQL request to DB2 that fails.

What happens is data is returned to the application indicating an error.

Lets take this one step further
The SQL request fails because it encounters a data exception.

A SQLSTATE 22xxx is generated and returned to the application
The list of SQLSTATE 22xxx is in the DB2 Messages and Codes Manual Appendix 1.4

Now one more step the data exception happens to be decimal arithmetic (S0C7)
The returned SQLSTATE is 22018

22018

The character value for the CAST, DECIMAL, FLOAT, or INTEGER scalar function is invalid.




In 99.9999% of the cases like the one you describe is the calling (distributed) application fails to look at the return code and then take appropriate action like RollBack, Disconnect etc. Its the application that needs to take action, The DB2 thread on the mainframe will just wait forever or for the thread to time out.


As my brother taught me ... If you choose not to pay attention to the gas (petro) gage or the speedometer then you can concentrate on driving.


"Irwin, Jim" <[login to unmask email]> wrote:
Does anyone here know how a program interrupt 0C7 is processed in DB2 thread when the request is coming from a JAVA application through a Websphere application server using RRSAF. Specifically what happens to the DB2 thread after the 0C7 has been detected. From what I can tell the thread is not aborted but seems to be marked unusable somehow but I can’t find any documentation the clearly defines what happens. Does Websphere and/or the application need to catch the exception and issue a rollback command to clean things up? Thanks in advance for any help.


---------------------------------
****************************
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




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




---------------------------------------------------------------------------------
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