OMEGAMON XE for DB2 PE has
three main functions: analyzing a current problem, collecting historical
data, and tuning buffer pools.
This product offers several components to help you achieve these
goals. The sections below introduce you to the main components used
for each goal. For a description of each OMEGAMON XE for DB2 PE component and
for an overview of the relationships between the components, see Components of OMEGAMON XE for DB2 PE.
Analyzing a current problem
You can use
OMEGAMON XE for DB2 PE to analyze current
application and system problems. For example, an employee has complained
that the system is running slow this morning. You can use one of the
following components to analyze and identify bottlenecks and other
performance problems:
- Classic Interface
- A VTAM® interface for OMEGAMON XE for DB2 PE with conventional
menus and panels. Like Performance Expert Client, Classic Interface shows you all of the
information necessary to analyze a problem, but instead uses a fast
and reliable VTAM interface.
Using VTAM allows you to monitor
and solve a DB2 problem even
if the whole LPAR is impacted and a logon to TSO is no longer possible.
- OMEGAMON enhanced 3270 user interface
- An enhanced 3270 user interface for OMEGAMON XE for DB2 PE with predefined
workspaces that enable you to quickly and easily diagnose problems
with monitored resources and take action to correct them. You can
customize the workspaces to suit your requirements, even design and
create your own workspaces and navigation.
- Tivoli Enterprise Portal
- A Java-based interface for OMEGAMON XE for DB2 PE that is flexible
and customizable. You can install Tivoli Enterprise Portal on the local machine
or you can access it through a web browser. Tivoli Enterprise Portal provides information
similar to that provided by Performance Expert Client and Classic Interface. When installed in
conjunction with the appropriate OMEGAMON products, Tivoli Enterprise Portal can also monitor other
products and display the information in the same user interface.
- Performance Expert Client
- A graphical user interface for OMEGAMON XE for DB2 PE that runs on
the Windows operating system. Performance Expert Client provides all of the
functions that are necessary to analyze the system or to analyze a
specific application. It shows you all the details about the activity
on the DB2 subsystem, plus information
about resource utilization and processing times. It also automatically
informs you about problems or resource constraints such as deadlock,
timeout, or CF structure resize.
Collecting and evaluating historical data
You
can also use
OMEGAMON XE for DB2 PE to
collect and evaluate historical data for different tasks. Historical
data is useful for tuning, for problem analysis, for trend analysis,
and for capacity planning. For example, you can use historical data
to predict resource usage for trend analysis and capacity planning.
Historical data also allows you to analyze a problem over a long period
of time. This is helpful when current data is not sufficient to analyze
the problem, for example when you want to check the size of a DB2 resource, such as an EDM pool,
for cursor tables or package tables. You can also use historical data
to establish a baseline performance record that can be used to detect
deviations. For example, you could collect Accounting data for several
months and then compare the current CPU usage time of a static SQL
package to the average CPU usage time stored in the history. If the
current time is well above the average time, then you know that you
need to investigate the change. You can use the following components
to store and evaluate historical data:
- Performance Database
- A set of tables that can be filled with DB2 performance information collected via SMF
or via a batch job using the FPEZCRD program. You can then retrieve,
aggregate, or filter the information using SQL. To load the collected DB2 information into the performance
database, functions of the reporter component (batch engine) have
to be used.
- Performance Warehouse
- An automated version of Performance Database.
The database is maintained and controlled by the OMEGAMON Collector and you can use a GUI
to define the ETL process and to evaluate the information in the tables.
- Reporter
- Generates reports that reflect the activity on different levels,
for example, subsystem, application, SQL statements, locking, and
utility. The Reporter does not store the information in a database.
This component helps you identify related problems and charges back
the DB2 usage to your users.
You can use a command language to filter, sort, and aggregate the
reported information.
Tuning buffer pools
OMEGAMON XE for DB2 PE can also be used
to tune buffer pools. If you want to find the optimal use of buffer
pool resources and to simulate the effects of possible changes, you
can use the following component:
- Buffer Pool Analyzer
- A suite of tools that can be used to monitor, analyze, and tune
buffer pools.