Regarding SQL error code -904

narasridhar · New User Joined: 12 Oct 2006 Posts: 32 Location: India

Usually manual says -904 is resources not available?
Exactly what sre the resources mean? When we get this abend ? Ho to overcome this problem
?

twissi · Posted: Tue Oct 24, 2006 4:44 pm

Nara Sridhar,

RESOURCES mean everything (on DB2) that your program is trying to access, e.g. TABLES etc.

There're many reasons for this SQLCODE, the most common being the VSAM datasets that hold the DB2 data migrating on to tape thus making the resource unavailable for the program at that moment or an other program holding the resource that you want, in exclusive mode.

To get rid of this, maybe you can try and execute the program sometime later or do something to make that resource available for your program, say, recalling all datasets onto the disk for the problem I stated above.

Hope this helps!
Cheers, Twissi.

kitajim · New User Joined: 17 Aug 2006 Posts: 3

Hi, Check the volume usage(ISPF 3.4 with "V" option) relted with your DB Storage Group.
If the usage is full, create a new Volue and assing to your Storage Group using the DB2 command "ALTER STOGROUP".

barobaybay · Posted: Wed Oct 25, 2006 4:21 pm

Hi,
I usually encounter this error when there was a previous job abend or a bad SQL statement and when I check in BMCADM or other tools that can take DB2 commands, I DISPLAY the database and the tablespace and their status.. after seeing that the status of the database or tablespace, I start the database or tablespace then use the START command with the ACCESS(FORCE) command.. I hope this is (somehow) useful...