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
 

 

Select or unload from old imagecopy?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Jan 28, 2011 9:24 pm    Post subject: Select or unload from old imagecopy?
Reply with quote

I need to restore some data out of a very old imagecopy.
I only need a few specific rows .

1st-way would be to do an unload from imagecopy with a when clause.

But in the meanwhile the table has undergone changes and has been dropped / recreated,...
I still have the corresponding DDL.

2nd way would be :
- create a new table/indexes with the old DDL.
- do a DSN1COPY from the tape to this tables VSAMs with OBIDXLAT
- Rebuild indexes.
- select the specific rows.

But this table is huge, I don't have the volumes to restore to complete table.

So :Is there some way I can (unload with a WHEN / select from) a imagecopy which is unknown in DB2 '(ie. wrong dbid/obid, not in SYSIBM.SYSCOPY)???

I'm afraid not and then I have to start nagging for volumes, which could take some days.
Just hoping someone knows another way.
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sun Jan 30, 2011 10:18 am    Post subject:
Reply with quote

Hi GuyC,

I have done this using CA FASTUNLOAD utility by which you can execute an valid SELECT statement on an image copy, without it i would do exactly same thing you gonna be doing.

Thanks,
Sushanth
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Jan 31, 2011 6:57 pm    Post subject:
Reply with quote

thx, unfortunately no CA fastunload available here.
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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm


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