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
 

 

Resource Unavailable

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
rajulan

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Wed Feb 17, 2010 10:53 am    Post subject: Resource Unavailable
Reply with quote

Hi,

Application program is accessing the table and it is getting -904 resource not available error. What will you do?

I told him I see the resource name. With the help of display command, I will see the status of the object. If it is in any pending status like copy or recp, I will take copy or recovery in order to remove the flag.

He told me that even after you removed the pending status, object is in RW status. Though it is in RW, you are getting -904. He gave me the clue--Vsam data set is deleted.

I know normally if we create the TS, automatically behind the scene, vsam dataset will be created. Can we delete the dataset directly? If yes, will the table be dropped? Please clarify my doubt.

Thanks,
Rajulan.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 17, 2010 11:00 am    Post subject:
Reply with quote

Hello,

If someone deletes an underlying vsam dataset, it causes severe problems. If the dataset is manually deleted, the db2 catalog will not be aware of this and the DROP will not have happened.

The "resource not available" has also been known to happen when an underlying dataset has been migrated.
Back to top
View user's profile Send private message
rajulan

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Wed Feb 17, 2010 11:21 am    Post subject: Reply to: Resource Unavailable
Reply with quote

Quote:

If someone deletes an underlying vsam dataset, it causes severe problems. If the dataset is manually deleted, the db2 catalog will not be aware of this and the DROP will not have happened.


In this case will it show -904? Today I will test this and post the answer as well.


Quote:

The "resource not available" has also been known to happen when an underlying dataset has been migrated.


So if we recall the dataset, issue will be resolved. Right?


One follow up question. Backup(copy) dataset has been migrated to tape and scratched at later point. I do not have the quiesce entry in catalog as well bec modify recovery wiped out all the quiesce entries from the catalog. In that case, can we recover the object?

Thanks,
Rajulan R.C
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit CICS CPU resource vasanthz CICS 0 Tue Jan 31, 2017 7:09 am
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm
No new posts Check special resource availability w... pinimo JCL & VSAM 8 Fri Apr 15, 2016 8:18 pm
No new posts Issuing DEQ before ENQ with same reso... RahulG31 CICS 18 Thu Nov 26, 2015 1:51 am
No new posts CICS ENQ RESOURCE - Multiple Tasks - ... mak_tcs CICS 2 Fri Jul 17, 2015 2:29 pm


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