IBM Support

How often should we set up a Cron Task in Maximo to run Update Statistics?

Question & Answer


Question

How often should we set up a Cron Task in Maximo to run Update Statistics?

Answer

There is no out-of-the-box Cron Task in Maximo to run Update Statistics.

When running Update Statistics via the Select Action menu in Database Configuration, Maximo calls the following script behind the scene for each table:

Update statistics example:

dbms_stats.gather_table_stats
(ownname => 'MAXIMO', tabname => 'ASSET', cascade => true)

Your Oracle DBA can schedule the job rather than doing it manually.
We highly recommend optimizing the statistics on your database once a week if your database is large.

For more details, please refer to:
DBMS_STATS package.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cron Task Setup","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.5;7.2.1;7.2;7.1.2;7.1.1;7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21623599

Page Feedback