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