3. REPORTS › 3.1 Tabular Reports Overview › 3.1.2 DB2 System Services Report › 3.1.2.1 DB2 System Services Report Format
3.1.2.1 DB2 System Services Report Format
The DB2 System Services Report contains the following
sections:
o Identification
o CPU Time
o Thread Summary
o IFC Checkpoint Data
o Subsystem Services
o Agent Services (only when OPTION SERV is specified in
sharedprefix.MICS.GENLIB(DB2GENIN))
o Storage Manager (only when OPTION SERV is specified in
sharedprefix.MICS.GENLIB(DB2GENIN))
o Log Manager
o Command Data
o IFC Destination Data
o Latch Manager (only when OPTION SERV is specified in
sharedprefix.MICS.GENLIB(DB2GENIN))
o IFI Counters
o DDF Services Statistics
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.
DB2 RELEASE DB2 subsystem release identifier.
(DB2RELN)
CPU Time Section
SYSTEM SERVICES Accumulated TCB time for the
TCB system address space. (DSYTCTM0)
SYSTEM SERVICES Accumulated SRB time for the
SRB system address space. (DSYSRTM0)
DATABASE SERVICES Accumulated TCB time for the
TCB database address space. (DSYTCTM1)
DATABASE SERVICES Accumulated SRB time for the
SRB database address space. (DSYSRTM1)
IMS RESOURCE LOCK Accumulated TCB time for the IMS
MANAGER TCB Resource Lock Manager address
space. (DSYTCTM2)
IMS RESOURCE LOCK Accumulated SRB time for the IMS
MANAGER SRB Resource Lock Manager address
space. (DSYSRTM2)
DDF SERVICES Accumulated TCB time for the DB2
TCB DDF address space. (DSYTCTM3)
DDF SERVICES Accumulated SRB time for the DB2
SRB DDF address space. (DSYSRTM3)
Thread Summary Section
THREADS Number of threads created.
IFC Checkpoint Data Section
CHECKPOINT Number of checkpoints taken.
Subsystem Services Section
CONNECT Successful connects to DB2 by
TSO, IMS, CICS, or DB2 utility.
CREATE THREAD Number of threads created.
SIGNON Number of times the user
authorization was updated.
TERMINATE Number of times a thread, signon,
or identify was terminated.
Because a signon can be performed
without a terminate, this does
not give an exact count of how
many threads were terminated.
COMMIT Number of successful requests for
commit phase 2.
ABORT Number of times that a unit of
recovery was backed out.
Possible reasons are an
application program ABEND,
application program roll back
request, application program
deadlocked on database records,
thread ABEND caused by resource
shortage, or application program
canceled by operator.
INDOUBT THREADS Number of application failures
that occurred after a successful
prepare but before a successful
commit. The failure can occur in
the address space of the
application, the transaction
manager, or DB2.
PREPARE TO COMMIT Number of successful requests for
commit phase 1.
SSI CALLS Number of SSI calls. These
include EOT, EOM, subsystem
identify, commands from the
system console, and HELP
requests.
RESOLVE Number of requests to process
indoubt work that was successful.
SYNCHRONIZE Number of synchronized commit
requests. TSO applications use
this facility.
THREADS WAITED Number of create-thread requests
that waited.
EXIT Number of successful DSN3EXIT
functions performed. This
facility is used to establish or
remove an exit.
END OF TASK Number of non-DB2 tasks that
abended while connected to DB2.
END OF MEMORY Number of non-DB2 address spaces
deleted by the operating system
while connected to DB2.
Agent Services Section (only shown if OPTION SERV is
specified in sharedprefix.MICS.GENLIB(DB2GENIN))
UNAVAILABLE RESOURCE Number of plans that have become
unavailable. For example, the
plan has become invalidated and
an unsuccessful automatic bind
has occurred.
DEADLOCK Number of allocation deadlocks.
These occur when resources are
limited and contention is high.
INVALID RESOURCE Number of requests for a plan
that was unknown to DB2.
PHYSICAL SUSPENDS Number of suspends (waits) that
occur due to latch contention,
lock contention, I/O, and
execution unit switching.
Storage Manager Section (only shown if OPTION SERV is
specified in sharedprefix.MICS.GENLIB(DB2GENIN))
DETECTED Number of short-on-storage
situations detected.
CONTRACTION Number of storage contractions
due to a shortage of storage.
ABEND Number of ABENDs issued due to a
shortage of storage.
GETMAIN/FREEMAIN Number of non-zero returns from
ERRORS GETMAIN and FREEMAIN.
Log Manager Section
WRITE ACTIVE Number of calls to write active
log buffers.
WAIT Number of log write requests,
WAIT.
NO WAIT Number of log write requests,
NOWAIT.
FORCE Number of log write requests,
FORCE.
BUFFER WAITS Number of waits because of an
unavailable write buffer.
CREATED Number of active log-output
control intervals created.
OFFLOADED Number of control intervals
offloaded.
OUTPUT BUFFER Number of reads satisfied from
output buffers.
ACTIVE LOG Number of reads satisfied from
active log data set.
ARCHIVE LOG Number of reads satisfied from
archive log data set.
READ Number of archive log-read
allocations.
WRITE Number of archive log-write
allocations.
READS DELAY Number of reads delayed because
archive allocation limit reached.
Command Data Section
DISPLAY DATABASE Number of DISPLAY DATABASE
commands.
DISPLAY THREAD Number of DISPLAY THREAD
commands.
DISPLAY UTILITY Number of DISPLAY UTILITY
commands.
DISPLAY RLIMIT Number of DISPLAY RLIMIT
commands.
DISPLAY LOCATION Number of DISPLAY LOCATION
commands.
Note: This will appear on the
report only if DDF data is
present.
START DB2 Number of START DB2 commands.
START DATABASE Number of START DATABASE
commands.
START TRACE Number of START TRACE commands.
START RLIMIT Number of START RLIMIT commands.
START DDF Number of START DDF commands.
Note: This will appear on the
report only if DDF data is
present.
STOP DB2 Number of STOP DB2 commands.
STOP DATABASE Number of STOP DATABASE commands.
STOP TRACE Number of STOP TRACE commands.
STOP RLIMIT Number of STOP RLIMIT commands.
STOP DDF Number of STOP DDF commands.
Note: This will appear on the
report only if DDF data is
present.
RECOVER BSDS Number of RECOVER BSDS commands.
RECOVER INDOUBT Number of RECOVER INDOUBT
commands.
TERM UTILITY Number of TERM UTILITY commands.
MODIFY TRACE Number of MODIFY TRACE commands.
CANCEL DDF THREAD Number of CANCEL DDF THREAD.
commands
Note: This will appear on the
report only if DDF data is
present.
ARCHIVE LOG Number of ARCHIVE LOG commands.
IFC Destination Data Section
SMF RECORDS ACCEPTED SMF records successfully written.
SMF BUFFER ERRORS SMF buffer errors.
SMF NOT ACCEPTED SMF record-not-accepted errors.
SMF NOT ACTIVE SMF not-active errors.
SMF WRITER FAILURE SMF writer failures.
RES RECORDS ACCEPTED RES records successfully written.
RES BUFFER ERRORS RES buffer errors.
RES NOT ACCEPTED RES record-not-accepted errors.
RES NOT ACTIVE RES not-active errors.
RES WRITER FAILURE RES writer failures.
GTF RECORDS ACCEPTED GTF records successfully written.
GTF BUFFER ERRORS GTF buffer errors.
GTF NOT ACCEPTED GTF record-not-accepted errors.
GTF NOT ACTIVE GTF not-active errors.
GTF WRITER FAILURE GTF writer failures.
OP1 RECORDS ACCEPTED OP1 records successfully written.
OP1 BUFFER ERRORS OP1 buffer errors.
OP1 NOT ACCEPTED OP1 record-not-accepted errors.
OP1 NOT ACTIVE OP1 not-active errors.
OP1 WRITER FAILURE OP1 writer failures.
OP2 RECORDS ACCEPTED OP2 records successfully written.
OP2 BUFFER ERRORS OP2 buffer errors.
OP2 NOT ACCEPTED OP2 record-not-accepted errors.
OP2 NOT ACTIVE OP2 not-active errors.
OP2 WRITER FAILURE OP2 writer failures.
OP3 RECORDS ACCEPTED OP3 records successfully written.
OP3 BUFFER ERRORS OP3 buffer errors.
OP3 NOT ACCEPTED OP3 record-not-accepted errors.
OP3 NOT ACTIVE OP3 not-active errors.
OP3 WRITER FAILURE OP3 writer failures.
OP4 RECORDS ACCEPTED OP4 records successfully written.
OP4 BUFFER ERRORS OP4 buffer errors.
OP4 NOT ACCEPTED OP4 record-not-accepted errors.
OP4 NOT ACTIVE OP4 not-active errors.
OP4 WRITER FAILURE OP4 writer failures.
OP5 RECORDS ACCEPTED OP5 records successfully written.
OP5 BUFFER ERRORS OP5 buffer errors.
OP5 NOT ACCEPTED OP5 record-not-accepted errors.
OP5 NOT ACTIVE OP5 not-active errors.
OP5 WRITER FAILURE OP5 writer failures.
OP6 RECORDS ACCEPTED OP6 records successfully written.
OP6 BUFFER ERRORS OP6 buffer errors.
OP6 NOT ACCEPTED OP6 record-not-accepted errors.
OP6 NOT ACTIVE OP6 not-active errors.
OP6 WRITER FAILURE OP6 writer failures.
OP7 RECORDS ACCEPTED OP7 records successfully written.
OP7 BUFFER ERRORS OP7 buffer errors.
OP7 NOT ACCEPTED OP7 record-not-accepted errors.
OP7 NOT ACTIVE OP7 not-active errors.
OP7 WRITER FAILURE OP7 writer failures.
OP8 RECORDS ACCEPTED OP8 records successfully written.
OP8 BUFFER ERRORS OP8 buffer errors.
OP8 NOT ACCEPTED OP8 record-not-accepted errors.
OP8 NOT ACTIVE OP8 not-active errors.
OP8 WRITER FAILURE OP8 writer failures.
DDF Services Statistics
LOCATION Location identifier for a remote DB2
subsystem. (DB2RLOCN)
TYPE Type of statistic being reported.
(Total, Average, Maximum)
TRANS. Count of transactions sent or received.
Sent-(DDYTRANS) Received-(DDYTRANR)
ABORTS Abort messages sent or received.
Sent-(DDYABRS) Received-(DDYABRR)
COMMITS COMMIT messages sent or received.
Sent-(DDYCOMS) Received-(DDYCOMR)
CONVERS. VTAM conversations sent or received.
Sent-(DDYCNVS) Received-(DDYCNVR)
CONVERS. QUEUED VTAM conversations queued (DDYCNVQ)
to be sent to remote site.
MESSAGES VTAM messages sent or received.
Sent-(DDYMSGS) Received-(DDYMSGR)
SQL STATEMENTS SQL statements sent or received.
Sent-(DDYSQLS) Received-(DDYSQLR)
DATA ROWS Data rows sent or received.
Sent-(DDYROWS) Received-(DDYROWR)
BYTES/1000 Number of bytes sent (DDYROWS/1000)
TRANSMITTED or received (DDYROWR/1000).
Latch Manager Section (only shown if OPTION SERV is
specified in sharedprefix.MICS.GENLIB(DB2GENIN))
TEST SHARED/EXCLUSIVE (DSYTSELT) shared/exclusive latch
test
SERVICE TASK CONTROLLER (DSYSTCLT) services task
controller latch
SSSC ALLIED AGENT QUEUE (DSYAAQLT) allied agent queue
latch
SUBSYSTEM INTERFACE (DSYSSILT) subsystem interface
latch
DB ALLOCATION CONTROL (DSYDBALT) database allocation
latch
BUFFER MANAGER SHARED (DSYBMSLT) buffer manager latch -
shared
BUFFER MANAGER EXCLUSIVE (DSYBMELT) buffer manager latch -
exclusive
RECOVERY MANAGER STATUS (DSYRMSLT) recover manager status
latch
SYNONYM CHAIN 1 (DSYSCILT) synonym chain-1 latch
SYNONYM CHAIN 2 (DSYSC2LT) synonym chain-2 latch
LOG WRITE FUNCTION (DSYLGWLT) log write function
latch
LOG BSDS ACCESS (DSYBALT) log BSDS latch
BUFFER MGR EXCLUSIVE 2 (DSYBM2LT) buffer manager 2 latch
exclusive
DATA MANAGER HASH TABLES (DSYMHLT) data manager hash
tables latch
DATA MANAGER (DSYDMLT) data manager latch
ADDRESS SPACE ACTIVE (DSYASALT) address space active
latch
SERVICE QUEUE (DSYBMSLT) service queue latch
SYSTEM ADDRESS SPACE (DSYLAT29) system address space
latch
TRACE TABLE (DSYTTLT) trace table latch
STORAGE MGR VECTOR TABLE (DSYSMVLT) storage manager vector
table latch
STORAGE MGR HEADER BLOCK (DSYSMHLT) storage manager header
block latch
IFI Counters Section
ABENDS Count of instrumentation facility
ABENDs encountered.
UNRECOGNIZED FUNCTIONS Count of unrecognized
instrumentation facility
functions.
COMMAND REQUESTS Count of IFI command requests.
READA REQUESTS Count of IFI read A requests.
READS REQUESTS Count of IFI read S requests.
WRITE REQUESTS Count of IFI write requests.
