5. FILES › 5.5 DB2 Plan Activity (DB2DSP) File › 5.5.1 File Organization

Previous Topic: 5.5 DB2 Plan Activity (DB2DSP) File

Next Topic: 5.5.2 Data Element List

5.5.1 File Organization


The table below identifies data elements by which the file is
sequenced and summarized in each Time-span.  "N/A" indicates
that the file is not supported in a Time-span.

NOTE:   The Time-spans in which a file is supported are
defined by each installation when CA MICS is installed.
Therefore, this table has been generated as part of the
installation process to accurately reflect the CA MICS system
at your installation.

+---------+-------------------------------------------------+
|Timespan | Level of Data Granularity                       |
+---------+-------------------------------------------------+
|         |                                                 |
|  DETAIL |  N/A                                            |
|         |                                                 |
|  DAYS   |SYSID     DB2ID     DB2PLAN   DB2CONN   YEAR     |
|         |MONTH     DAY       HOUR                         |
|         |                                                 |
|  WEEKS  |SYSID     DB2ID     DB2PLAN   DB2CONN   YEAR     |
|         |WEEK      HOUR      ZONE                         |
|         |                                                 |
|  MONTHS |SYSID     DB2ID     DB2PLAN   DB2CONN   YEAR     |
|         |MONTH     ZONE                                   |
|         |                                                 |
|  YEARS  |SYSID     DB2ID     DB2PLAN   DB2CONN   YEAR     |
|         |ZONE                                             |
|         |                                                 |
+---------+-------------------------------------------------+
|  TABLES |  N/A                                            |
+---------+-------------------------------------------------+
                        Generation Date:  Tue, May 12, 2009


NOTE:  This file was generated with ESSENTIAL=ALL
       option in effect.  All data elements defined in
       the file are generated.
NOTE:  This file was generated with DERIVED=DEFault
       option in effect.  Whether data elements are
       kept on the file on auxiliary storage or not
       is controlled by the complex definition of the
       DERIVED option.



 Figure 5-4.  DB2DSP Time-Span Granularity Chart