IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
Version 5.3.0
Quick Start Guide for the SQL Dashboard and the end-to-end SQL monitoring functions
This guide helps you getting started with a typical installation for the SQL Dashboard and the end-to-end SQL monitoring (Extended Insight) feature of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, Version 5.3.0, abbreviated to OMEGAMON® XE for DB2® PE. This SQL monitoring feature uses the infrastructure of IBM® InfoSphere® Optim™ Performance Manager.
Product overview
OMEGAMON XE for DB2 PE is a tool for performance analysis, monitoring, and tuning for the DB2 database in the z/OS environment. It also provides a SQL Dashboard and an end-to-end SQL monitoring feature. With these SQL monitoring features, database administrators (DBAs) can extend monitoring to the entire database application system including client, server, and network.
After you have installed and configured OMEGAMON XE for DB2 PE, you can install IBM InfoSphere Optim Performance Manager.
Step 1: Access your software
To access your software, go to Shopz.
Shopz is IBM's productivity tool for planning and ordering zSeries software.
Step 2: Enable the SQL Dashboard and end-to-end SQL monitoring on the host server
Make sure that OMEGAMON XE for DB2 PE is installed and configured as described in IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS Knowledge Center
After the SMP/E installation and configuration is complete, run the Configuration Tool to enable the SQL Dashboard and end-to-end SQL monitoring support. For more information, see Enabling Performance Expert Client support, SQL Dashboard, end-to-end SQL or stored procedure monitoring support.
Step 3: Evaluate your hardware and system configuration
For more information, see Installation requirements for InfoSphere Optim Performance Manager and components.
Step 4: Review the base architecture
- IBM InfoSphere Optim Performance Manager including IBM DB2 Enterprise Server Edition (ESE) 10.5 and the DB2 ESE 10.5 Restricted Use Activation software
- A restricted-use copy of DB2 for Linux, UNIX, and Windows to be used as data repository by IBM InfoSphere Optim Performance Manager
- The License activation kit for the end-to-end SQL monitoring function for z/OS (required for both the SQL Dashboard and the end-to-end feature)
- The IBM InfoSphere Optim Data Tools Runtime Client for Linux, UNIX, and Windows (required for the end-to-end SQL monitoring only)
- The IBM InfoSphere Optim Data Tools Runtime Client for z/OS (required for the end-to-end SQL monitoring only)
The following diagram illustrates the architecture of the product and provides a basis for planning your installation:
Step 5: Specifying a DB2 instance
Before you can install IBM InfoSphere Optim Performance Manager on your system, DB2 ESE must be installed so it can be used by IBM InfoSphere Optim Performance Manager as repository database.
- If you specify an existing DB2 instance, ensure that it is running before you start the installation of IBM InfoSphere Optim Performance Manager.
- If you install a new DB2 instance:
- Activate the DB2 instance
after the installation of DB2 ESE
10.5 is completed by using the DB2 ESE
10.5 Restricted Use Activation software.
DB2 ESE 10.5 and the DB2 ESE 10.5 Restricted Use Activation software are included in the software package of IBM InfoSphere Optim Performance Manager.
- Open the DB2 ESE 10.5 License Center and install the license.
- Activate the DB2 instance
after the installation of DB2 ESE
10.5 is completed by using the DB2 ESE
10.5 Restricted Use Activation software.
Step 6: Install IBM InfoSphere Optim Performance Manager
Make sure that an instance of a supported edition of DB2 for Linux, UNIX, and Windows is available before you install InfoSphere Optim Performance Manager for your selected operating system. For more information, see Installing InfoSphere Optim Performance Manager by using the installation wizard or the console mode.
The installation process creates a repository database in the DB2 server instance that can be used by InfoSphere Optim Performance Manager.
Step 7: Activate the SQL Dashboard and
the end-to-end SQL monitoring function for z/OS on IBM InfoSphere Optim Performance Manager
Run the License Activation Kit for z/OS for your operating system on the same computer where IBM InfoSphere Optim Performance Manager is installed. After the Activation Kit for z/OS is activated, InfoSphere Optim Performance Manager is restarted.
For more information, see Activating end-to-end SQL monitoring for Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS.
Step 8: Configure your host database to use SQL Dashboard and
end-to-end SQL monitoring
Open the web console and log on to the IBM InfoSphere Optim Performance Manager to add and configure a database for monitoring.
For more information, see Configuring InfoSphere Optim Performance Manager.
Step 9: Install and configure the IBM InfoSphere Optim Data Tools Runtime Client
for Linux, UNIX, and Windows (optional,
required for end-to-end SQL monitoring only)
On the database application computer where the database client drivers are installed, run the installation tool to install the IBM InfoSphere Optim Data Tools Runtime Client for Linux, UNIX, and Windows.
- On Windows: install_directory\IBM_Data_Tools\configuration\cfgtool.bat
- On Linux or UNIX: install_directory\IBM_Data_Tools\configuration\cfgtool.sh
Step 10: Install and configure the IBM InfoSphere Optim Data Tools Runtime Client
for z/OS (optional, required
for end-to-end SQL monitoring only)
Install IBM InfoSphere Optim Data Tools Runtime Client for z/OS by following the instructions in the Program Directory for OMEGAMON XE for DB2 Performance Expert. Go to the IBM Tivoli OMEGAMON XE for DB2 Performance Expert knowledge center.
After you have installed IBM InfoSphere Optim Data Tools Runtime Client for z/OS, you must manually configure JDBC and WebSphere® applications for end-to-end SQL monitoring. For more information, go to Manually configuring JDBC and WebSphere applications for extended insight monitoring.
Step 11: Optional: Integrate IBM InfoSphere Optim Performance Manager into Tivoli monitoring
If you have previously installed and configured Tivoli Enterprise Portal, you can integrate InfoSphere Optim Performance Manager with IBM Tivoli Composite Application Manager (ITCAM) for Application Diagnostics and ITCAM for Transactions in a Tivoli Enterprise Portal (TEP) Console for end-to-end transaction monitoring. When the integration is complete, you can do end-to-end monitoring from your TEP console.
For more information about the Tivoli integration, see Tivoli integration roadmap.
More information
For more information, see the IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and the Integrated Data Management Support.