Select or unload from old imagecopy?

GuyC · Posted: Fri Jan 28, 2011 9:24 pm

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.

sushanth bobby · Posted: Sun Jan 30, 2011 10:18 am

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

GuyC · Posted: Mon Jan 31, 2011 6:57 pm

thx, unfortunately no CA fastunload available here.