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.
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.
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?