Using DB2 9.5...
In the control center I see some statistics related to Index-Sizes. I want to know how the sizes are calculated.
Can someone tell me what are the queries used to calculate those figures.
Thanks.

You can query the DB2 catalog tables to retrieve the number of index levels and number of leaf pages. Furthermore, you can determine the average key length and the page size for index pages. Based on that, you can determine the fan-out on a single index level: page size / avg key length. This and the index tree height gives you the estimated number of non-leaf nodes.

well....
I believe I can pick number of index levels (NLEVELS) and number of leaf pages (NLEAF) from SYSCAT.INDEXES and pagesize (PAGESIZE) from SYSCAT.TABLESPACES .
I am not sure abt the key-length thing that u r talking about. Can u please elaborate..?? Moreover I could not arrange the things into a formula to get those figures I see at my control center.