Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Resource limit exceeded error whie executing STP

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Poonam Jain

New User


Joined: 06 Apr 2009
Posts: 5
Location: mumbai

PostPosted: Mon Jun 15, 2009 6:19 pm    Post subject: Resource limit exceeded error whie executing STP
Reply with quote

Hi,

I am getting below error while executing STP . In Production this error in not coming. Only in test enviroment it is coming. And the frequency of this error is 5 times out of 10 runs.

[IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "SYSPROC.SADSP85K", limit = "0000000001" CPU seconds ("0000036110" service units) derived from "". SQLSTATE=57014

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "SYSPROC.SADSP85K", limit = "0000000001" CPU seconds ("0000036110" service units) derived from "". SQLSTATE=57014

Please help me in this regard.
Back to top
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Mon Jun 15, 2009 6:28 pm    Post subject:
Reply with quote

Prod environment normally do have higher resource limits compared to test ... Did you try increasing the ASUTIME of the proc ?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jun 15, 2009 6:37 pm    Post subject:
Reply with quote

Ah...Stored Procedures, new for me as well -- you have got SQLCODE= -905, are you using crusor there in SP?

If an SQL cursor is associated with the failed instruction, its position is unchanged and a CLOSE or PREPARE command can be issued.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us