5. FILES › 5.8 DB2 System DDF Statistics (DB2DDY) File › 5.8.1 File Organization

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

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