Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Table - ARCIVE -904 Sqlcode

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

New User


Joined: 13 Sep 2007
Posts: 37
Location: India

PostPosted: Wed Sep 19, 2007 1:23 pm    Post subject: DB2 Table - ARCIVE -904 Sqlcode
Reply with quote

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
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Sep 19, 2007 7:08 pm    Post subject: Re: DB2 Table - ARCIVE -904 Sqlcode
Reply with quote

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
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 Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Need inputs on DB2 tablespace/table r... ashek15 DB2 3 Sat Mar 24, 2018 11:49 pm
No new posts COBOL declaration for table Poha Eater DB2 3 Mon Feb 26, 2018 6:58 pm
No new posts SQLCODE 518 while executing DB2 module. abdulrafi DB2 8 Wed Feb 07, 2018 10:46 am
No new posts load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us