SQL Error -904 Idea to Resolve 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.

sql error 904 sqlstate 42000

Brief description of 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