Name
Schema
Tablespace
Number of rows
Average row length
New total number of rows
New average row length
Type
Name
Schema
Tablespace
Current size
Estimated size
Minimum size
Maximum size
Statistics timestamp
Display sizes in units of
Refresh
Run statistics
Close
Name
This field displays the table name being analyzed by the Estimate Size window. You cannot alter the name.
Schema
This field displays the schema name of the table and its associated indexes. You cannot alter the schema.
Tablespace
This field displays the table space name where the table being analyzed is stored. You cannot alter the table space.
Number of rows
This field displays the number of rows in the table. If statistics are available for this table, this field contains the number of rows in the table when the statistics were collected.
If the table already exists, but no statistics are available, this field displays Not Available. If you are creating a new table this field contains zero.
You cannot alter the number of rows except by changing the number of rows in the database and rerunning statistics. Statistics information can be found in the catalog table SYSSTAT.TABLES.
Average row length
This field displays the average length of all the rows in the table. If statistics are available for this table, this field is the average row length calculated from statistics.
If you are creating a new table or no statistics are available for this table, this field is the sum of each column's theoretical average size. Fixed columns use their normal size. Variable length columns (VARCHAR, VARGRAPHIC) use the average of their maximum and minimum values. Columns that reference data outside of the table (LONG VARCHAR, LONG VARGRAPHIC, DATALINK, LOB, BLOB, CLOB, DBCLOB) only include the size of their fixed pointer.
You cannot alter the average row length except by choosing to Run statistics on the existing table or by changing the definition of the table itself. This information can be found in the catalog table SYSSTAT.TABLES.
New total number of rows
This field defaults to the Number of rows in the table. To change the number of rows, click on the up or down arrow to change the value or type a number in the field. Select Refresh to recalculate the estimated size of the table and indexes.
New average row length
This field defaults to the Average row length. To change the average row length, click on the up or down arrow to change the value or type a number in the field. Select Refresh to recalculate the estimated size of the table and indexes.
Type
This column indicates whether the size estimate is on a table or index.
Name
This column displays the name of the table or index being analyzed.
Schema
This column displays the name of the schema for the table or index.
Tablespace
This column displays the name of the table space where the table being analyzed is stored.
Current size
This column displays the current calculated space for a table or index.
Estimated size
This column displays the estimated amount of space required for a table or index. This column is updated using the values specified in the New total number of rows field and the New average row length field.
If valid statistics are available, the actual number of pages is used instead of the average row length and number of rows. This information can be found in the catalog tables SYSSTAT.TABLES and SYSSTAT.INDEX. The table statistic NPAGES and the index statistic NLEAF are used from these catalog tables.
Minimum size
This column displays the minimum required space for the table or index when variable length data (VARCHAR, VARGRAPHIC) is as small as possible. This column is updated using the values specified in the New total number of rows field.
Maximum size
This column displays the maximum required space for the table or index when variable length data (VARCHAR, VARGRAPHIC) is as large as possible. This column is updated using the value specified in the New total number of rows field.
Statistics timestamp
This column displays the last time statistics were collected for a table or index. Check this column to see when you last ran statistics. It is blank if you have never run statistics. This information can be found in the catalog tables SYSCAT.TABLES and SYSCAT.INDEXES in the column STATS_TIME.
Display sizes in units of
Use this box to specify the units in which to display the sizes. Click on the down arrow to display a list of existing units and select one. Sizes in page units are calculated using the page sizes (4KB, 8KB, 16KB, 32KB) as specified in the table space definition.
