Hi,
I have few question related to tracking of Indexes usages on DB2.

(1) How to get information about unused indexes on database?
(2) How to get information about missing indexes\ Required indexes on database?

Thanks

in 9.7 luw fp(?)
there are some new columns in the catalog : last_used
they can give an indication if an index has never been used
missing indexes : monitor long running queries - doing tablescan....collect workload - explain

Can you please give reference of related catalogs.

all info is over here
IBM DB2 9.7 for Linux, UNIX and Windows Information Center
look at sysibm syscat....

db2pd -d <dbname> -tcbstats all , will give index usage statistics since database activation, you may want to consider, apart from lastused column from syscat.indexes .

for required indexes try db2advis