News
Abstract
The MTI_INFO table function returns information about active SQL Query Engine (SQE) Maintained Temporary Indexes (MTIs).
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.MTI_INFO()
Database Engineers (DBE) need tools and insights to help guide them in making the best decisions in the data center.
In the well-established tradition of Db2 for i services for the DBE, the MTI_INFO() user-defined table function has been added.
MTI_INFO accepts two parameters:
- TABLE_SCHEMA - The name of the schema containing the table. Either the SQL schema name, library name, or *ALL is accepted.
- TABLE_NAME - The name of the table. Either the SQL table name, file name, or *ALL is accepted.
Based upon the input parameters, rows are returned for all MTIs that exist over the table(s).
The columns contain detail that will help the DBE understand the existence, importance, and size of the MTIs.
This new insight will help DBEs decide when to adjust permanent index strategies.
For complete detail, visit this IBM Documentation page: MTI_INFO
Enhanced with IBM i 7.5 SF99950 Level 8 and IBM i 7.4 SF99704 Level 29:
- MTI_INFO returns the table's partition or member name
- MTI_INFO returns lists of QRO hashes and plan identifiers that have used the MTI
Internal Use Only
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
28 September 2024
UID
ibm16579391