View previous topic :: View next topic
|
Author |
Message |
Poonam Jain
New User
Joined: 06 Apr 2009 Posts: 5 Location: mumbai
|
|
|
|
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 |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Prod environment normally do have higher resource limits compared to test ... Did you try increasing the ASUTIME of the proc ? |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
|