Distributed Activity Requester (Short Trace)

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

This block is part of the Accounting Short Trace.

Accounting - Distributed Activity Requester (Short Trace)

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


...
-----------------------------------------------------------------------------------------------                                 
|REQUESTER         PRODUCT ID    PROD VERSION  METH  ROLLBCK  COMMITS  SQLRECV  ROWSENT  CONVI|                                 
|::FFFF#1          JDBC DRIVER   V3 R65M0      DRDA        0        1        4        0      1|                                 
-----------------------------------------------------------------------------------------------                                 
...
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

PROD 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

ROLLBCK

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

Field Name: ADROL12R

COMMITS

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