MTI info for a table

[worksofliam]

--   
-- MTIs that exist for a specific file
--  	 
with mtis(keys, KEY_DEFINITION, MTI_SIZE, LAST_BUILD_START_TIME, LAST_BUILD_END_TIME) as (
select  keys,  KEY_DEFINITION, max(MTI_SIZE), max(LAST_BUILD_START_TIME), max(LAST_BUILD_END_TIME)
  from table (
      qsys2.mti_info(TABLE_SCHEMA => 'TOYSTORE3', TABLE_NAME => 'ITEM_FACTH')
    ) group by keys,  KEY_DEFINITION 
    )
    select KEY_DEFINITION, MTI_SIZE,  timestampdiff_big(4, cast(LAST_BUILD_END_TIME - LAST_BUILD_START_TIME as char(22)))
         as index_build_minutes
         from mtis;
stop;

or

--   
-- MTIs that exist for a specific file
--  	 
with mtis(keys, KEY_DEFINITION, MTI_SIZE, LAST_BUILD_START_TIME, LAST_BUILD_END_TIME) as (
select  keys,  KEY_DEFINITION, max(MTI_SIZE), max(LAST_BUILD_START_TIME), max(LAST_BUILD_END_TIME)
  from table (
      qsys2.mti_info(TABLE_SCHEMA => 'KRAKEN77', TABLE_NAME => 'ITEM_FACTH')
    ) group by keys,  KEY_DEFINITION 
    )
    select KEY_DEFINITION, MTI_SIZE,  LAST_BUILD_START_TIME, LAST_BUILD_END_TIME
 from mtis;

or

--
-- MTIs that exist for a specific file
--
select KEYS, KEY_DEFINITION, REFERENCE_COUNT, STATE, MTI_SIZE, CREATE_TIME, LAST_BUILD_START_TIME,
       LAST_BUILD_END_TIME, REUSABLE, SPARSE, SPARSE_DEFINITION, QRO_HASH, PLAN_IDENTIFIER
  from table (
      qsys2.mti_info(TABLE_SCHEMA => 'KRAKEN77', TABLE_NAME => 'ITEM_FACTH')
    )