DB2 - L

Expand all | Collapse all

general recommendations on catalog object (dsndb06) reorgs

  • 1.  general recommendations on catalog object (dsndb06) reorgs

    Posted Sep 21, 2021 10:58 AM
    we have several catalog objects (DSNDB06.*) tablespaces that havent been reorged for several years now.
    while many are probably empty and not currently used, should that be a concern?
    should we have all catalog tablespaces reorged at least periodically?
    What is IBM's general recommendation?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: general recommendations on catalog object (dsndb06) reorgs

    Posted Sep 23, 2021 03:42 AM
    Edited by Steven Lamb Sep 23, 2021 09:52 AM
    In production we Reorg SYSLGRNX, SYSHIST and SYSTSCPY on a quarterly basis. 
    Utilities such as Reorgs and Modify affect these.

    Steve

    ------------------------------
    Steven Lamb
    ------------------------------



  • 3.  RE: general recommendations on catalog object (dsndb06) reorgs

    Posted Sep 23, 2021 09:49 AM
    yeah we also do the same as Steve - and we also do some DSNDB01 tablespaces, to clear up disk space...

    ------------------------------
    Aurora


    Stay safe and healthy, y'all
    ------------------------------