Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
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.
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".
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...