[[{“value”:”As part of the latest round of Technology Refreshes, IBM i 7.5 TR5 and 7.4 TR11, the MTI_INFO Table function was enhanced with the addition of the member or Table partition name the MTI was created over. I have to admit I was surprised this was not included when the Table function was first introduced.
The new column is called TABLE_PARTITION, it is the third column in the results, and is a VARCHAR of a maximum of 128 characters.
If I just wanted to view all of the MTIs in my partition I would use the following statement:
01 SELECT TABLE_SCHEMA,TABLE_NAME,FILE_NAME,
02 TABLE_PARTITION
03 FROM TABLE(QSYS2.MTI_INFO())
04 ORDER BY 1,2
05 LIMIT 5
Read more »”}]] Read More
