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

Previous Topic: 5.2.3 Usage Considerations

Next Topic: 5.3.1 File Organization

5.3 DB2 Data Base Activity (DB2DSD) File


FILENAME=DB2DSDxx

The DB2 Data Base Activity file maintains DB2 database
Activity data, i.e.  SQL Statements, Binds, Buffer Manager,
and Lock Usage data.  This file is derived from the SMF DB2
record type 100 subtype 1.  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 Elements List
   3 - Usage Considerations