|
|
|
As the number of I/S sites using IBM's DB2 relational database management system continues to grow, the need to systematically plan, control, and evaluate the DB2 environment is becoming increasingly important. With this in mind, IBM developed a DB2 interface with SMF (System Management Facility) to produce SMF records that contain, in varying degrees of detail, performance and utilization information for the DB2 environment. The CA MICS Analyzer Option for DB2 processes DB2 SMF data, including information about o system o subsystem o database o user activity o plans, packages, and database request modules o data sharing The DB2 Analyzer enables you to display information on selected users, user groupings, databases, and other criteria or categories of activity. It also tracks system problems and can perform an in-depth audit of users of various DB2 facilities. In addition, the DB2 Analyzer produces a series of management and operational reports that can be tailored for all management levels. It also offers online data access through the CA MICS Information Center Facility (MICF), a full-screen, menu-based processor that enables you to analyze data, create and execute inquiries, retrieve data, and run reports. The DB2 Analyzer supports standard CA MICS processing of DB2 SMF system and accounting data. Like the other data integration applications, it processes raw data for analyzing and managing specific technologies. Because CA MICS stores data in a format that is common to all CA MICS products, you can use standard CA MICS facilities to integrate DB2 Analyzer data with any other data that CA MICS maintains. Figure 1-1 illustrates the DB2 Analyzer data flow.
CA MICS Data CA MICS CA MICS
Data Integration Database Management
Source Product Information Support Output
Areas Applications
+-----------+
| Acctg and |
+---------------+ |Chargeback |
| |--->+-----------+
| | +-----------+ +-----------+
+-------------+ | |--->| Capacity |--->| Inquiries |
+------+ | | | | | Planner | | |
| SMF | | DB2 | | +-----------+ | +-----------+ +-----------+
| |--->| Analyzer |-->| | DB2 | | +-----------+
| | | | | +-----------+ |--->|Performance|
+------+ | | | | | Manager |
+-------------+ | | +-----------+
| |
+---------------+
Figure 1-1. CA MICS Analyzer Option for DB2 Data Flow The DB2 Analyzer integrates the DB2 activity and utilization data collected in SMF records into the CA MICS database. This process creates the DB2 information area, which interfaces with a number of other CA MICS products including: o CA MICS Accounting and Chargeback - The data provided to CA MICS Accounting and Chargeback supports accounting for consumed resources (for example, CPU time), logical I/Os (for example, the number of Insert, Update, and Delete statements), or almost any other measure of resource utilization. o CA MICS Capacity Planner - The CA MICS Analyzer Option for DB2 maintains a database of detail and summarized DB2 usage and performance data that the Capacity Planner can use to make historical growth/trend projections. These projections can be made at all information levels, including the system level, a specific application plan grouping level, or the organizational structure level. o CA MICS Performance Manager - The CA MICS Performance Manager uses data provided by the DB2 Analyzer as part of the system tuning effort. In addition, you can use the workload characterization tools and methodology provided in the CA MICS Performance Manager to perform DB2 workload analyses. Because CA MICS database files are summarized in the same manner across all products, DB2 information can be easily combined with information from other data sources. Combining data from multiple data sources allows you to compare and correlate DB2 information with system and other application- specific information such as data from TSO, CICS, IMS, and Batch.
This section contains the following topics:
1.1 Primary Areas of Application
1.2 Reporting and Inquiry Facilities
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |