6. DATA SOURCES › 6.1 Data Collection Considerations

6.1 Data Collection Considerations

Before installing the CA MICS Analyzer Option for DB2, you
must address the following data collection considerations:

Space Considerations
--------------------

o  The DB2 Analyzer collects information about buffer pool
   usage and summarizes it across all active buffer pools to
   minimize space considerations.

o  IBM classifies some fields as serviceability fields,
   meaning that they are used by IBM to solve problems.
   Because IBM reserves the right to define fields as
   serviceability fields, the analyzer provides a cluster
   code for elements that are in the database but are now
   derived from fields classified as serviceability fields.

   To deactivate these elements in your CA MICS database,
   use the OPTION statement keyword and cluster code
   documented in Chapter 7 of this guide.


Accounting Data Collection
--------------------------

o  The DB2 Analyzer contains information from SMF type 101
   Accounting records (IFCID 0003 and IFCID 239).  Those
   records are further broken into types of traces,
   including:

   +--------------------------------------------------------+
   | Trace | Type of                                        |
   | Class | Data Collected                                 |
   |-------|------------------------------------------------|
   |   1   | Accounting data                                |
   |   2   | "In DB2" time                                  |
   |   3   | Wait times for I/O, locks, latches, drains, and|
   |       | claims                                         |
   |   4   | User-defined accounting                        |
   |   5   | Time spent processing IFI requests             |
   |   7   | Package-level accounting "in DB2" time         |
   |   8   | Package-level accounting wait time "in DB2"    |
   |  10   | Package-level accounting "in DB2" detail data  |
   +--------------------------------------------------------+

   The DB2 Analyzer records data from classes 1, 2, 3, 5, 7,
   and 8.  It does not process data from class 10.