Hii,
Can anyone Tell me, I got -904, Error: Unsuccessful execution caused by an Unavailable resource 00000302, And Resource Name RCAD0100.RCAS9810.X '00002AB4'
-904, Error: Unsuccessful execution caused by an Unavailable resource
-
- Registered Member
- Posts: 19
- Joined: Tue Sep 02, 2014 8:13 pm
Re: -904, Error: Unsuccessful execution caused by an Unavailable resource
Hello.
The -904 SQLCODE is documented here: https://www.ibm.com/docs/en/db2-for-zos ... ic=esc-904
The "00000302" bit is a resource type, in this case for a page in the named table space. A list of the resource types can be found here: https://www.ibm.com/docs/en/db2-for-zos ... urce-types
You should also have a reason code which will be an 8-digit hex number that may give more insight into what has gone wrong. These are documented here: https://www.ibm.com/docs/en/db2-for-zos ... db2-reason
However, the best course of action here is to contact your DBA or DB2 Sysprog and get them to take a look at it. The -904 SQLCODE tends to have causes that require their intervention.
The -904 SQLCODE is documented here: https://www.ibm.com/docs/en/db2-for-zos ... ic=esc-904
The "00000302" bit is a resource type, in this case for a page in the named table space. A list of the resource types can be found here: https://www.ibm.com/docs/en/db2-for-zos ... urce-types
You should also have a reason code which will be an 8-digit hex number that may give more insight into what has gone wrong. These are documented here: https://www.ibm.com/docs/en/db2-for-zos ... db2-reason
However, the best course of action here is to contact your DBA or DB2 Sysprog and get them to take a look at it. The -904 SQLCODE tends to have causes that require their intervention.
-
- Registered Member
- Posts: 19
- Joined: Tue Sep 02, 2014 8:13 pm
Re: -904, Error: Unsuccessful execution caused by an Unavailable resource
From offshore we don't have that easy access to the DBA team, it's all on us to learn by our self! ![Sad :(](./images/smilies/sad.gif)
![Sad :(](./images/smilies/sad.gif)
Re: -904, Error: Unsuccessful execution caused by an Unavailable resource
In which case, you'll need the reason code to determine why the resource has been made unavailable. That will be the 8 digit hex code that starts 00C, 00D, 00E, or 00F. Once you know the why you can determine how to fix it. If it is something like the table needs recovery or repair, then it's possible that you may not have the access to do that at which point it is definitely something the DBAs need to deal with.
-
- Registered Member
- Posts: 19
- Joined: Tue Sep 02, 2014 8:13 pm
Re: -904, Error: Unsuccessful execution caused by an Unavailable resource
Thanks for the direction zum13. This was helpful and I could direct it to DBA team with meaningful information.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute