5. FILES › 5.3 DB2 Data Base Activity (DB2DSD) File › 5.3.1 File Organization

Previous Topic: 5.3 DB2 Data Base Activity (DB2DSD) File

Next Topic: 5.3.2 Data Element List

5.3.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.  At the DETAIL
level, data is sequenced but not summarized.

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 reflect the CA MICS system at your
installation.

+---------+-------------------------------------------------+
|Timespan | Level of Data Granularity                       |
+---------+-------------------------------------------------+
|         |                                                 |
|  DETAIL |SYSID     DB2ID     YEAR      MONTH     DAY      |
|         |HOUR      ENDTS                                  |
|         |                                                 |
|  DAYS   |SYSID     DB2ID     YEAR      MONTH     DAY      |
|         |HOUR                                             |
|         |                                                 |
|  WEEKS  |SYSID     DB2ID     YEAR      WEEK      ZONE     |
|         |HOUR                                             |
|         |                                                 |
|  MONTHS |SYSID     DB2ID     YEAR      MONTH     ZONE     |
|         |                                                 |
|  YEARS  |SYSID     DB2ID     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-2. DB2DSD Time-Span Granularity Chart