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
 

 

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 how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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