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
 

 

Sqlcode -905, please help

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Machani Hanuprasad

New User


Joined: 06 Jun 2012
Posts: 11
Location: India

PostPosted: Thu Sep 27, 2012 7:32 pm    Post subject: Sqlcode -905, please help
Reply with quote

I have a job which executes a SQL query which is saved as a member in a copybook library. When I submit the job I'm getting Sqlcode -905 in successful execution, resource limit exceeded. Actually the query should execute and output the rows in a flat file. Please can anyone helpme on this.

Thanks...
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Sep 27, 2012 7:46 pm    Post subject:
Reply with quote

:: sigh :: Do you know what a "resource limit" is? What DB2 is telling you is your query is so badly written that it takes too many CPU seconds, etc., to run. Get together with your DBAs and ask them to aid you in making the query more efficient.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Thu Sep 27, 2012 7:52 pm    Post subject:
Reply with quote

Is it a new job and getting tested very first time? if so then follow Akatsukami.

Otherwise if it is running since long time in production and failed today once, then have a explain on your query and then talk to your DBAs as there might be chances of INDEXes getting removed.
Back to top
View user's profile Send private message
Machani Hanuprasad

New User


Joined: 06 Jun 2012
Posts: 11
Location: India

PostPosted: Fri Sep 28, 2012 9:12 am    Post subject: Reply to: Sqlcode -905, please help
Reply with quote

Thanks Akatsukami.

Regards
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Sep 28, 2012 2:12 pm    Post subject:
Reply with quote

which was easily found when one would READ the explanation of the sqlcode :
Quote:
Programmer response
Determine why this SQL statement or stored procedure took so long and take appropriate action. Consider simplifying the SQL statement, restructuring tables and indexes, or contacting the installation group responsible for maintaining the resource limit specification tables.
Back to top
View user's profile Send private message
Machani Hanuprasad

New User


Joined: 06 Jun 2012
Posts: 11
Location: India

PostPosted: Fri Sep 28, 2012 4:48 pm    Post subject: Reply to: Sqlcode -905, please help
Reply with quote

Hi Friends Thanks for your suggestions.
This has been resolved.

Thanks & Regards
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Fri Sep 28, 2012 4:53 pm    Post subject:
Reply with quote

Quote:
Hi Friends Thanks for your suggestions.
This has been resolved.


Did you follow us? what solution you ended up with? this will be helpful infuture for similar questions.
Back to top
View user's profile Send private message
Machani Hanuprasad

New User


Joined: 06 Jun 2012
Posts: 11
Location: India

PostPosted: Mon Oct 01, 2012 10:29 am    Post subject: Reply to: Sqlcode -905, please help
Reply with quote

Actually the query is given by developers team which is not an optimized query. The condition specified is completly wrong and is fetching more number of records through which it is getting -905. We informed the same stating the problem over given query. So, finally DB team came into the picture and suggested with proper query a/c to requirement.

Regards
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 -> DB2 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