zOs/TX/PER14CLU

select    case when t.kNos = left(j.kNos, length(t.kNos))
                               then 'O' else '*' end
       || case when t.kNames = left(j.kNames, length(t.kNames))
                               then 'A' else '*' end
       || i.clustering
       || i.clustered,
       i.indexType "iTy",
       i.clusterRatio "cluRa",
       substr(strip(t.cr) || '.' || t.nm, 1, 20) "table",
       substr(j.nm, 1, 12) "index",
    t.*, j.*, i.*
    from A540769.tPer14 t
      join sysibm.sysIndexes i
        on i.tbCreator = t.cr and i.tbName = t.nm
           and i.clustering = 'Y'
      join  A540769.tPer14 j
        on i.creator = j.cr and i.Name = j.nm and j.type = 'i'
    where t.type in ('t', 'u')
    order by 1, t.cr, t.nm, j.cr, j.nm