renjith Warnings : 1 New User
Joined: 07 Aug 2006 Posts: 11
|
|
|
|
SQLCODE = -905, ERROR: UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED, RESOURCE NAME = ASUTIME
LIMIT = 000000000001 CPU SECONDS (000000010000 SERVICE UNITS) DERIVED FROM SYSIBM.DSNRLST01
SQLSTATE = 57014 SQLSTATE RETURN CODE
any solution ofr this issue?
I checked my SYSIBM.DSNRLST01 and added one line with default values(infinite) for columns corresponding to my AUTHID.But still the problem exists..can any one help me ??
thanks
renjith |
|
mahsug
New User
Joined: 01 Jul 2003 Posts: 15 Location: Phoenix , AZ
|
|
|
|
Hi ,
I have faced the similar situation, wherein my query was failing due to service units , even after declaring my authorisation id with infinite option.
I found the service units for the "infinite " is defined during the installation. and the query is expecting more service than defined to the infinite option. Hence I tweaked my query and my database structure to reduce the service units and it went on fine.
Let me know , if any queries.
Mahesh |
|