Technical Blog Post
Abstract
Identifying the Reorg candidates in maximo db2 database.
Body
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.
Build statement:
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
UID
ibm11132095