Technical Blog Post
Identifying the Reorg candidates in maximo db2 database.
It is important to maintain a good health of the database and run
Reorganization Utility on tables and indexes to help Optimizer
keep the best access path. So please run the following sql that would build
an executable statements that need to be run to provide a report.
select 'reorgchk update statistics on table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,50),';' from syscat.tables where type = 'T' and tabschema='MAXIMO'
Sample of the executable statement:
reorgchk update statistics on table maximo.workorder;
Please see the attached report with comments.