News
Abstract
Index 'Creation Date' added to Navigator's Schemas & Db2 for i Catalogs
Content
For Database Engineers (DBEs) who are responsible for the index strategy and performance tuning, its helpful to see full details about the existing indexes. The usage detail can guide the DBE to decide whether to retain or remote a performance related index.
The 'Creation date' column has been added to the the DB2 for i statistical catalogs and within IBM i Navigator under the Schema dialog for Indexes.
DB2 for i Catalog changes:
SYSINDEXES catalog
The SYSINDEXES view contains one row for every index in the SQL schema created using the SQL CREATE INDEX statement, including indexes on the SQL catalog. The full description of this catalog can be found here: SYSINDEXES
The following column has been added:
| Column Name | System Column Name | Data Type | Description |
|---|
| CREATED | CREATED | TIMESTAMP | The timestamp when the SQL index was created. |
SYSINDEXSTAT catalog
The SYSINDEXSTAT view contains one row for every SQL index partition.
Use this view when you want to see information for a specific SQL index or set of SQL indexes. The information is similar to that returned via Show Indexes in IBM i Navigator. The full description of this catalog can be found here: SYSINDEXSTAT
The index create columns are shown below. The CREATE_TIMESTAMP column was redefined as shown below. The INDEX_CREATE_TIMESTAMP column has been added:
| Column name | System Column Name | Data Type | Description |
|---|
| INDEX_CREATE_TIMESTAMP | INDCREATED | TIMESTAMP | The timestamp when the SQL index was created. |
| CREATE_TIMESTAMP | CREATED | TIMESTAMP | The timestamp when the SQL index partition was created. |
IBM i Navigator - Schemas dialog
If the new column does not appear under the IBM i Navigator Schemas dialog for Indexes, use the column customization capability to add the column.
Was this topic helpful?
Document Information
Modified date:
26 March 2025
UID
ibm11171132