IBM Support

Identifying the Reorg candidates in maximo db2 database.

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.

 

image

 

 

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11132095