IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Resource limit exceeded error whie executing STP


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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

Superior Member


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

PostPosted: Mon Jun 15, 2009 6:37 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts ISPP330 BDISPMAX exceeded CLIST & REXX 12
Search our Forums:

Back to Top