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":"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
ibm11131903