DB2 Error Code – -904 unsuccessful execution caused by an unavailable resource.� reason reason code, type of resource resource type, and resource name resource name

In this post, you’ll learn about the error message -904 unsuccessful execution caused by an unavailable resource.� reason reason code, type of resource resource type, and resource name resource name in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-904 unsuccessful execution caused by an unavailable resource.� reason reason code, type of resource resource type, and resource name resource name

Reason for the Error

Unavailable resource. Someone is locking the data you need
you may choose to terminate the program

The SQL statement could not be executed because resource’resource name’ of type ‘resource type’ was not available at the time for the reason indicated by ‘reason code’.�

Solution

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