Find large Maximo tables on DB2

I this article I have explained how to list the larger database tables and indexes on Oracle.
On DB2 you can use the following one.

SELECT name, card, npages, fpages, stats_time
FROM sysibm.systables
WHERE creator = 'MAXIMO'
AND type='T'

The returned columns are:

  • NAME: Name of the table
  • CARD: Number of rows
  • NPAGES: Total number of pages on which the rows of the table exist
  • FPAGES: Total number of pages
  • STATS_TIME: Date when the statistics of the table were collected

The STATS_TIME is important both to understand if statistics are updated in your database (which is important for performances) and for check if the data retrieved is updatad. If timestamps here are too old you should regenerate database statistics. You can do this selecting Update Statistics action from the Database Configuration application menu.

Maximo Health Check report

There is now a better and easier way to have the same information and much more details about potential performance issues in Maximo just by running a BIRT report.
Check out the Maximo Health Check report on developerWorks.

Find large Maximo tables on DB2

2 thoughts on “Find large Maximo tables on DB2

  1. Hi Bruno, I am executing Update Statistics action from the Database Configuration application menu.
    Please let me know,
    1. Where can we check the logs or the process of update statistics.
    How can we know update statistic is finished.
    2. Normally how much tie it will take to update the statistics for a database size of 6 gb.
    3. Database we are using is db2 and maximo 7.5 version.

  2. May I know at what frequency or on what basis the statistics of the tables gets updated automatically in db2

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top