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
 
table is not accessible due to -904 error.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: table is not accessible due to -904 error.
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Thu Apr 09, 2009 4:41 pm    Post subject: Reply to: table is not accessible due to -904 error.
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: 6970
Location: porcelain throne

PostPosted: Thu Apr 09, 2009 5:19 pm    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Thu Apr 09, 2009 6:23 pm    Post subject: Reply to: table is not accessible due to -904 error.
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: 6970
Location: porcelain throne

PostPosted: Thu Apr 09, 2009 7:10 pm    Post subject:
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    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 -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm

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