Test Data Manager

  • Private Community

  • 1.  Db2 data masking in mainframe

    Posted Nov 08, 2017 04:40 AM

    Hi CA,

    Could you please share the steps to mask Db2 database attributes to using jcl in mainframe.

    We have Jcl libraries installed in our mainframe environment.

     

    //GTMSK EXEC PROC=GTMSKF,LOADLIB='ZJ00.*****.LIB.LOADLIB',
    // MSGDS='ZJ00.****.MSG.KSDS',
    // REPHLQ='ZJ00.****.TEMP',
    // INDS='ZJ00.****.OUTF074COPY',
    // OUTDS='ZJ00.****.OUTF07.COPY.MASKED',
    // DEFDS='ZJ00.***.LIB.DEFCSV(DBSM20)',
    // MAPDS='ZJ00.****.LIB.MAPCSV(DBSA20)',
    //* AUDIT REPORT PRIMARY AND SECONDARY SPACE (CYLS)
    // AUDPRI='10',AUDSEC='10'
    //*
    //STEP03.PARMCD DD *
    --LANGUAGE
    LANGUAGE=EN
    --QUOTESTYLE=DOUBLE OR SINGLE
    QUOTESTYLE=DOUBLE
    /*

    Thanks,

    Rajeev Kumar



  • 2.  Re: Db2 data masking in mainframe
    Best Answer

    Broadcom Employee
    Posted Nov 08, 2017 08:01 AM

    Rajeev,

     

    The high level steps would be to register the tables, create data subset rules, setup transformation maps for the masking requirements, then FTP the masking and subset rules to the mainframe and then run the GTMSKL JCL after updating the parameters.

     

    You could look at the below links for details.

     

    Mask and Unload DB2 Tables (DB2) - CA Test Data Manager - 4.3 - CA Technologies Documentation 

     

    Thanks,

    Anil



  • 3.  RE: Db2 data masking in mainframe

    Broadcom Employee
    Posted Dec 07, 2020 03:37 PM
    Hello Rajeev,

    The information that you are looking for is available the following location in the online docs:

    https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/mainframe/working-with-db2-data-sources/masking-db2-data-sources/masking-db2-data-sources-in-mainframe-z-os.html

    Thanks

    -Walter

    Original Message