Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Image Copy of a tablespace that contains a clone

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Image Copy of a tablespace that contains a clone
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: 1757
Location: UK

PostPosted: Thu Jun 02, 2016 3:48 pm    Post subject:
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    Post subject: Reply to: Image Copy of a tablespace that contains a clone
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

Senior Member


Joined: 21 Sep 2010
Posts: 1651
Location: NY,USA

PostPosted: Thu Jun 02, 2016 10:38 pm    Post subject:
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    Post subject: Reply to: Image Copy of a tablespace that contains a clone
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Mail via SMTP with an image? Mike 1304 JCL & VSAM 4 Thu Jan 26, 2017 2:01 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us