Unloading consistent data from a database object

Document ID : KB000046103
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms: 

Unloading consistent data from a database object without affecting its availability is one of the functions that CA Quick Copy 19.0 and CA Fast Unload 19.0 support now.

Environment:  

Support of Consistent Unload is now available with CA Quick Copy 19.0 and CA Fast Unload 19.0.

Resolution:

With CA Quick Copy 19.0 and CA Fast Unload 19.0, you can perform consistent unload. It is a two-step process that leverages ability of CA Fast Unload to unload data from a snapshot copy.

Firstly, you create a consistent snapshot copies of your tablespace partitions.
The keyword here are CONSITENT and SNAPSHOTIWAIT NO
.

 //COPY02   EXEC PT@UTIL

//SYSIN    DD *

   TEMPLATE T1 

   DSN(SHK8.PQC800.&DB..&TS..P&PART.)

   COPY TABLESPACE DB.ZPCRD2 

    SSCOPYDDN(T1)

    SNAPSHOTACCESS INSTANT

    SHRLEVEL CHANGE

    SNAPSHOTIWAIT NO

    CONSISTENT

Secondly, you unload data from the snapshot copies of tablespace partitions identified by DD statements. This is a standard CA Fast Unload job step. The Keyword here is INPUT-FORMAT FLASHCOPY.

//ULD01    EXEC PT@UTIL

//COPY2001  DD   DISP=SHR,DSN=SHK8.PQC800.DB.ZPCRD2.P00001

//COPY2002  DD   DISP=SHR,DSN=SHK8.PQC800.DB.ZPCRD2.P00002

//*

//TS2REC01 DD   DISP=(,CATLG),SPACE=(TRK,(9,9)),

//         DSN=PQC.P800.DEMO.ULD2

//*  

//SYSIN    DD   *

  FASTUNLOAD 

  INPUT-FORMAT FLASHCOPY 

  INDDN COPY20

  INDDN-COUNT 2

  UNLDDN TS2REC

  LOAD-CONTROL FASTLOAD

  OUTPUT-FORMAT EXTERNAL

  SELECT * FROM PD.TZPCRD2;