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

Previous Topic: 5.7 DB2 Data Base Activity Suspend (DB2_DD) File

Next Topic: 5.8.1 File Organization

5.8 DB2 System DDF Statistics (DB2DDY) File


FILENAME=DB2DDYxx

The DB2 System DDF Statistics file maintains DB2 system DDF
activity data including location, transactions, commits,
bytes sent and SQL statements sent.  This file is derived
from the SMF DB2 record type 100 subtype 0.  This file exists
in the DETAIL, DAYS, WEEKS, MONTHS, and YEARS timespans.

The following three sections describe the file's
organization, list the data elements maintained, and provide
usage hints:

   1 - File Organization
   2 - Data Element List
   3 - Usage Considerations