Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Regarding SQL error code -904

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
narasridhar

New User


Joined: 12 Oct 2006
Posts: 32
Location: India

PostPosted: Tue Oct 24, 2006 2:50 pm    Post subject: Regarding SQL error code -904
Reply with quote

Usually manual says -904 is resources not available?
Exactly what sre the resources mean? When we get this abend ? Ho to overcome this problem
?
Back to top
View user's profile Send private message

twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Tue Oct 24, 2006 4:44 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
kitajim

New User


Joined: 17 Aug 2006
Posts: 3

PostPosted: Wed Oct 25, 2006 10:05 am    Post subject: Re:
Reply with quote

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".
Back to top
View user's profile Send private message
barobaybay

New User


Joined: 22 Jul 2005
Posts: 12
Location: Philippines

PostPosted: Wed Oct 25, 2006 4:21 pm    Post subject:
Reply with quote

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...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us