Test Data Manager

 View Only
  • 1.  Can TDM masker keep consistency during masking across two DBs

    Broadcom Employee
    Posted Jun 16, 2016 04:07 AM

    Hi Experts,

     

    Customer asked that TDM could mask with keeping consistency between distributed RDBMS and  DB2/z.

    I explained that HASHLOV can keep consistency during masking.

    However, I was not sure it could also keep consistency across two DBs.

    For example...

    I understand that HASHLOV can keep consistency against single DB like below:

     

    <<<Before masking>>>

        Oracle

    ============

    1 | NISHINO

    2 | NISHINO

    3 | WATA

     

    <<<After masked>>> (by using HASHLOV)

        Oracle

    ============

    1 | AAAAA     <--consistant

    2 | AAAAA     <--consistant

    3 | BBBBB

     

    My question is, can TDM also keep consistency across two DBs? (One is distributed (ex. Oracle) and other one is DB2/z)

    Like below:

     

    <<<Before masking>>>

        Oracle                 DB2/z

    ============     =============

    1 | NISHINO           1 | KITA

    2 | NISHINO           2 | NISHINO

    3 | WATA                 3 | WATA

     

    <<<After masked>>>

        Oracle                  DB2/z

    ============      =============

    1 | AAAAA              1 | CCCCC

    2 | AAAAA              2 | AAAAA

    3 | BBBBB              3 | BBBBB

     

    Any comments will be appreciated!

     

    Regards,

    Hirofumi Nishino



  • 2.  Re: Can TDM masker keep consistency during masking across two DBs

    Posted Jun 17, 2016 10:33 AM

    Hi, we will research this issue and get back to you on Monday.



  • 3.  Re: Can TDM masker keep consistency during masking across two DBs
    Best Answer

    Posted Jun 21, 2016 02:20 PM

    Hi Hirofumi,

     

    We use MDM (Mainframe equivalent of FDM) for masking on the mainframe.

    HASHLOV with this is the same as for FDM.

    For example, UB mask DB2 on the mainframe with MDM, and Oracle with FDM.

    So using HASHLOV should work with masking between DB2 and Oracle.

     

    Please let us know if you have any more questions.

     

    Best regards,

    Taylor



  • 4.  Re: Can TDM masker keep consistency during masking across two DBs

    Posted Jun 22, 2016 08:34 AM

    As long as the seed data (file or table) that is used is the same, consistency will be maintained.



  • 5.  Re: Can TDM masker keep consistency during masking across two DBs

    Broadcom Employee
    Posted Jun 22, 2016 10:50 PM

    Yes, using HASHLOV you can maintain consistency across two databases.



  • 6.  Re: Can TDM masker keep consistency during masking across two DBs

    Broadcom Employee
    Posted Jun 23, 2016 01:31 AM

    Thanks a lot everyone! I clearly understand!!

    HASHLOV is very strong functionality I think.

    Some customer said to me that such these concictency is very difficult point if try to mask by scratch.

    Thanks again for helpful advice!

     

    Hirofumi Nishino