3. REPORTS › 3.1 Tabular Reports Overview › 3.1.4 DB2 Accounting Report › 3.1.4.1 DB2 Accounting Report Format
3.1.4.1 DB2 Accounting Report Format
The DB2 Accounting Report contains the following sections:
o Identification
o CPU Time Summary
o Thread Status
o SQL Calls
o Locking
o Miscellaneous
o Buffer Manager
o DDF Accounting
Identification Section
RUN DATE Date the report was created.
REPORTING PERIOD Earliest and latest dates and
times found within the data.
SYSID Logical system identifier.
DB2 SYSTEM DB2 subsystem identifier.
(DB2ID)
RELEASE DB2 subsystem release level.
(DB2RELN)
USER DB2 users included in this
report (possibly a group user
ID). (DB2AUTH)
ORIGINAL USER DB2 user ID of the original user
associated with a group user ID.
(DB2OPID)
PLAN DB2 plans included in this
report. (DB2PLAN)
FACILITY Facility identifier of requesting
environment (IMS, CICS, BATCH,
and so on) (DB2CONN)
THREADS The number of threads initiated,
or, when query CP parallelism is
in use, the number of parent
tasks used to build this entry.
(DSUNTHRD)
CPU Time Section
CLASS 1 TCB TIME Total TCB time for the users/
plans/facilities included in this
report. This time may include
non-DB2 application TCB time for
facilities other than CICS.
(DSUTCBTM)
CLASS 1 zIIP TIME Total CPU time executing on a
z/OS Specialty Engine processor
for the users/plans/facilities
included in this report.
(DSUCPUZ1)
CLASS 1 ELAPSED TIME Total elapsed time for the users/
plans/facilities included in this
report. (DSUELPTM)
CLASS 2 TCB TIME Total IN-DB2 TCB time. This is
the TCB time charged back to the
user for work done in DB2.
(DSUTC2TM)
CLASS 2 zIIP TIME Total IN-DB2 CPU time executing
on a z/OS Specialty Engine
processor. (DSUCPUZ2)
CLASS 2 ELAPSED TIME Total IN-DB2 elapsed time. This
is the elapsed time spent waiting
for DB2 to service this request.
(DSUET2TM)
zIIP ELIGIBLE TIME Total CPU time that executed on a
standard CP for zIIP-eligible
work. (DSUELGZP)
TOTAL I/O TIME Total time the IMS, CICS, or TSO
user's address space waited for
I/O in DB2. (DSUIOETM)
TOTAL LOCK AND LATCH Total time the IMS, CICS, or TSO
TIME user's address space waited for
locks and latches in DB2.
(DSUALLTM)
OTHER READ TIME Total time for read I/O done
under another thread. (DSUAWRTM)
OTHER WRITE TIME Total time for write I/O done
under another thread. (DSUAWWTM)
SERVICE TASK TIME Total wait time due to
synchronous execution unit switch
to DB2 services from a thread.
(DSUAWETM)
ARCHIVE LOG TIME Total wait time due to processing
ARCHIVE LOG MODE(QUIESCE)
commands. (DSUALGTM)
NO. ENTRY/EXIT EVENTS Number of entry and exit events
processed to calculate the
elapsed times in DB2. (DSUENTEX)
NO. WAIT TRACE EVENTS Number of entry and exit events
processed to calculate the I/O,
lock, and latch elapsed wait
times. (DSUWATTR)
Thread Status Section
NORMAL End of task, application program
END OF TASK terminated.
NORMAL End of task, application program
APPLICATION ENDED termination.
NORMAL Deallocation, normal program
DEALLOCATION termination.
NORMAL New user, authorization ID
NEW USER changed.
ABNORMAL End of task, application program
APPLICATION ABENDED ABEND.
ABNORMAL End of memory, abnormal
END OF MEMORY termination.
ABNORMAL Resolve indoubt.
RESOLVE INDOUBT
ABNORMAL STOP DB2 MODE (FORCE) command
FORCE COMMAND issued.
WORK UNIT IN DOUBT End of task, application program
APPLICATION ABENDED ABEND.
WORK UNIT IN DOUBT End of memory, abnormal
END OF MEMORY termination.
WORK UNIT IN DOUBT Resolve indoubt.
RESOLVE INDOUBT
WORK UNIT IN DOUBT STOP DB2 MODE (FORCE) command
FORCE COMMAND issued.
SQL Calls Section
SELECT Number of SELECT statements.
INSERT Number of INSERT statements.
UPDATE Number of UPDATE statements.
DELETE Number of DELETE statements.
DESCRIBE Number of DESCRIBE statements.
PREPARE: Number of PREPARE statements.
OPEN: Number of OPEN statements.
CLOSE Number of CLOSE statements.
LOCK TABLE Number of LOCK TABLE statements.
GRANT Number of GRANT statements.
REVOKE Number of REVOKE statements.
INCREMENTAL BIND Number of incremental binds
excluding prepares.
COMMENT Number of COMMENT ON statements.
SET SQLID Number of SET CURRENT SQLID
statements.
SET HOST VARIABLE Number of SET HOST VARIABLE
statements.
CREATE TABLE Number of CREATE TABLE
statements.
CREATE INDEX: Number of CREATE INDEX
statements.
CREATE TABLESPACE Number of CREATE TABLESPACE
statements.
CREATE STOGROUP Number of CREATE STOGROUP
statements.
CREATE DATABASE Number of CREATE DATABASE
statements.
CREATE SYNONYM Number of CREATE SYNONYM
statements.
CREATE VIEW Number of CREATE VIEW statements.
DROP TABLE Number of DROP TABLE statements.
DROP INDEX Number of DROP INDEX statements.
DROP TABLESPACE: Number of DROP TABLESPACE
statements.
DROP STOGROUP Number of DROP STOGROUP
statements.
DROP DATABASE Number of DROP DATABASE
statements.
DROP SYNONYM Number of DROP SYNONYM
statements.
DROP VIEW Number of DROP VIEW statements.
DROP PACKAGE Number of DROP PACKAGE
statements.
ALTER TABLE Number of ALTER TABLE statements.
ALTER INDEX Number of ALTER INDEX statements.
ALTER TABLESPACE Number of ALTER TABLESPACE
statements.
ALTER STOREGROUP Number of ALTER STOREGROUP
statements.
ALTER DATABASE Number of ALTER DATABASE
statements.
FETCH Number of FETCH statements.
LABEL Number of LABEL statements.
DESCRIBE TABLE Number of DESCRIBE TABLE
statements.
Locking Section
DEADLOCKS Deadlock count.
SUSPENSIONS Suspension count.
TIMEOUTS Timeout count.
ESCALATED TO SHARED Number of lock escalations to
shared mode.
ESCALATED TO EXCLUSIVE Number of lock escalations to
exclusive mode.
MAX. PAGE LOCKS HELD Maximum number of page locks held
by a DB2 user.
RESOURCE TABLE ID Nature of resource limit in
effect.
HOW LIMIT WAS DETERMINED Method resource limit was
determined.
SERVICE UNIT TIME LIMIT Number of CPU services units
allowed per dynamic SQL requests.
CPU TIME LIMIT CPU time limit allowed per
dynamic SQL requests.
HIGHEST CPU TIME USED Highest CPU time used for a
dynamic SQL statement.
LATCH SUSPEND COUNT Number of suspends due to latch
conflict.
OTHER SUSPEND COUNT Number of suspends due to
something other than latch
conflict.
LOCK REQUEST COUNT Total number of IRLM lock
requests.
QUERY REQUEST COUNT Total number of IRLM query
requests.
CHANGE REQUEST COUNT Total number of IRLM change
requests.
OTHER IRLM REQUEST COUNT Total number of other IRLM
requests.
Miscellaneous Section
COMMIT PHASE TWO Number of commit phase two
invocations.
ABORT REQUESTS Number of abort requests.
Buffer Manager Section
GETPAGE REQUESTS Number of GETPAGE requests.
RECORD IN SYSTEM Number of records residing in a
PAGE UPDATED system page that were updated.
SYNCHRONOUS READ I/O Number of synchronous read I/Os.
SYNCHRONOUS WRITE I/O Number of synchronous write I/Os.
SEQUENTIAL PREFETCH Number of sequential prefetch
REQUESTS read requests by user
application.
LIST PREFETCH REQUESTS Number of list prefetch read
requests by user application
DYNAMIC PREFETCH: Total number of Dynamic Prefetch
REQUESTS Requests for all active DB2
buffer pools. Dynamic prefetch
is the process that is triggered
because of sequential detection.
(DSUDPFn)
UNSUCCESSFUL GETPAGE Total number of times conditional
OPERATIONS getpage requests could not be
satisfied for all active DB2
buffer pools. (DSUSNGT)
ASYNC PAGES READ BY Total number of synchronous read
PREFETCH I/Os issued by sequential access
requesters, summarized across all
active DB2 buffer pools.
(DSUSSIO)
DDF Accounting Section
LOCATION Location Identifier for a Remote
DB2 Subsystem. (DB2RLOCN)
DDF THREADS Count of SMF 101 DDF accounting
segments included in this entry.
The second and third lines of
this column indicate average and
maximum reporting for each
location. (DDUNTHRD)
LOCAL ELAPSED Total time spent waiting at the
local DB2 for remote DB2
processing of a distributed
request. (DDUELPL)
REMOTE ELAPSED Total time spent processing
distributed request as measured
from the remote serving DB2
subsystem.(DDUELPR)
REMOTE CPU Total CPU time (SRB at remote
site spent processing SQL
requests. (DDUCPUR)
CONVERS. (SENT/RECEIVED) VTAM Conversations Sent or
Received. Sent (DDUCNVS)
Received (DDUCNVR)
CONVERS. QUEUED VTAM Conversations Queued
(DDUCNVQ) to be sent to remote
site.
ABORTS (SENT/RECEIVED) Abort Messages Sent or Received.
Sent (DDUABRS) Received (DDUABRR)
COMMITS (SENT/RECEIVED) COMMIT Messages Sent or Received.
Sent (DDUCOMS) Received (DDUCOMR)
SQL SENT/RECEIVED SQL Statements Sent or Received.
Sent (DDUSQLS) Received (DDUSQLR)
DATA ROWS SENT Data rows sent to the remote
site. (DDUROWS)
DATA ROWS FROM Data rows received from the
remote site. (DDUROWR)
MESSAGES SENT TO VTAM Messages sent to the remote
site. (DDUMSGS)
MESSAGES RECEIVED FROM VTAM Messages received from the
remote site. (DDUMSGR)
BYTES/1000 SENT Number of bytes sent to the
remote site (DDUROWS) divided by
1000. If the total byte count is
less than 10000, the division
by 1000 is not performed and the
report variable is flagged.
BYTES/1000 RECEIVED Number of bytes received from
remote (DDUROWR) divided by 1000.
If the total byte count is less
than 10000, the division by
1000 is not performed and the
report variable is flagged.
