Master Data Management (MDM)

Expand all | Collapse all

Use partitioned tables for MDM.

  • 1.  Use partitioned tables for MDM.

    Posted Thu March 12, 2020 09:28 AM
    Edited by Masa yum Fri March 13, 2020 04:47 AM
    Hi, Guys,

    Is it possible to use partitioned tables (Db2) for MDM?
    Do you know any reference case, guide materials or PoC samples?

    I am thinking about the tables below.
    - History tables (H_xxxx)  / Table partitioning key is H_CREATE_DT 
    - MDM TAIL tables / Table partitioning keys is not specified yet


    The purpose is for elimination maintenance of these tables.

    Thanks.

    ------------------------------
    MASAAKI
    ------------------------------


  • 2.  RE: Use partitioned tables for MDM.

    Posted Thu March 12, 2020 01:59 PM
    Hi Masaaki
    Yes, database tables may be partitioned for MDM. You will have to think about an appropriate partitioning strategy which can satisfy your inquiry needs.
    FYI, an example of partitioning strategy is available at https://www.ibm.com/support/knowledgecenter/en/SSWSR9_11.6.0/com.ibm.mdmhs.dev.platform.doc/concepts/c_PartitioningStrategies.html

    ------------------------------
    Mohammad Khatibi
    ------------------------------



  • 3.  RE: Use partitioned tables for MDM.

    Posted Fri March 13, 2020 04:18 AM
    Edited by Masa yum Fri March 13, 2020 04:49 AM
    Hi, Mohammad,

    Thank you for your quick reply.
    It is very helpful.

    As my MDM uses Db2 for Linux, I will refer the script for z/OS and consult with infra team.

    thanks again.