5. FILES › 5.4 DB2 User Activity (DB2DSU) File › 5.4.1 File Organization

Previous Topic: 5.4 DB2 User Activity (DB2DSU) File

Next Topic: 5.4.2 Data Element List

5.4.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     DB2ACT1   DB2ACT2   DB2ACT3  |
|         |DB2ACT4   YEAR      MONTH     DAY       HOUR     |
|         |                                                 |
|  WEEKS  |SYSID     DB2ID     DB2ACT1   DB2ACT2   DB2ACT3  |
|         |DB2ACT4   YEAR      WEEK      ZONE      HOUR     |
|         |                                                 |
|  MONTHS |SYSID     DB2ID     DB2ACT1   DB2ACT2   DB2ACT3  |
|         |DB2ACT4   YEAR      MONTH     ZONE               |
|         |                                                 |
|  YEARS  |SYSID     DB2ID     DB2ACT1   DB2ACT2   DB2ACT3  |
|         |DB2ACT4   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-3. DB2DSU Time-Span Granularity Chart