Performance: Table Snapshot (DB2 UDB for UNIX
and Windows) 
The Table Snapshot screen displays information on all tables of the database, such as the number of rows read, the number of rows written, the number of accesses to rows that have been moved out of the page due to overflow (Overflow Access) and page reorganizations (Page Reorgs).
You can access the Table Snapshot screen by calling the DBA Cockpit and choosing Performance ®Tables in the navigation frame of the DBA Cockpit.
The following information is displayed:
|
Column |
Description |
|
Table Schema |
Name of the schema |
|
Table Name |
Name of the table |
|
Table File ID |
File ID (FID) of the table |
|
Table Type |
Type of table for which information is displayed, for example, user, system or temp |
|
Rows Written |
Number of rows changed (inserted, deleted or updated) in the table |
|
Rows Read |
Number of rows read from the table |
|
Overflow Access |
Number of accesses (reads and writes) to overflowed rows of the table. Overflowed rows indicate that data fragmentation has occurred. If this number is high, you may be able to improve table performance by reorganizing the table using the REORG utility, which cleans up this fragmentation.
Pay particular attention to this column. If the value in this column is very high, you should consider reorganizing the table. |
|
Page Reorgs |
Number of page reorganizations executed for the table. Too many page reorganizations can result in less than optimal insert performance. You can use the REORG TABLE utility to reorganize a table and eliminate fragmentation. |
If you double-click a line, detailed table analysis data is displayed as described in Space: Single Table Analysis.