The Visual Studio.NET add-in for DB2, which is part of the “Stinger“ release, offers a much better implementation of the Server Explorer for DB2 users. But I recently found myself needing Index information from a DB2 database without any good schema exploration tool...
SELECT SYSCOLUMNS.TBNAME, SYSCOLUMNS.TBCREATOR, SYSKEYS.IXNAME, SYSKEYS.COLNAME, SYSKEYS.COLSEQ, SYSCOLUMNS.NAME, SYSCOLUMNS.TBNAME, SYSCOLUMNS.TBCREATOR, SYSCOLUMNS.COLNO, SYSCOLUMNS.COLTYPE, SYSCOLUMNS.LENGTH,SYSCOLUMNS.SCALE, SYSCOLUMNS.NULLS
FROM SYSIBM.SYSKEYS SYSKEYS ,SYSIBM.SYSCOLUMNS SYSCOLUMNS INNER JOIN SYSIBM.SYSINDEXES SYSINDEXES ON SYSINDEXES.NAME = SYSKEYS.IXNAME
WHERE SYSKEYS.IXCREATOR = SYSCOLUMNS.TBCREATOR
AND SYSKEYS.COLNAME = SYSCOLUMNS.NAME
AND SYSKEYS.COLNO = SYSCOLUMNS.COLNO
AND SYSKEYS.IXCREATOR = '<CREATOR>'
AND SYSINDEXES.TBNAME ='<TABLENAME>'
AND SYSCOLUMNS.TBNAME = SYSINDEXES.TBNAME
AND SYSINDEXES.CREATOR = '<CREATOR>'
ORDER BY TBNAME,IXNAME,COLSEQ