Missing data sections

Conditions that might cause missing data for Accounting reports.

The following DB2 threads might result in missing data sections because required data could not be gathered:
  • If attaching to QMF that generates a unique DB2 thread.

    Under this thread no SQL, buffer, or locking information is gathered.

  • If running a dynamic SQL that generates a unique DB2 thread.

    Under this thread, SQL, buffer, and locking activity can be performed. A data section is produced if activity in the data section occurs. Resource limit activity is only reported in the Accounting record for dynamic SQL activity.

  • If ending a QMF session that creates a unique DB2 thread.

    Under this thread no SQL, buffer, or locking information is gathered.

  • If running a batch job that creates a unique DB2 thread.

    Under this thread SQL, buffer, and locking activity can be performed. No resource limit activity is tracked for this thread.

  • If location A uses DRDA protocol to access data at location B and does not do any local work, no SQL information is gathered for the corresponding allied-distributed thread at location A.