Question on sqlcode -905 sqlstate 57014

Troy Coleman

Question on sqlcode -905 sqlstate 57014
At this point you will not have a chance to store anything in DB2
because DB2 will terminate your thread.
You may want to think about using a file to capture the abend
information since DB2 is no longer available for processing.

When you call DSNTIAR with the SQLCA you would receive the following text:
-905 UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED,
RESOURCE NAME = resource-name LIMIT = limit-amount1 CPU SECONDS
(limit-amount2 SERVICE UNITS) DERIVED FROM limit-source
If you don't call DSNTIAR to format this message then you want to make
sure you save off not only the SQLCODE but also the SQLCA SQLERRMC.
SQLERRMC contains the tokens for the code. In this case it would have
the resource-name, limit-amount1, limit-amount2, limit-source

Troy Coleman, Support Engineer
IBM Certified Database Administrator - DB2 9 for z/OS and LUW

SoftBase Systems, Inc.
847-776-0618
828-670-9900 ext. 334
[login to unmask email]

Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.



Mera Nadu wrote:
> Cobol stored procedure that MESH has informed me abended on a -905
>
> Sqlcode -905 A resource limit as determined from the active resource limit
> specification table has been exceeded.
> Sqlstate 57014 Processing was canceled as requested.
>
> I have sqlcode checking in the Cobol stored procedure which should trap any
> error and write a row to a stats table.
> However, it looks like the stored proc is not trapping the error in this case and
> execution was cancelled (per the sqlstate).
>
> I just wanted to make sure this is a normal behavior: sometimes control isn't
> given back to a stored procedure and there's no way of trapping those
> sqlcodes
>
> I appreciate all your comments..
>
> Thanks
>
> Mera
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Troy Coleman

Re: Question on sqlcode -905 sqlstate 57014
(in response to Troy Coleman)
Sorry for providing miss information. I thought the thread was always
terminate, but in fact it may still be alive. This is text related to -905:

If the limit-source was a resource limit specification table or a system
parameter, the application program that receives this return code can
execute additional SQL statements.


Troy Coleman, Support Engineer
IBM Certified Database Administrator - DB2 9 for z/OS and LUW

SoftBase Systems, Inc.
847-776-0618
828-670-9900 ext. 334
[login to unmask email]

Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.



Mera Nadu wrote:
> Cobol stored procedure that MESH has informed me abended on a -905
>
> Sqlcode -905 A resource limit as determined from the active resource limit
> specification table has been exceeded.
> Sqlstate 57014 Processing was canceled as requested.
>
> I have sqlcode checking in the Cobol stored procedure which should trap any
> error and write a row to a stats table.
> However, it looks like the stored proc is not trapping the error in this case and
> execution was cancelled (per the sqlstate).
>
> I just wanted to make sure this is a normal behavior: sometimes control isn't
> given back to a stored procedure and there's no way of trapping those
> sqlcodes
>
> I appreciate all your comments..
>
> Thanks
>
> Mera
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
> ______________________________________________________________________
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
>
>


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html