DB2 SQLCODE -904 Resource not available

IBM's flagship relational database management system

DB2 SQLCODE -904 Resource not available

Postby tdanielxyz » Fri Dec 12, 2014 11:15 am

Is there any command or statement in Db2 that helps to see who is holding a resource?
Posts: 12
Joined: Sun Oct 17, 2010 12:06 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 SQLCODE -904 Resource not available

Postby t1pers » Mon Dec 15, 2014 9:13 pm

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
Posts: 8
Joined: Mon Feb 11, 2013 1:02 am
Has thanked: 1 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post