IBM Support

Creating a REORG utility statements for all tables in MAXIMO database

Technical Blog Post


Abstract

Creating a REORG utility statements for all tables in MAXIMO database

Body

Please run the fallowing

select 'REORG TABLE MAXIMO.'CONCAT NAME CONCAT ';' FROM SYSIBM.SYSTABLES WHERE CREATOR ='MAXIMO' AND TYPE='T';

This statement generates actual utility statements for all tables in maximo database.

This query could be useful when changes are done to all tables in maximo db2 database.

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

UID

ibm11131903