Space: Tables and Indexes (DB2 UDB for UNIX and Windows) 

This function is only available for RFC-monitored systems.

You can access information on space for tables and indexes by calling the DBA Cockpit and choosing Space ®Tables and Indexes in the navigation frame of the DBA Cockpit.

When you call this transaction for the first time, the following check on the system catalog tables is performed:

·        Are there tables that do not yet have an entry in the CCMS control table DB6TREORG? (This table is always filled by CCMS programs after REORGCHK.)

·        Are there tables that have entries in the CCMS control table DB6TREORG and that are not up-to-date with the system catalog?

If any tables are found, a dialog box appears listing those tables that require reorganization. To adjust the tables, choose  REORGCHK. If you do not want to start a REORGCHK, choose   Continue.

Be aware that running a REORGCHK on the listed tables may take a long time and affect the database performance. Therefore, we strongly recommend that you plan a REORGCHK for all tables using the DBA Planning Calendar.

A Selection Criteria dialog box appears in which you can limit the result set displayed according to the following criteria:

Field	Description
Filters
Tablespace Name	Indicates the location of the table
Table Name	Name of the table
Table Size	Size of the table
Display Flagged Tables Only	Restricts the number of displayed tables. If this flag is not set, only tables are displayed that have a recommendation for table or primary index reorganization.
Display Options
Sort by	Sorts the tables by Size or Name
Maximum Number of Rows	Number of rows to be displayed

To display the first hundred tables with the largest size, choose Size in the Display Options group box and enter 100 in the Maximum Number of Rows field.

When you have made your selections and chosen OK, the Space: Table and Indexes screen appears with the following information:

Column	Description
Schema	Schema of the table, usually the user who created the table
Table Name	Name of the table
Tablespace Name	Tablespace to which the table currently belongs
F1	Overflows rows as a percentage
F2	Table size divided by allocated space as a percentage
F3	Full pages divided by allocated pages as a percentage
Table Flagged	Indicates that table reorganization is recommended
Index Flagged	Indicates that table reorganization is recommended because of primary index
Size (KB)	Table size
REORG Check Date	Date of the last REORG check, for example, the date when RUNSTATS ran using program dmdb6srp
REORG Check Time	Time of the last REORG check, for example, the time when RUNSTATS ran using program dmdb6srp

If you want to change the selection, choose  Set Selection Criteria. The Selection Criteria dialog box appears and you can make your new selection.

To display detailed information on tables and indexes, double-click a table or choose  Details. A detail screen is displayed with information on tables, indexes and table structures. You can directly access this screen by choosing Space ®Single Table Analysis in the navigation frame of the DBA Cockpit. For more information, see Space: Single Table Analysis.