View previous topic :: View next topic
|
Author |
Message |
srilata83
New User
Joined: 02 Apr 2009 Posts: 16 Location: chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
srilata83
New User
Joined: 02 Apr 2009 Posts: 16 Location: chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
|