DB2 SQL error -904 working resolution

pexels-photo-769024.jpeg

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

Brief description

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 resource not available and the other one is Space not available. The point is resource 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

Advertisements

Author: Srini

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