View previous topic :: View next topic
|
Author |
Message |
snehalpatel
New User
Joined: 13 Sep 2007 Posts: 37 Location: India
|
|
|
|
If I don’t use any particular Table for a considerable time and then if try to Browse/Edit that table after long time then I get –904 errors. UNAVAILABLE RESOURCE . Usually Resource name is some DSN. When I try to browse this particular DSN in 3.4 options I see that this DSN is in ARCIVE status. If I HRECALL this DSN then sometimes the problem is resolved i.e After HRECALL command I am Able to browse/Edit my Table.
But sometimes the Resource name is not found in 3.4 Option Itself( Data Set not found ). In Such Case We usually have to drop That Table and Create New One.
I have 2 queries in this regard:
1 : It is possible to list out all Tables under My ID which are in ARCIVE status.
( I.s Table Status Information Stored in any particular Table? )
2. Is there way to avoid Table getting –904 Sqlcode for this kind of Resource Unavailability?
Please note that I am able to Edit/Browse Other Recently created Tables.
So this –904 is not related to Db2 System down sort of error |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
snehalpatel wrote: |
If I don’t use any particular Table for a considerable time and then if try to Browse/Edit that table after long time then I get –904 errors. UNAVAILABLE RESOURCE . Usually Resource name is some DSN. When I try to browse this particular DSN in 3.4 options I see that this DSN is in ARCIVE status. If I HRECALL this DSN then sometimes the problem is resolved i.e After HRECALL command I am Able to browse/Edit my Table.
But sometimes the Resource name is not found in 3.4 Option Itself( Data Set not found ). In Such Case We usually have to drop That Table and Create New One.
I have 2 queries in this regard:
1 : It is possible to list out all Tables under My ID which are in ARCIVE status.
( I.s Table Status Information Stored in any particular Table? )
2. Is there way to avoid Table getting –904 Sqlcode for this kind of Resource Unavailability?
Please note that I am able to Edit/Browse Other Recently created Tables.
So this –904 is not related to Db2 System down sort of error |
Sounds like an SMS problem, datesets for DB2 tables should not be archived. Talk with you data management people. |
|
Back to top |
|
|
|