View previous topic :: View next topic
|
Author |
Message |
Robin Sulsona
New User
Joined: 14 Dec 2015 Posts: 10 Location: United States
|
|
|
|
I need to know if anyone knows if this is true or it just happened to be what occurred for me due to my own issue in the load of a clone table.
The only thing in the tablespace marked as copy pending was the clone.
I ran an image copy but I didn't check to see that it cleared the flag on the clone - My Bad. It didn't. I had to run a slightly different version of the image copy with the word CLONE to get it to clear that flag.
If I take a normal image copy of this tablespace would it include the CLONE or would I still need to do a separate image copy of the clone?
Ran this first:
Code: |
TEMPLATE COPYBEFR
UNIT SYSDA
BUFNO 40
DISP(NEW,CATLG,CATLG)
EXPDL '1999000'
DSN 'FANQPROD.AP030.&TS..BKUP(+1)'
LISTDEF UTLIST INCLUDE TABLESPACE AP030TST.AGCOMSM
INCLUDE TABLESPACE AP030TST.AGCOMTM
COPY LIST UTLIST
COPYDDN COPYBEFR
SHRLEVEL REFERENCE |
Then had to run this also:
Code: |
TEMPLATE COPYBEFR
UNIT SYSDA
BUFNO 40
DISP(NEW,CATLG,CATLG)
EXPDL '1999000'
DSN 'FANQPROD.AP030.&TS..CLONE(+1)'
LISTDEF UTLIST INCLUDE TABLESPACE AP030TST.AGCOMSM
COPY LIST UTLIST CLONE
COPYDDN COPYBEFR
SHRLEVEL REFERENCE |
|
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Code tags, code tags, code tags. Use them. |
|
Back to top |
|
|
Robin Sulsona
New User
Joined: 14 Dec 2015 Posts: 10 Location: United States
|
|
|
|
Sorry, didn't realize how important that was. I will remember to put them on the next time. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
is must for image copy. |
|
Back to top |
|
|
Robin Sulsona
New User
Joined: 14 Dec 2015 Posts: 10 Location: United States
|
|
|
|
OK Thank you, I was just hoping that maybe it wasn't. I am putting together a document for our staff so that it will be obvious to the next person that you must have 2 image copy steps in order to get all of the data backed up securely. |
|
Back to top |
|
|
|