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