Unarchive DB2 datasets-SQL code -904

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

I am getting SQL code -904 while accessing DB2 tables through Application program, But i am able to browse the table through QMF.

Is this is due to Archival of DB2 datasets?

Could any one tell me how to Unarchive DB2 datasets?

thanks,
Nagendran

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

-904 is due to
UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE

Some of the underlying dataset of db2 may got migrated for that particular table also it can be missing underlying datasets .

If you are able to query your table through QMF rebuiliding all the indexes for that table will help you to resolve the -904 error

Do a rebuild and try

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

I am ble to query through QMF, i am getting -904 while accessing from online.

Could you please telll me how to see DB2 datasets?

Thanks,
Nagendran

guptae · Posted: Wed Sep 24, 2008 5:14 pm

you can check it from db2 admin tool / can ask with your dba's

enrico-sorichetti · Posted: Wed Sep 24, 2008 5:19 pm

If You can access the table thru qmf
all the table related resources are there

when the unavailable resource is related to a user interface
then something in the access chain is missing or out of sync

the program,
the package
the plan
ims control blocks
add as many components You like,
but only related to the programming/user interfaces

if You had posted the whole message
somebody might have already looked up for You the hexadecimal resource identifier

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Thank you all for your responses....

The issue got fixed.

Previoulsy the IMS testreion took load from Production. Now I tried promoting the component to Testregion , the issue got resolved.

Could anyone tell for which resource that DB2 is waiting here? As per my knowledgey during promotion time time only bind will happened.

I dont know why i got -904 instead of -805.

enrico-sorichetti · Posted: Wed Sep 24, 2008 5:45 pm