IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Image Copy of a tablespace that contains a clone


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Robin Sulsona

New User


Joined: 14 Dec 2015
Posts: 10
Location: United States

PostPosted: Thu Jun 02, 2016 1:47 am
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Thu Jun 02, 2016 3:48 pm
Reply with quote

Code tags, code tags, code tags. Use them.
Back to top
View user's profile Send private message
Robin Sulsona

New User


Joined: 14 Dec 2015
Posts: 10
Location: United States

PostPosted: Thu Jun 02, 2016 5:54 pm
Reply with quote

Sorry, didn't realize how important that was. I will remember to put them on the next time.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Jun 02, 2016 10:38 pm
Reply with quote

Code:
CLONE in COPY
is must for image copy.
Back to top
View user's profile Send private message
Robin Sulsona

New User


Joined: 14 Dec 2015
Posts: 10
Location: United States

PostPosted: Thu Jun 02, 2016 11:32 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts force tablespace using LISTDEF input DB2 1
No new posts Need COBOL COPY Help in MVS Environment COBOL Programming 4
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
No new posts DB2 Table - Image copy unload IBM Tools 2
Search our Forums:

Back to Top