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
WHERE creator = 'MAXIMO'
ORDER BY card DESC;
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.