6. DATA SOURCES › 6.2 Data Sources Supported

Previous Topic: 6.1 Data Collection Considerations

Next Topic: 6.3 Data Element/Data Source Cross-Reference

6.2 Data Sources Supported


The CA MICS DB2 Analyzer uses data from SMF type 100
(statistics trace) and SMF type 101 (accounting trace)
records.

To obtain the maximum benefit from the DB2 Analyzer, ensure
that your site collects both record types.  Because these
records are optional, coordinate with your site's DB2
administrator to be sure that data will be collected each
day.

SMF Type 100 Statistics Trace Records
-------------------------------------
Statistics trace information reports DB2 system and database
services usage.  The statistics trace information used in the
CA MICS DB2 Analyzer includes the following:

+-----------------------------------------------------------+
| This information...      |is captured in this CA MICS file|
|-----------------------------------------------------------|
| Agent services manager   |  DB2DSY                        |
| Instrumentation facility |  DB2DSY                        |
| Latch manager            |  DB2DSY                        |
| Log manager              |  DB2DSY                        |
| Storage manager          |  DB2DSY                        |
| Subsystem support        |  DB2DSY                        |
| Buffer manager           |  DB2DSD                        |
| Lock manager             |  DB2DSD                        |
| SQL                      |  DB2DSD                        |
| Distributed processing   |  DB2DDY                        |
| Data sharing             |  DB2DSD, DB2DSY                |
+-----------------------------------------------------------+

Statistics trace data is written on a user-controlled
interval basis.

SMF Type 101 Accounting Trace Records
-------------------------------------
Accounting trace records provide application program
information.  The accounting trace information used in the
CA MICS DB2 Analyzer includes the following:

+-----------------------------------------------------------+
| This information...      |is captured in this CA MICS file|
|-----------------------------------------------------------|
| Number of uses of SQL    |  DB2DSU, DB2DSP, DB2DPP        |
|  statements              |                                |
| Number of buffer manager |  DB2DSU, DB2DSP                |
|  requests                |                                |
| CPU times                |  DB2DSU, DB2DSP, DB2DPP,       |
|                          |  DB2DDU, DB2DDP                |
| Wait times               |  DB2DSU, DB2DSP, DB2DPP        |
| Distributed processing   |  DB2DDU, DB2DDP, DB2DPP        |
| Data sharing             |  DB2DSP, DB2DSU                |
| Client-server accounting |  DB2DSU                        |
+-----------------------------------------------------------+

Accounting trace data is collected from the successful
allocation of a thread to the termination of that thread or
when the authorization ID changes.