Page 1 of 1

DB2 SQLCODE -904 Resource not available

PostPosted: Fri Dec 12, 2014 11:15 am
by tdanielxyz
Is there any command or statement in Db2 that helps to see who is holding a resource?

Re: DB2 SQLCODE -904 Resource not available

PostPosted: Mon Dec 15, 2014 9:13 pm
by t1pers
When your job failed with 'Resource unavailable' IRLM tracked a record about the lock situation. Try searching the log for message DSNI031I.
Here you can find some additional information about the message:
http://www-01.ibm.com/support/knowledge ... i031i.dita
Here you may find some helpful information about locks escalation:
http://www-01.ibm.com/support/knowledge ... ation.dita