SELECT IND.INDSCHEMA AS SCHEMA_NAME
,      IND.INDNAME AS INDEX_NAME
,      IND.IID AS INDEX_ID
,       CASE IND.INDEXTYPE
           when 'BLOK' then 'Block index'
           when 'REG'  then 'Regular index'
           when 'CPMA' then 'Page map index for a column-organized table'
           when 'RCT ' then 'Key sequence index for a range-clustered table'
           when 'CLUS' then 'Clustering index'
           when 'TEXT' then 'Text index'
           when 'DIM'  then 'Dimension block index'
           when 'XPTH' then 'XML path index'
           when 'XRGN' then 'XML region index'
           when 'XVIL' then 'Index over XML column (logical)'
           when 'XVIP' then 'Index over XML column (physical)'
           end as index_type,
       CASE IND.UNIQUERULE 
           when 'P' then 'Primary key'
           when 'U' then 'Unique'
           when 'D' then 'Permits Duplicate'
       END AS TYPE
,      IND.TABNAME AS TABLE_NAME
,      LISTAGG(COLS.COLNAME, ', ')
           WITHIN GROUP (ORDER BY COLS.COLNAME) AS COLUMNS
  FROM SYSCAT.INDEXES IND
       JOIN SYSCAT.INDEXCOLUSE COLS
         ON IND.INDNAME = COLS.INDNAME
        AND IND.INDSCHEMA = COLS.INDSCHEMA
  WHERE IND.TABSCHEMA NOT LIKE 'SYS%'
  GROUP BY IND.INDNAME
  ,        IND.INDSCHEMA
  ,        IND.IID
  ,        IND.UNIQUERULE
  ,        IND.INDEXTYPE
  ,        IND.TABNAME
  ORDER BY SCHEMA_NAME
  ,        INDEX_NAME
  ,        INDEX_ID;