How to use the infx profile dashboard to get detailed database stats

A short demonstration of how to get detailed table and index information using the infx table profiler. Includes statistics on sizing, locking and access for each table and index.

View table and index information:

1. Table access, such as buffer and page read/writes
2. Table locking, such as a table lock summary and total locking requests
3. Table space allocations for each table partition and index
4. Table schema information
5. Detailed statistics about individual indices
6. Detailed statistics about individual table partitions

Perform table maintenance actions:

1. Run the oncheck utility on a table
2. Table re-size, re-pack, shrink.
3. Change lock mode of a table