Skip to Main Content
IBM Power Ideas Portal

This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Not under consideration
Workspace IBM i
Categories Db2 for i
Created by Guest
Created on Nov 4, 2022

Additional columns for MTI_INFO table function

It would useful also to retrieve:

- the number of rows of the table.

- the number of entries of the temporary index (if sparse).

- the number of utilization of this temporary index. We already have the number of references.

- the order (ASC or DESC) of the keys in KEY_DEFINITION column to be consistent with presentation of keys in Q1000L column of QQRID=3002 record (snapshot of plan cache).

- the sequence table name and its library.

This will allow to decide if this temporary index should be permanently created and gives all the information to create it.

Idea priority Low
  • Guest
    Dec 6, 2022

    Some comments:

    #1 MTI_INFO delivers the list of MTI that currently exists on partition.

    QSYS2.SYSIXADV delivers the list of MTIs has been created but there is no way to know if these MTIs still exist.

    The fact that an MTI has been created after the last IPL does not means that the MTI still exists.

    #2 QSYS2.SYSIXADV does not indicate if it is a full or sparse index.

    #3 QSYS2.SYSIXADV does not indicate if the key orders are ASC or DESC.

  • Guest
    Dec 5, 2022
    IBM does not intend to provide a solution to this Idea at this time, so it is being closed. 

    We do not plan to add information that is not directly associated with MTIs to this table function. Much of the information you are asking for is available through SQL already, contained in the QSYS2.SYSTABLESTAT and QSYS2.SYSIXADV views. Combining this information into a single query is being considered for an upcoming example that would be published as a gist. When/if that happens, this Idea will be updated with a link to the example.