Data Express - How to manage DB2 Image Copy data sets on z/OS

Problem

Data Express supports DB2 IMAGE COPY data sets on z/OS.  This article describes how to use DB2 tables unloaded via the DB2 Copy Utility for masking and extraction.

Resolution

The steps you must follow in order to manage the DB2 Image Copy data sets are:

1. Load the DB2 tables into the Data Express DB2 Knowledge Base using direct access – “Load Data Store Information from External Interface”, job BURLFIL.
2. Define a new Process ID for example “DB2IC” and specify an access type “Image copy (output UNLOAD)”, Record Format VB, and I/O program name KURFIO.
3. Change the Unload Input Data Store Name:
4. a) For Data Masking - in the Data Changer Properties menu.
5. b) For Data Subset Extraction - after creating the method  in the  Elaboration Properties menu.
6. Put the new Process Identifier for every DB2 table in the Process ID field:
7. a) For Data Masking - in the Data Changer Properties menu.
8. b) For Data Subset Extraction - after creating the method in the Elaboration Properties menu.
9. Depending on the location of the DB2 tables that will be processed via the DB2 IMAGE COPY (the same DB2 DSN system where Data Express is installed, or another DB2 DSN system) perform these steps:
10. a) In case the same DB2 DSN system is used perform the CLIST TSO CUINSYNC from the main Data Express menu on z/OS. In the DB2 Catalog Synchronization menu enter the OWNER name and the IMAGE COPY data set name to produce the output file with the correct information.
11. b) In case a different  DB2 DSN system is used create manually a file having all the information of the DB2 IMAGE COPY. See the document  “Data Model Guide”, chapter “DB2 Catalog Synchronization - IMAGE COPY” to understand  how to populate it.
12. Execute the JOB BURSYN (DB2 Catalog Synchronization) from the Data Builder module using as an input file the new created file containing the IMAGE COPY information.
13. Check if the JOB libraries are correct in the SKEL member CBTESUB2 located in the product libraries.
14. Execute the Create Data Changer job (BDCGENR) for Data Masking or the Create Extraction Job (BTEGENR) for Data Subset Extraction  in order to create correctly the JCLs. These JCLs have to contain the UNLOAD and DELETE steps needed for unloading of the IMAGE COPY and deleting of the temporary data sets.
15. Run the created jobs.