IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

IBM DB2 data maintenance

Complete the following steps to perform IBM DB2 data maintenance:

  1. Login to the IBM DB2 server.

  2. Enter the following command:
    db2 connect to octigate user db2inst1

    You are not required to login as the db2inst1 user. The amuser user would also be acceptable.

  3. Enter the following command:
    db2 reorgchk update statistics on table tablename
    Go to Steps 4 and 5 for table reorganization if an asterisk is shown in the REORG column of the output; otherwise, skip them.

  4. Enter the following command:
    db2 reorg table am.tablename index indexname inplace allow write access

  5. Enter the following command:
    db2 runstat on table tablename allow write access


Parent topic:

Performing database optimization

+

Search Tips   |   Advanced Search