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
 
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 How to force a select query to abend neo4u DB2 5 Mon Apr 23, 2018 1:36 pm
No new posts SELECT TO MULIPLE OUTFIL speermb DFSORT/ICETOOL 5 Fri Mar 23, 2018 10:44 pm
No new posts How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am

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