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.
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.