|
|
|
The DB2 Analyzer builds the DB2 information area from DB2 SMF type 100 and 101 records. Once created, the DB2 information area maintains system and user measurement data on service, availability, load, and user activity within the DB2 environment. The following files are contained in the DB2 information area of the CA MICS Data Base: o DB2 System Activity File (DB2DSY) The DB2 System Activity File maintains DB2 system activity data, which includes information about address space, instrumentation, subsystem services, commands, latch manager, agent services, storage manager, trace data, and log manager data. It is derived from the SMF record type 100 subtype 0. o DB2 System DDF Activity File (DB2DDY) The DB2 System DDF Activity File maintains DB2 system distributed database (DDF) activity data for each DB2 subsystem participating in distributed processing. This file contains DB2 network information such as bytes, rows, and SQL statements transmitted as well as the number of network conversations initiated. It is derived from the SMF record type 100 subtype 0 when DDF is active. o DB2 Database Activity File (DB2DSD) The DB2 Database Activity File maintains DB2 database activity data--SQL statements, buffer manager, binds, and lock usage data. It is derived from the SMF record type 100 subtype 1. o DB2 Buffer Pool Activity File (DB2DSD) The DB2 Buffer Pool Activity File maintains DB2 activity data for the buffer manager. It is derived from the SMF record type 100 subtype 1. o DB2 User Activity File (DB2DSU) The DB2 User Activity File maintains DB2 accounting data--product, user, buffer manager instrumentation, SQL statements, and lock usage data by user. It is derived from the SMF record type 101. o DB2 User DDF Activity File (DB2DDU) The DB2 User DDF Activity File maintains DB2 accounting data for distributed database activity (DDF) for each DB2 user. This file contains DB2 network information such as bytes, rows, and SQL statements transmitted and the number of network conversations initiated for each user. It is derived from the SMF record type 101 when DDF is active. o DB2 Plan Activity File (DB2DSP) The DB2 Plan Activity File maintains the same accounting data as the DB2DSU file but organizes it by DB2 plan (application). It is derived from rename operations performed against the DB2DSU WORK file. o DB2 Package/DBRM Activity File (DB2DPP) The DB2 Package/DBRM Activity File provides resource consumption and activity information for packages and data base request modules. It is derived from the SMF type 101 record. o DB2 Plan DDF Activity File (DB2DDP) The DB2 Plan DDF Activity File maintains the same accounting data as the DB2DDU file but organizes it by DB2 plan (application). It is derived from rename operations performed against the DB2DDU WORK file. o DB2 User Buffer Pool Activity File (DBPDBU) The DB2 User Buffer Pool Activity File maintains DB2 buffer manager instrumentation usage data by user. It is derived from the SMF record type 101. o DB2 Plan Buffer Pool Activity File (DBPDBP) The DB2 Plan Buffer Pool Activity File maintains the same accounting data as the DBPDBU file but organizes it by DB2 plan (application). It is derived from rename operations performed against the DBPDBU WORK file. o DB2 System Activity Suspend File (DB2_DS) The DB2 System Activity Suspend File maintains the last raw interval systems services record processed by CA MICS. This record is needed for the calculation of interval statistics in cases where DB2 executes continuously across more than one CA MICS daily update cycle. o DB2 System DDF Activity Suspend File (DB2_SH) The DB2 System DDF Activity Suspend File maintains the distributed data portion of the last raw interval systems services record processed by CA MICS. This record is needed for the calculation of interval statistics in cases where DB2 executes continuously across more than one CA MICS daily update cycle. o DB2 Database Activity Suspend File (DB2_DD) The DB2 Database Activity Suspend File maintains the last raw interval data base services record processed by CA MICS. This record is needed for the calculation of interval statistics in cases where DB2 executes continuously across more than one CA MICS daily update cycle. o DB2 Buffer Pool Activity Suspend File (DB2_DB) The DB2 Buffer Pool Activity Suspend File maintains the last raw interval buffer pool services record processed by CA MICS. This record is needed for the calculation of interval statistics in cases where DB2 executes continuously across more than one CA MICS daily update cycle. Figure 1-2 illustrates the DB2 information area data sources and files.
+-------------------+ +--------------------+ +------------------+ | DB2 System | | DB2 Data Base | | DB2 User | INPUT | Records | | Records | | Records | DATA | (SMF type 100 | | (SMF type 100 | | (SMF type 101) | SOURCES | subtype 0) | | subtype 1) | | | +-------------------+ +--------------------+ +------------------+ | | | +---------------------------+------------------------------+ | PRODUCT +-----------------------+ PROCESSING | CA MICS DB2 Analyzer | | Database | | Update Process | +-----------------------+ | +-----------------------------------------------------------------------------------------------+ | | | | | | | | | | | | | | +---------------+ +---------------+ +---------------+ | +---------------+ +---------------+ +---------------+ | DB2 System | | DB2 Database | | DB2 User | | | DB2 Plan | | DB2 System | | DB2 Database | PRODUCT | Activity | | Activity | | Activity | | | Activity | | Activity | | Activity | FILES | File | | File | | File | | | File | | Suspend File | | Suspend File | | (DB2DSY) | | (DB2DSD) | | (DB2DSU) | | | (DB2DSP) | | (DB2_DS) | | (DB2_DD) | +---------------+ +---------------+ +---------------+ | +---------------+ +---------------+ +---------------+ | | | | | | | | | | +---------------+ +---------------+ | +---------------+ +---------------+ PRODUCT | DDF System | | DDF User | | | DDF Plan | | DDF System | FILES | Activity | | Activity | | | Activity | | Activity | (DDF) | File | | File | | | File | | Suspend File | | (DB2DDY) | | (DB2DDU) | | | (DB2DDP) | | (DB2_SH) | +---------------+ +---------------+ | +---------------+ +---------------+ | | +---------------+ +---------------+ +---------------+ | DB2 Buffer | | DB2 Buffer | | DB2 Buffer | | Pool Plan |--| Pool |--| Pool User | | Activity File | | Activity File | | Activity File | | (DBPDBP) | | (DBPDSB) | | (DBPDBU) | +---------------+ +---------------+ +---------------+
Figure 1-2. DB2 Information Area Structure
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |