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
 

 

Unarchive DB2 datasets-SQL code -904

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed Sep 24, 2008 2:57 pm    Post subject: Unarchive DB2 datasets-SQL code -904
Reply with quote

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
Back to top
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Sep 24, 2008 3:14 pm    Post subject: Reply to: Unarchive DB2 datasets-SQL code -904
Reply with quote

-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
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed Sep 24, 2008 3:42 pm    Post subject: Reply to: Unarchive DB2 datasets-SQL code -904
Reply with quote

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
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Sep 24, 2008 5:14 pm    Post subject:
Reply with quote

you can check it from db2 admin tool / can ask with your dba's
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Sep 24, 2008 5:19 pm    Post subject: Reply to: Unarchive DB2 datasets-SQL code -904
Reply with quote

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
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed Sep 24, 2008 5:34 pm    Post subject: Reply to: Unarchive DB2 datasets-SQL code -904
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Sep 24, 2008 5:45 pm    Post subject: Reply to: Unarchive DB2 datasets-SQL code -904
Reply with quote

Quote:
Could anyone tell for which resource that DB2 is waiting here?


see my previous comment on providing useful info

in the DSN.... message related to the -904 status code an hexadecimal resource identifier is provided
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 -> IMS DB/DC 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 Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts DUMP DATASETS VS TRACE DATASETS! lind sh CICS 4 Tue Dec 06, 2016 11:31 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am


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