Db2 for z/OS & Db2ZAI

 View Only
Expand all | Collapse all

Reorganization of PBG TS on partition number

  • 1.  Reorganization of PBG TS on partition number

    Posted Wed January 24, 2024 05:24 PM

    I am looking into the possibility of only conduction reorg on partition-level for larger PGB TS as oppose to a complete TS reorg. This is naturally to save CPU - is there anyone who has experience with this "optimization" - god or bad.

    This is supported by DB2 - and I know that askew data across multiple partitions will not be reorganized - but I am trying to identify if this could have other side effects.       



    ------------------------------
    Jan Schultz
    ------------------------------


  • 2.  RE: Reorganization of PBG TS on partition number

    IBM Champion
    Posted Thu January 25, 2024 01:45 AM

    Be careful if it is compressed or full of varchar columns – might not "fit back in" used to cause grief but is much better these days as it can allocate a new partition if maxpartitions has not been reached. All indexes are per definition NPSI so that can also cause grief as the "other" users still get hit in the index rebuild phase.

     

    That's it as far as I know.

     

    Roy Boxwell

    SOFTWARE ENGINEERING GmbH and SEGUS Inc.
    -Product Development-

     

    ibm-champion-2023 email

    Vagedesstrasse 19
    40479 Dusseldorf/Germany
    Tel. +49 (0)211 96149-675
    Fax +49 (0)211 96149-32
    Email:     R.Boxwell@seg.de
    Web  http://www.seg.de

    Link zur Datenschutzerklärung


    Software Engineering GmbH
    Amtsgericht Düsseldorf, HRB 37894
    Geschäftsführung: Gerhard Schubert, Ulf Heinrich

     




    Original Message