Hi Narayana
I am a product manager for Quest Software's Quest Central for DB2. If your not familiar with the product it is a windows based database administration tool for DB2 UDB UNIX/NT, and OS/390. The tool is comprised of 4 main components: Database admiistration, SQL Tuning, Performance monitoring, and space management. The space management reports will provide the exact information you are looking for plus much more. The tool will allow you to define alert thresholds for many space parameters to alert you of space relating problems and to generate scripts to remedy these problems such as Reorg, or altering to add additional space as needed. You can get much more detailed info plus download a free 30-day trial of the product from our website: WWW.QUEST.COM./DB2
Hope this helps
Thanks
-----Original Message-----
From: Narayana Reddy Gandra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 11, 2001 11:37 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Index details
Hello All,
Can anyone tell me if there is a way in DB2 UDB for UNIX/Windoes to
obtain the each index information listed below?
a) Pages allocated (like NPAGES for table)
b) Pages used (like FPAGES for table)
c) Pages free
All Suggestions are welcome.
Thank you in advance!
-GNR
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
