How to Resolve SQL-904 Error Quickly

SQL error -904 in DB2 is a little tricky. Here you will find the resolution on how to fix it. You know right, many times during the execution of your SQL in your project you will get this error.

What is SQL error -904 SQLSTATE 42000

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

Two reasons in DB2 SQL error is possible. One is a resource not available and the other one is Space not available. The point is resources can be anything.

Resolution

904 is usually caused because a database utility job has started the desired DB2 object in utility mode. Check DB2 Master Log for more details on the resource name contact DBA.

References

Related

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.