Db2 Tools

Expand all | Collapse all

  Db2 reorg using when                        

Jump to Best Answer
  • 1.    Db2 reorg using when                        

    Posted 10-18-2018 09:13 AM

    I want to reorg a tablespace and in the same step discard old rows using WHEN.

    I have only one table in the tablespace but creator.tablename is not delivered by CA DATABASE ANALYZER 

    DISCARD FROM TABLE %CREATOR..%TBNAME                        
        WHEN (D_CHANGE_TIMESTAMP < CURRENT TIMESTAMP - 475 DAYS)  



  • 2.  Re:   Db2 reorg using when                        
    Best Answer

    Posted 10-25-2018 12:10 PM

    Hello,

    I'd recommend that you open a case with support for Database Analyzer.

    Thanks