Distributed Activity Requester (Short Report)

This topic shows detailed information about Accounting - Distributed Activity Requester (Short Report).

This block is part of the Accounting Short Report.

Note: The total values for each requester (or server) are not calculated if there are multiple lines that result from different product IDs and product versions. However, you can calculate these totals as follows:
  1. Field labels that start with a #-sign are totals. The sums of these fields are the values for each requester (or server).
  2. The remaining numerical fields are averages for each #DDFS. Multiply the shown average values by the #DDFS value to calculate the absolute value for each requester (or server) and line.
  3. Then summarize all absolute values for each requester (or server) and line, and divide the sum by the sum of all #DDFS values for each requester (or server).

You can customize the report layout using the user-tailored reporting (UTR) facility as described in the Reporting Reporting User's Guide section about Tailoring report layouts.

Accounting - Distributed Activity Requester (Short Report)

The field labels shown in the following sample layout of Accounting - Distributed Activity Requester (Short Report) are described in the following section.


...   
------------------------------------------------------------------------------------------------------                           
|REQUESTER         PRODUCT ID    PROD VERSION  METH  #DDFS  #ROLLBK  #COMMIT  SQLRECV  ROWSENT  CONVI|                           
|::FFFF#1          JDBC DRIVER   V3 R65M0      DRDA      2        0        2     5.50     0.00   1.00|                           
------------------------------------------------------------------------------------------------------                           
...
REQUESTER

The name of the remote location with which this information is associated. If the local location is the requester, this field is a server location. If the local location is a server location, this field is the requester location. An allied thread is created at a Db2 requester, and a database access thread is created at a Db2 server. An accounting record is for either a requester or a server, but not for both.

This field is invalid if summary rollup data is present. In Accounting this field is set to *ROLSUM*.

Field Name: QLACLOCN

This is an exception field.

PRODUCT ID
The original Db2® field specifies the information in the following field names of the remote requester or server location:
PRODUCT ID
It consists of 3 characters and can have the following values:
Original ID from Db2 Shown as
DSN Db2
ARI SQL/DS
QSQ DB2/400
SQL COMMON SERV
JCC JDBC DRIVER
'000000'X, '404040'X N/P
Other Original ID from Db2
Note:
  • If the record is written at the application requester location, or if summary rollup data is available, N/P is shown in Accounting TRACE and REPORT.
  • In Accounting FILE and SAVE DDF tables, BLANK is shown.
PRODUCT VERSION (PROD VERSION)
It consists of 5 digits and is shown as VvvRrrMm , where:
vv
Version level
rr
Release level
m
Modification level
Note: For DDF/RRSAF rollup records, the product ID and product version contain a value derived from the last thread to rollup. For query parallelism rollup threads, the value is derived from the parent record.

Field Name: QLACPRID

PRODUCT VERSION
The original Db2 field specifies the information in the following field names of the remote requester or server location:
PRODUCT ID
It consists of 3 characters and can have the following values:
Original ID from Db2 Shown as
DSN Db2
ARI SQL/DS
QSQ DB2/400
SQL COMMON SERV
JCC JDBC DRIVER
'000000'X, '404040'X N/P
Other Original ID from Db2
Note:
  • If the record is written at the application requester location, or if summary rollup data is available, N/P is shown in Accounting TRACE and REPORT.
  • In Accounting FILE and SAVE DDF tables, BLANK is shown.
PRODUCT VERSION (PROD VERSION)
It consists of 5 digits and is shown as VvvRrrMm , where:
vv
Version level
rr
Release level
m
Modification level
Note: For DDF/RRSAF rollup records, the product ID and product version contain a value derived from the last thread to rollup. For query parallelism rollup threads, the value is derived from the parent record.

Field Name: QLACPRID

METH

The method of access: Db2 private protocol, DRDA protocol, or both.

This field is invalid if unique or summary rollup data is present. It can have the following value in:
  • Accounting Trace and Report: N/P
  • The Accounting FILE and SAVE PROGRAM table: blank

Field Name: ADPROTOC

#DDFS

The number of occurrences of the remote location and method pair.

Field Name: ASDDF

#ROLLBK

The total number of rollbacks (single phase and two-phase) received.

Field Name: ADROL12R

#COMMIT

The total number of commits (single phase and two-phase) received.

Field Name: ADCOM12R

SQLRECV

The number of SQL statements received from the requester location.

Field Name: QLACSQLR

ROWSENT

The number of rows sent from the server location to the requester location. The value includes SQLDA and is maintained at the server location.

Field Name: QLACROWS

CONVI

A count of conversations initiated by the requester.

This number is updated at the server location.

Field Name: QLACCNVR