Looking for Index Storage quality mgmt program same like Oracle RSORAISQ

[Former Member]

Hello,

Like we have program RSORAISQ (note : 712098) which is very good for providing the index storage quality for Oracle database, i am searching the same from DB2 .

This program provide the index quality information , which is very useful from performance monitoring.

I am looking same for DB2.

Let me know the note number or the program name which work same like the above.

[Former Member]

Hi,

you can use the DBA cockpit transaction. Call e.g. transaction DB02, then choose 'Space->Tablespace'. You will get a selection screen, where you can enter various selection criteria. If you click the checkbox 'Display flagged only', you get a list of all tables which have either a Table REORG recommendation or an INDEX reorg recommendation. In the result list you can also double-click and see further details of the table and its indexes, e.g. all the formula and recommendations of the REORGCHK utiltity in detail. This list is also the basis for the automatic REORG, which can be scheduled via DB13 planning calendar

Best regards

Ralf

[Former Member]

Hi,

the following index information is available with DB2 means:

- use the stored procedure REORGCHK_IX_STATS to determine the storage quality formulas F4-F8: With this information you can determine if index reorganization may be required.

- INDEX statistics can also be accessed using the SYSSTAT.INDEXES view.

- Simple Index statistics you get with db2pd -db <DB> -tcbstats index

- Bufferpool utilization you can obtain using db2pd -db <DB> -pages (the analysis of this data is no fun)

Best regards, Jens