IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

table is not accessible due to -904 error.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srilata83

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Thu Apr 09, 2009 4:35 pm
Reply with quote

Hi All.
I have executed a select qury on the table,its giving -904 error, showing the resource unavailable. the resource its saying the related tablespace partion datasetname.now i checked for the datset on 3.4 on ispf its not available.I checked for the related tablespace and database and associated storagegroup name too, all are present but that dataset is not available.What reason can it be there?can anyone please help me?
Thanks in advance....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Apr 09, 2009 4:41 pm
Reply with quote

Quote:
can anyone please help me?


I mildly suggest that the best place to ask for help would be Your DB support group

You also gave an approximate description,
to be able to suggest better we would need the whole -904 message set

but again, Your support will certainly be the best source for help
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Apr 09, 2009 5:19 pm
Reply with quote

k.s.rao,

you are never going to find a dataset in 3.4 that 'is a db2 table'.

even though we know that db2 uses vsam lin-ds to 'contain/manage' its data,
these are not 'datatset' in the ispf sense.
They are managed by db2
and trying to use ISPF services to determine the 'existance' of these 'DS' is a waste of time.

provide the complete -904 message,
as enrico suggested,
and we can help you find your problem.
the rc's and codes explain exactly what is wrong.
Back to top
View user's profile Send private message
srilata83

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Thu Apr 09, 2009 6:14 pm
Reply with quote

I am getting this error.I am not opening the table directly in ispf.
I was trying to open the below mentioned dataset which is not found.

SELECT COUNT(*)
FROM tablename WITH UR;


SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURCE 00000220, AND
RESOURCE NAME DB2SYST.DSNDBC.DCMIACDB.XCMIACD2.I0001.A001


Thanks,
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Apr 09, 2009 6:23 pm
Reply with quote

why in &HEAVEN don' t You want to speak to Your support ??

Unavailable Resource Reason 00d70024, TYPE=220 ....
means DB2 Table Migrated.

since Your support has decided to have db2 datasets under HSM control
they should give You the directives to solve the issue
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Apr 09, 2009 7:10 pm
Reply with quote

Quote:
and trying to use ISPF services to determine the 'existance' of these 'DS' is a waste of time.


the preceding comment was wrong.
DB2SYST.DSNDBC.DCMIACDB.XCMIACD2.I0001.A001
would have been found in a 3.4,
if it existed or had been migrated
and not yet deleted from migrated status.

Is the 'Migrated' status one sees in the 3.4 display under VOLUME,
pertain to the data-management facility used?
If migrated datasets are periodically deleted from migrated status,
what kind of time frame are we talking about? 6 months, 1 year?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Error when install DB2 DB2 2
No new posts Pulling a fixed number of records fro... DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top