Mainframe, MVS and zOS Discussion

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.

From offshore we don't have that easy access to the DBA team, it's all on us to learn by our self!

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.

Thanks for the direction zum13. This was helpful and I could direct it to DBA team with meaningful information.