RPG (IBM i / AS/400) · DB2 SQLCODE
What does SQLCODE -904 - Resource Unavailable mean in RPG (IBM i / AS/400)?
The database manager could not obtain a resource the statement needed - commonly an object lock held exclusively by another job, or a system resource such as an index build that's temporarily unavailable.
The database manager could not obtain a resource the statement needed - commonly an object lock held exclusively by another job, or a system resource such as an index build that's temporarily unavailable.
Check the job log/reason code accompanying this SQLCODE for the specific resource, and coordinate with whatever job or batch process is holding the object so it's free when this program needs it.