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
 

 

-905 SQLCODE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
renjith
Warnings : 1

New User


Joined: 07 Aug 2006
Posts: 11

PostPosted: Mon Aug 21, 2006 9:01 am    Post subject: -905 SQLCODE
Reply with quote

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
Back to top
View user's profile Send private message

mahsug

New User


Joined: 01 Jul 2003
Posts: 15
Location: Phoenix , AZ

PostPosted: Mon Aug 21, 2006 11:42 am    Post subject: Re: -905 SQLCODE
Reply with quote

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
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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