There is information that you can use to help you plan for the resources that you will require to monitor your database environment with InfoSphere Optim Performance Manager.
Each monitored database, database partition (in DPF instances), or member (in pureScale instances) requires operating system resources (for example: memory, CPU, disk space, and network) on the InfoSphere Optim Performance Manager server to collect, process, and store the monitoring data. It is important to ensure that your InfoSphere Optim Performance Manager server has sufficient capacity to monitor the intended environment.
The best way to estimate the resources required for your InfoSphere Optim Performance Manager deployment is by working with your IBM representative.
Capacity planning questionnaire
For InfoSphere Optim Performance Manager v5.1.x, there is a questionnaire that you can complete to help your IBM representative estimate the capacity of the InfoSphere Optim Performance Manager server for your environment. The questionnaire contains full instructions and can be downloaded from the following web site:
Complete and return the appropriate sections of the questionnaire. Your IBM representative will then perform capacity planning calculations and return to you the estimated CPU, memory, and disk capacity requirements for an InfoSphere Optim Performance Manager server in your environment.
If you are planning an InfoSphere Optim Performance Manager v4.x deployment, see the related techdoc.
Enabling compression on performance manager tables:
InfoSphere Optim Performance Manager deployments for large scale environments (for example: DPF environments, high volume transactional systems, or large numbers of monitored servers) can result in very large storage requirements for collecting and retaining performance data. The DB2 Storage Optimization Feature is highly effective in reducing the storage requirements for performance data.
In InfoSphere Optim Performance Manager v5.1.x, row compression is enabled by default as long as the appropriate Storage Optimization License is in place.
Note that with InfoSphere Optim Performance Manager V5, when InfoSphere Optim Performance Manager and the Storage Optimization Feature are purchased together in a DB2 offering such as Advanced Enterprise Server Edition or InfoSphere Warehouse Advanced Enterprise Edition, then the Storage Optimization Feature may be used with the InfoSphere Optim Performance Manager performance repository as well. Otherwise, it must be purchased for use with the InfoSphere Optim Performance Manager repository.
In InfoSphere Optim Performance Manager v5.1, compression must be enabled on the DIM_STATEMENT_COMPILATION and DIM_STATEMENT_TEXT tables manually. Compression on these tables is enabled by connecting to the InfoSphere Optim Performance Manager repository database and issuing the following DB2 statements for each monitored data source:
“alter table DB2PM_<mon_instance_id>.DIM_STATEMENT_COMPILATION compress yes”
“alter table DB2PM_<mon_instance_id>.DIM_STATEMENT_TEXT compress yes”
Where <mon_instance_id> represents the InfoSphere Optim Performance Manager monitoring instance ID.
In InfoSphere Optim Performance Manager v5.1.1 and beyond, compression is automatically enabled for these tables.
For more information about capacity planning and deployment of InfoSphere Optim Performance Manager, see the best practices white paper: "Deploying Optim Performance Manager in large scale environments".
Although this white paper contains sample configurations, work with your IBM representative for best results.
In this white paper, learn about best practices for deploying InfoSphere Optim Performance Manager Extended Edition in large scale environments. Although this document is written for Version 4 of Optim Performance Manager, many of the tips can also be used for the Version 5 release if you are monitoring DB2 V9.1 or V9.5 databases.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.