Automated Testing

Automated Testing

Automated Testing

Build an automated testing process to enable continuous integration of your hybrid cloud applications including z/OS

 View Only
Back to discussions
Expand all | Collapse all

Best practices about db2 table compressed in ZOS

  • 1.  Best practices about db2 table compressed in ZOS

    Posted 10/31/18 12:32 PM

    Hello

    A customer of mine   is interested on cloning his TEST ZOS  environment in ZDT. They have big compressed tables in their ZOS environment.

    Given the unavailability of ZEDC  feature  in ZDT do you have any suggestions/ experiences about  how to avoid performance problems  with these  tables  on ZDT?

     

    Many thanks in advance

     

    gius


  • 2.  Re: Best practices about db2 table compressed in ZOS

    Posted 11/21/18 05:39 AM

    Hi Gius,

    Not sure that this will be an issue as most of the compression used by DB2 is supported by ZDT.

    Table compression does not use zEDC and is supported by ZDT

    Index compression does not use zEDC and is supported by ZDT

    XML compression does not use zEDC and is supprorted by ZDT

    Inline LOB compression does not use zEDC and is supported by ZDT

    Out of line LOB compression uses zEDC and is not suppotted by ZDT, but this is a recent DB2 12 feature at function level 500 and above, so not many sites will have decided on best practice for this feature.

    Regards

    Colin Raybould.

    ColinRaybould


Related Content