jontyjun
New User
Joined: 12 Sep 2006
Posts: 9
Location: India
|
|
|
|
Hi,
Say I have a Database - Abase and Tablespace - TS1
Can I use the image copy dataset of TS1 to load data into Tablespace TS2 which has the same tables and index as of TS1? The tables are empty in TS2.
(Conclusion: Recover from Image copies can only be possible only if the destination Tablespace has got an entry in SYSIBM.SYSCOPY.) Is this correct?
Second Query:
Image Copies consists data only and not DDLs/Structure of the table. Is this correct?
Third Query:
Say A image copy of a tablespace is taken and the table is dropped.
When I recover the Tablespace from the image copy the table structure must be created again so that the data will be recovered to the table.
If the table is not created then the image copy cannot help this purpose. Is this correct?
Please clarify on the above three queries.
Thx in advance.. |
|
