IBM Support

QSYS2.MTI_INFO()

News


Abstract

The MTI_INFO table function returns information about active SQL Query Engine (SQE) Maintained Temporary Indexes (MTIs).

Content

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:
  1. TABLE_SCHEMA - The name of the schema containing the table. Either the SQL schema name, library name, or *ALL is accepted.
  2. 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
02 May 2022

UID

ibm16579391