Getting an overview of your Db2 system performance

The Statistics trace report provides an overview of important areas, like DBM1 storage usage, data set activities, logging and locking activities, and thread management.

To get an overview of your Db2 system, you have to look at the following areas:
  • DBM1 storage DBM1 storage is allocated below and above the 2 GB bar and is used for buffer pools, EDM pools, RID pools, and authorization caches. It is essential that the various pools and caches are optimized in their allocated space.
  • Data set Open and Close activity Applications that leave data sets open can affect other applications that must wait because too many data sets are already open.
  • Logging

    Logging activities interrupt normal Db2 operations. Logging problems will therefore affect applications and performance.

  • Locking

    Locks occur in Db2 when applications have to wait for resources (concurrency problems).

  • ROWID

    The ROWID block of the report shows the success of direct row access attempts.

  • Thread management

    Thread optimization avoids applications from having to wait for free storage to allow thread creation.