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

Previous Topic: 5.3.3 Usage Considerations

Next Topic: 5.4.1 File Organization

5.4 DB2 User Activity (DB2DSU) File


FILENAME=DB2DSUxx

The DB2 User Activity file maintains DB2 accounting data,
including product, user, instrumentation, SQL statements,
buffer manager, and lock usage data by user.  This file is
derived from the SMF DB2 record type 101 and by default,
exists in the DAYS, WEEKS, MONTHS, and YEARS timespans.  If
your site is planning to charge users for DB2 activity, the
DB2DSU file is useful for computing charges.

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