View previous topic :: View next topic
|
Author |
Message |
geeta.mishra
New User
Joined: 27 Dec 2005 Posts: 21 Location: Bangalore
|
|
|
|
Hi,
I am working on COBOL DB2 Stored procedure. The ASUTIME limit set in the SPDEF is 50000. This stored procedure is failing with the following error:
SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "RAVFS3.VFSY40_EXPAYLSTQYS", limit = "0000000002" CPU seconds ("0000050000" service units) derived from "". SQLSTATE=57014 {SQLExecute}
I guess the problem is with the ASUTIME set in the SPDEF. But I have a restriction of using this limit in my Stoed proc. Is there any other way I can get rid of this error?
Thanks,
Geeta |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I guess the problem is with the ASUTIME set in the SPDEF |
The problem isn't the ASUTIME, it is the SP.
I suggest you look at the SP and find a way to make it conform to the limit. |
|
Back to top |
|
|
|