...
The following entities can be examined in the Objects tab:
SchemataThe following table describes the information displayed for the Schemata entity.
...
| Column | Description |
|---|
| Schema | Schema name. |
| Owner | Owner name. |
| Definer | The user who defined the schema. |
| Creation Time | Time of schema creation. |
Two association selector options are available:
...
| 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). |
The following table describes the information displayed in the Dictionary 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. |
The following table describes the information displayed for the Views entity.
...
| 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 GroupsThe following table describes the information displayed for the Database Partition Groups entity.
...
| 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. |
The following table describes the information displayed for the Tablespaces entity.
...
| 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. |
The following table describes the information displayed for the Bufferpools entity.
...
| 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 PartitionsThe following table describes the information displayed for the Database Partitions entity.
...