On DB2 you can use the following one.
SELECT name, card, npages, fpages, stats_time FROM sysibm.systables WHERE creator = 'MAXIMO' AND type='T' 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.