You can customize the database maintenance tool to specify
which formulas determine whether a database is reorganized.
About this task
To specify which formulas can trigger a database reorganization,
edit the properties in the TPCDBMaintenance.properties file.
For example, you can customize the tool to ignore tables that are
smaller or larger than the defined size limits, or customize it to
always reorganize the database.
Procedure
To analyze and reorganize databases, follow these steps:
- Log on to the system where IBM
Spectrum Control is
installed.
- Change to the following directory:
- Linux® and UNIX operating systems
/opt/IBM/TPC/data/server/tools/- Windows operating systems
C:\Program files\IBM\TPC\data\server\tools\
- Open TPCDBMaintenance.properties in
a text editor and modify the property settings as needed.
The f1-f8 properties all refer to the same formulas that are used by the DB2® REORGCHK command. For more information about any of these formulas, see the DB2 product documentation about the REORGCHK command
at https://www.ibm.com/docs/en/db2.
You
can modify the following properties:
- f1= {true | false}
- Specifies whether the result of formula 1 can trigger a database
table reorganization. Formula 1 checks the number of overflow rows
in a table.
- f2= {true | false}
- Specifies whether the result of formula 2 can trigger a database
table reorganization. Formula 2 checks the effective space utilization
of data pages.
- f3= {true | false}
- Specifies whether the result of formula 3 can trigger a database
table reorganization. Formula 3 checks the number of empty pages.
Pages can become empty after rows are deleted.
- f4= {true | false}
- Specifies whether the result of formula 4 can trigger the reorganization
of index data. Formula 4 checks the clustering ratio of an index.
- f5= {true | false}
- Specifies whether the result of formula 5 can trigger the reorganization
of index data. Formula 5 checks the space that is reserved for index
entries.
- f6= {true | false}
- Specifies whether the result of formula 6 can trigger the reorganization
of index data. Formula 6 determines whether re-creating an index would
result in a tree with fewer levels.
- f7= {true | false}
- Specifies whether the result of formula 7 can trigger the reorganization
of index data. Formula 7 checks the number of pseudo-deleted RIDs
on non-pseudo-empty pages.
- f8= {true| false}
- Specifies whether the result of formula 8 can trigger the reorganization
of index data. Formula 8 checks the number of pseudo-empty leaf pages.
- maxReorgTableSize= {size_in_bytes | none}
- Specifies the maximum size that a database table must be to be
considered for reorganization.
- minReorgTableSize= {size_in_bytes | none}
- Specifies the minimum size that a database table must be to be
considered for reorganization.
- forceReorg= {true | false}
- Specifies whether the database is always reorganized by the database
maintenance tool when the reorg argument is specified.
If this property is set to true, all other properties
in the file are ignored.
- Save TPCDBMaintenance.properties.