SYSINDEXES Query

SELECT *
FROM SYSIBM.SYSINDEXES
-- WHERE CREATOR = 'INDEXCREATORNAME'
-- AND TBNAME = 'TABLENAME'
-- ORDER BY NAME
;