...
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 > >