...
The following table describes the information displayed for the Schemata entity.
Table 6- 1 Schemata
Column | Description |
---|
Schema | Schema name. |
Owner | Owner name. |
Definer | The user who defined the schema. |
Creation Time | Time of schema creation. |
Tables
Two association selector options are available:
- Dictionary tab. Shows dictionary information for the table.
- Storage & statistics tab. Shows table storage information and RUNSTATS information. This is the default view. The following table describes the information displayed in the Dictionary tab.
Table 6- 2 Dictionary tab
Column | Description |
---|
Name | Table name. |
Schema | Table's schema. |
Type | Temporary, MDC, MQT or normal. |
Tablespace | Name of primary tablespace. |
Statistics Run | Date last analyzed. |
Range Partitioned | Yes – for Range Partitioned table. |
DB Partitions | The number of DB partitions this table exists in. |
Indexes | The number of indexes defined for this table. |
Logged | No or blank. |
Lock Mode | The Lock Mode type. |
Index Tablespace | Name of the tablespace which contains the indexes. |
LOB Tablespace | Name of the tablespace which contains the LOBs. |
The following table describes the information displayed in the Storage and Statistics tab.
Table 6- 3 Storage and Statistics tab
Column | Description |
---|
Name | Table name. |
Schema | Table's schema. |
Type | Temporary, MDC, MQT or normal. |
Tablespace | Name of primary tablespace. |
Statistics Run | Date last analyzed. |
Pages Allocated | How many pages are allocated. |
Pages Used | How many pages contain actual data. |
Rows | How many rows. |
Ave. Row Len | Average row length (bytes). |
Clustering Factor | The clustering factor of the clustering index (if one exists) or blank if no clustering index was defined. |
Extent size | Size of extent (from tablespace definitions). |
% Free Pages | % Free of pages. |
% Overflows | % of records overflowing. |
Rows per Page | Rows / (# of used pages). |
Indexes
The following table describes the information displayed in the Dictionary tab.
Table 6- 4 Dictionary tab
Column | Description |
---|
Name | Index name. |
Schema | Index schema. |
Table Name | Base table name. |
Key Columns | The number of participating columns in the index. |
Includes | The number of columns included in the index. |
Type | Clustering, Dimensions block, Block or blank for regular. |
Unique | Yes, No, or Primary. |
Columns | The list of participating columns in the index. |
Statistics Run | Time last analyzed. |
Tablespace | Name of the tablespace which contains the index. |
Table Schema | The table’s schema. |
The following table describes the information displayed in the Storage and Statistics tab.
Table 6- 5 Storage and Statistics tab
Column | Description |
---|
Name | Index name. |
Schema | Index schema. |
Tablespace | Name of the tablespace which contains the index. |
Statistics Run | Time last analyzed. |
Clustering Factor | Clustering factor or Cluster ratio if factor is not available. |
Levels | How many levels exist. |
First Column Distincts | The number of distinct first-key values. |
Second Column Distincts | The number of distinct keys using the first two columns. |
Distinct Values | The number of distinct values. |
Leafs | How many leaf pages are in use. |
Key Length | The key length. |
% Deleted Rows | The percentage of rows marked ‘Deleted’. |
Leaf Distribution | Avg. length between leaf pages. |
% Empty Pages | Percentage of empty pages. |
% Free | Percentage of each index page to be reserved during initial index building. |
Extent Size | Taken from tablespace definitions. |
Views
The following table describes the information displayed for the Views entity.
Table 6-6 Views
Column | Description |
---|
View Name | View name. |
Owner | View owner. |
Definer | Name of view creator. |
Valid | Is the view valid. |
Text | Unformatted first N characters of view's definition. |
Anchor |
---|
| DatabasePartitionGroups |
---|
| DatabasePartitionGroups |
---|
|
Database Partition Groups
The following table describes the information displayed for the Database Partition Groups entity.
Table 6- 7 Database Partition Groups
Column | Description |
---|
Name | Name of the partition group. |
Partitions | Number of partitions in this group. |
Definer | Name of the user who defined the group. |
Create Time | Time group was created. |
Tablespaces
The following table describes the information displayed for the Tablespaces entity.
Table 6- 8 Tablespaces
Column | Description |
---|
Name | Tablespace name. |
Type | DMS or SMS. |
Data Type | All, LOB, System temp or Declared temp. |
Bufferpool | Name of the bufferpool associated with this tablespace. |
Bufferpool Size | Size of bufferpool on all partitions. |
Page Size | Page size. |
Pages Allocated | Total tablespace size. |
Pages Used | Total tablespace used (only for DMS). |
Extent Size | Number of pages per extent. |
Prefetch Size | Defined prefetch size or Automatic. |
Defined in Group | The name of the partitioned group. |
Overhead | DB2 internal parameter describing the overhead associated with the tablespace's disks. |
Transfer Rate | DB2 internal parameter, describing the time it takes to read one page. |
Definer | Name of the user who defined the tablespace. |
Remarks | User comments. |
Bufferpools
The following table describes the information displayed for the Bufferpools entity.
Table 6- 9 Bufferpools
Column | Description |
---|
Name | Bufferpool name. |
Size (Pages) | Bufferpool size. |
Page Size | Page size of the bufferpool. |
Defined in Groups | Comma separated list of the DB partition groups to which it belongs. |
All Tablespaces Size | Size, in MB, of all tablespaces associated with this bufferpool. |
Tablespaces | The number of tablespaces defined to use this bufferpool. |
Anchor |
---|
| DatabasePartitions |
---|
| DatabasePartitions |
---|
|
Database Partitions
The following table describes the information displayed for the Database Partitions entity.
Table 6- 10 Database Partitions
Column | Description |
---|
Server | Server name. |
ID | ID of the partition. |
Default on Server? | Yes, if this is the default partition when connecting to the database on that machine. |
Total Memory | Total shared memory dedicated for this database partition. |
Total Bufferpools Size | Total shared memory dedicated for this partition's BPs. |
Defined in Groups | Comma separated list of DB partition groups in which this DB partition participates. |
Precise. Performance intelligence from click to storage. Learn more > >