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.
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.
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.