SQLCODE -904 while opening a cursor

ousep143 · New User Joined: 06 Oct 2007 Posts: 32 Location: India

I was getting SQLCODE = -904 while opening a cursor,

Please tell me what to do?

Gnanas SNG · Posted: Thu Jun 05, 2008 5:07 pm Post subject:

-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON
reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME
resource-name

Explanation: 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. Refer to Table 3 in Appendix B, "Problem
determination" in item -PROBLEM_DETERMI for an explanation of resource type
codes. Refer to "DB2 codes" in item -DB2_CODES for an explanation of the given
reason code.

If this is issued in connection with Multilevel Security authorization
(resource-type 402), then the Security Server return and reason codes for
the unavailable resource appear as the resource-name. In this case, refer
to the z/OS Security Server RACROUTE Macro Reference.

System Action: The SQL statement cannot be executed. If the SQL statement
being executed was a cursor FETCH, DB2 closes the cursor. Subsequent
attempts to use that cursor without first doing an OPEN for it receive an
SQLCODE -501.

Programmer Response: Verify the identity of the resource that was not
available. To determine why the resource was unavailable, refer to the
specified reason-code.

SQLSTATE: 57011

enrico-sorichetti

-904 is an unavailable resource SQLCODE

You' ll have to post all the messages or look them up Yourself in the manual in order to find out what to do

ousep143 · New User Joined: 06 Oct 2007 Posts: 32 Location: India

Thanx Enrico & Gnanas

balaji.ghanta · New User Joined: 26 Jun 2008 Posts: 2 Location: Bangalore

-904 is for resource not available. Varify the below

1) Please check whether the table is existing or not.

2) Might be your utilitilib is not be existing. So, in this case check with your corresponding DBA. He will solve your problem.