View previous topic :: View next topic
|
Author |
Message |
sujesh_prasannan Currently Banned New User
Joined: 01 Aug 2007 Posts: 6 Location: chennai
|
|
|
|
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 |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Did you check the manual for that? All of the error codes are described. |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Or if your site has QuickReference go to a command line and type qw -904. |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
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 |
|
|
Santoshdorge
New User
Joined: 27 Jun 2006 Posts: 48 Location: Pune
|
|
|
|
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 |
|
|
rakesh17684
New User
Joined: 08 Oct 2006 Posts: 61 Location: San Diego
|
|
|
|
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 |
|
|
rakesh17684
New User
Joined: 08 Oct 2006 Posts: 61 Location: San Diego
|
|
|
|
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 |
|
|
shekharmax
New User
Joined: 26 Dec 2007 Posts: 3 Location: hyderabad
|
|
|
|
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 |
|
|
|