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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm


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