BMC Software, Inc., Confidential and Proprietary Information
4-2 Administrative Products for DB2 Installation Guide
Performance Considerations
Performance Considerations
DB2 Version 4 and later allows indexes on the catalog. To improve
performance, BMC Software recommends that you create indexes on the
following DB2 catalog tables:
• SYSIBM.SYSCOLAUTH
• SYSIBM.SYSDBRM
• SYSIBM.SYSFIELDS
• SYSIBM.SYSFOREIGNKEYS
• SYSIBM.SYSRELS
• SYSIBM.SYSSTMT
• SYSIBM.SYSSYNONYMS
• SYSIBM.SYSTABAUTH
• SYSIBM.SYSTABLES
• SYSIBM.SYSVIEWDEP
Depending on the functionality used in a product, you may be able to create
several other indexes that improve the performance of the product. Refer to
HLQ.CNTL (DCIDB2IX) for details on creating these indexes. You can
implement the desired indexes by reading the comments in this member. For
indexes used with catalog indirection, refer to HLQ.CNTL (DCIDB2ZX).
Adding Products to the BMCDB2PR Panel
The Tools Install System enables you to add products that are not included on
the TIS or SAT tapes to the BMCDB2PR panel. The following BMC
Software products can be added to the BMCDB2PR panel:
• ACTIVITY MONITOR for DB2 (DOM)
• APPTUNE
™
for DB2 (ASQ)
• CHANGE ACCUMULATION PLUS (ACA)
• COORDINATED RECOVERY MANAGER (CRR)
• COPY PLUS for DB2 (ACP)
• EXTENDED BUFFER MANAGER (XBM)
• Log Master
™
for DB2 (ALP)
• OPERTUNE
®
for DB2 (DDT)
• OPERTUNE for MQSeries (DDM)
• PACLOG
™
for DB2 (ALM)
• RECOVERY MANAGER for DB2 (ARM)
• RECOVERY MANAGER for OS/390 (MRM)
