View previous topic :: View next topic
|
Author |
Message |
Guest
|
|
|
|
HI,
I have taken image copy using below commands in a test region.Now i have requirement to copy the same data in to different test region under same subsystem. Could you please advice if I can use the below recovery command or any other command to get it done?
Image copy
--------------
Code: |
COPY TABLESPACE RST.*,
DSNUM PART
COPYDDN SYSCOPY
GROUP YES
FULL YES
SHRLEVEL REFERENCE
RESETMOD NO
QUIESCE AFTER
WRITE NO
PARALLEL 8
|
Recovery
-----------
Code: |
RECOVER TABLESPACE XYZ.ABC DSNUM ALL
TOCOPY TTXX.RST.w.G0002V00
REBUILD INDEX(ALL) TABLESPACE XYZ.ABC
NOWORKDDN
|
|
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
This might not be possible as the image copy details are stored within the system tables for a recovery.
Why not unload and load data else use DSN1COPY to copy the image copy to normal dataset and use it for the other tablespace. |
|
Back to top |
|
|
Guest
|
|
|
|
Hi ashimer, Thanks for the reply. The problem with unload is we have over 500 tables to take back ups and preparing jobs for all these tables are time consuming as its an urgent task. Could you please tell me steps for back up and load using the the alternative way you mentioned , ie using DSN1COPY on mage copy ? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hello devil13,
You can use cross-loader feature of load utility to get the job done,
Code: |
EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM DSN8810.EMP ENDEXEC
LOAD DATA INCURSOR(C1) REPLACE INTO TABLE BOBT1.MYEMP STATISTICS |
Since there are 500 tables, here is an idea for preparing the above utility statements,
Query not tested
Code: |
SELECT 'EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM DSN8810.'||strip(name)||' ENDEXEC'
from sysibm.systables where creator ='DSN8810' |
Prepare similar query for the load also.
Remember there should be 500 cursors.
God Bless,
Sushanth |
|
Back to top |
|
|
|