Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What is SQLCODE = -904 with SQLSTATE = 57011

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sujesh_prasannan
Currently Banned

New User


Joined: 01 Aug 2007
Posts: 6
Location: chennai

PostPosted: Sat Feb 02, 2008 3:07 pm    Post subject: What is SQLCODE = -904 with SQLSTATE = 57011
Reply with quote

Hi all,
i have codded a Db2 program to fetch few records. But while running this it is giving me a sql code = -904 with SQLSTATE = 57011

Can any one help me in this. I have no clue on what this is.

Spool details:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00E70082, TYPE OF RESOURCE 3002, AND RESOURCE NAME NUMBER OF STORED PROCEDURES
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXERT2 SQL PROCEDURE DETECTING ERROR
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Sat Feb 02, 2008 7:46 pm    Post subject:
Reply with quote

Did you check the manual for that? All of the error codes are described.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Sat Feb 02, 2008 7:48 pm    Post subject:
Reply with quote

Or if your site has QuickReference go to a command line and type qw -904.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1249
Location: Israel

PostPosted: Sun Feb 03, 2008 6:40 pm    Post subject:
Reply with quote

If you have QuickRef, do QW 00E70082 (the reason code)
If you don't have QW, check the manual

Explanation: The user has reached the maximum number of outstanding
stored procedures or opened cursors for the current thread.
Back to top
View user's profile Send private message
Santoshdorge

New User


Joined: 27 Jun 2006
Posts: 48
Location: Pune

PostPosted: Mon Feb 04, 2008 5:42 pm    Post subject:
Reply with quote

Hi sujesh ,

Please try checking the database status?
If it is not in RW status then all is related to DBA you need to contact him in order to solve -904.


thanks,
Santosh.
Back to top
View user's profile Send private message
rakesh17684

New User


Joined: 08 Oct 2006
Posts: 60
Location: San Diego

PostPosted: Fri Feb 08, 2008 10:43 am    Post subject: Reply to: What is SQLCODE = -904 with SQLSTATE = 57011
Reply with quote

this mostly occurs , due to index or the table space getting into issues, you can get the exact reasons if can see the status of the database using any database monitoring tools like platinum etc.,Also this can be resolved by executing Db2 repair commands either in DB2 or a JCL.

comments or concerns????
Back to top
View user's profile Send private message
rakesh17684

New User


Joined: 08 Oct 2006
Posts: 60
Location: San Diego

PostPosted: Fri Feb 08, 2008 10:47 am    Post subject:
Reply with quote

Db2 commands

for status display
-DISPLAY DATABASE (table-name) SPACE(*)

for repair
If the TABLESPACE needs correcting use the
REPAIR OBJECT LOG NO SET TABLESPACE command with Database, Tablespace and parameter.
If the INDEX needs correcting use the REPAIR OBJECT LOG NO SET INDEX command with Database, Index and parameter. (this depends on the type of repair needed)
Back to top
View user's profile Send private message
shekharmax

New User


Joined: 26 Dec 2007
Posts: 3
Location: hyderabad

PostPosted: Fri Feb 08, 2008 11:18 am    Post subject: Reply to: What is SQLCODE = -904 with SQLSTATE = 57011
Reply with quote

hi sujesh,

expalnation of u r code is :

The SQL statement could not be executed because resource'resource name' of type 'resource type' was not available at the time for the reason indicated by 'reason code'.



Verify the identity of the resource that was not available.
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 DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us