Test Data Manager

Expand all | Collapse all

Db2 data masking in mainframe

Jump to Best Answer
  • 1.  Db2 data masking in mainframe

    Posted 11-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

    Posted 11-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