FIELDID option: Accounting keywords

Accounting keywords for the FIELDID option of the DISTRIBUTE command.

Usage

The following sections show the FIELDID options that are available for accounting keywords.

Keywords

Accounting keywords for:

Buffer pool activity

This section lists the Accounting keywords for buffer pool activity that are available for the FIELDID option.

Table 12. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QBACGET The number of Getpage requests. The counter is incremented by conditional Getpage requests for each thread, if successful, and for nonconditional requests, whether successful or not.
QBACRIO The number of synchronous read I/O operations.
QBACSEQ The number of sequential prefetch requests.
QBACLPF The number of list prefetch requests.
QBACDPF The number of dynamic prefetch requests.
QBACHRE The number of successful hiperpool reads.
QBACHRF The number of unsuccessful hiperpool reads.
QBACSWS The number of buffer updates.
QBACIMW The number of synchronous writes.
QBACHWR The number of successful hiperpool writes.
QBACHWF The number of unsuccessful hiperpool writes.
QBACSIO The number of asynchronous pages read by prefetch that the agent triggered.
QBACHPG The number of pages read asynchronously from hiperpool.
ABCLSPR The number of all types of prefetch requests.
Note:
All fields can be explicitly qualified by one of the following:
BPn
4 KB buffer pool number (0 <= n <= 49)
BP32K
32 KB buffer pool
BP32Kn
32 KB buffer pool number (1 <= n <= 9)
TOT4K
Total of all 4 KB buffer pools
TOT32K
Total of all 32 KB buffer pools
TOTAL
Total of all 4 KB and 32 KB buffer pools

Data capture and IFI class 5 times

This section lists the Accounting keywords for data capture and IFI class 5 times that are available for the FIELDID option.

Table 13. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QIFAAIET The elapsed time spent processing IFI calls (class 5).
QIFAAITT The TCB time spent processing IFI calls (class 5).
QIFAAMBT The elapsed time spent processing data capture describes.
QIFAAMLT The elapsed time spent performing log extraction.
ADIFICAL The total number of IFI calls.
QIFAANDR The total number of data capture data rows returned. Two rows are returned for each row altered by an SQL update statement.

Data sharing locking

This section lists the Accounting keywords for data sharing locking that are available for the FIELDID option.

Table 14. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QTGALPLK The number of lock requests for P-locks.
QTGAUPLK The number of unlock requests for P-locks.
QTGACPLK The number of change requests for P-locks.
QTGALSLM The number of lock requests propagated to MVS™ XES.
QTGAUSLM The number of unlock requests propagated to MVS XES.
QTGACSLM The number of change requests propagated to MVS XES.
QTGAIGLO The number of suspensions caused by Internal Resource Lock Manager (IRLM) global resource contention.
QTGASGLO The number of suspensions caused by MVS XES global resource contention.
QTGAFLSE The number of suspensions caused by false contention.
QTGADRTA The number of global lock or change requests denied because of an incompatible retained lock.
QTGANTFY The number of notify messages sent.
ALLPSUSP The total number of suspensions (local and global).
APLKSUSP The total number of data-sharing suspensions.

DDF activity

This section lists the Accounting keywords for DDF activity that are available for the FIELDID option.

Table 15. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QLACCNVQ The number of conversations queued.
QLACCIEL The maximum number of open conversations.
QLACBROW The number of rows transmitted in the message buffers if block fetch was used.
QLACCBLB The number of times a switch was made from continuous to limited block fetch (DB2® private protocol only).
QLACBRBF The number of blocks received by the requester.
QLACBTBF The number of blocks sent to the requester.
QLACCOMS The number of commits sent-single-phase commit.
QLACCOMR The number of commits received-single-phase commit.
QLACABRS The number of rollbacks sent-single-phase commit.
QLACABRR The number of rollbacks received-single-phase commit.
QLACSQLS The number of SQL statements sent.
QLACSQLR The number of SQL statements received.
QLACROWS The number of rows sent.
QLACROWR The number of rows received.
QLACMSGS The number of messages sent.
QLACMSGR The number of messages received.
QLACBYTS The number of bytes sent.
QLACBYTR The number of bytes received.
QLACRBND The number of SQL statements sent to a DB2 private protocol server for bind.
ADDSELRQ The elapsed time at the requester.
ADDSELSR The elapsed time at the server.
ADDSSRSR The CPU time at the server.
QLACCRSE The number of commit requests sent to the participant (two-phase commit operations only).
QLACCRRC The number of commit requests received from the coordinator (two-phase commit operations only).
QLACBKSE The number of backout requests sent to the participant (two-phase commit operations only).
QLACBKRC The number of backout requests received from the coordinator (two-phase commit operations only).
Note:
All fields can be explicitly qualified by the remote location.

Group buffer pool activity

This section lists the Accounting keywords for group buffer pool activity that are available for the FIELDID option.

Table 16. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QBGAXD Reads (cross invalidation)-data returned.
QBGAXR Reads (cross invalidation)-no data returned.
QBGAMD Reads (page not found)-data returned.
QBGAMR Reads (page not found)-no data returned.
QBGAMN Reads (page not found)-read prefetch.
QBGAWC Clean pages written.
QBGASW Changed pages written.
Note:
All fields can be explicitly qualified by one of the following:
GBPn
4 KB group buffer pool number (0 <= n <= 49)
GBP32K
32 KB group buffer pool
GBP32Kn
32 KB group buffer pool number (1 <= n <= 9)
TOT4K
Total of all 4 KB group buffer pools
TOT32K
Total of all 32 KB group buffer pools
TOTAL
Total of all 4 KB and 32 KB group buffer pools

Locking activity

This section lists the Accounting keywords for locking activity that are available for the FIELDID option.

Table 17. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QTXATIM The number of timeouts.
QTXADEA The number of deadlocks.
ADTIMDLK The number of deadlocks and timeouts.
ALRSUSP The number of suspensions.
QTXASLOC The number of lock suspensions.
QTXASLAT The number of latch suspensions.
QTXALOCK The number of lock requests.
QTXAUNLK The number of unlock requests.
QTXACHG The number of change requests.
QTXALES The number of lock escalations (shared).
QTXALEX The number of lock escalations (exclusive).
QTXANPL The maximum page locks held (high-water mark).
QTXACLNO The number of claim requests.
QTXACLUN The number of claim requests that were unsuccessful.
QTXADRNO The number of drain requests.
QTXADRUN The number of drain requests that were unsuccessful.

Miscellaneous accounting data

This section lists the Accounting keywords for miscellaneous accounting data that are available for the FIELDID option.

Table 18. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QWACCOMM The number of commits.
QWACABRT The number of rollbacks.
QXINCRB The number of incremental binds.

Package data

This section lists the Accounting keywords for package data that are available for the FIELDID option.

Table 19. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QPACSQLC The number of SQL statements issued in this package or DBRM.
QPACSCT The class 7 elapsed time spent in DB2 executing the package or DBRM.
QPACTJST The class 7 CPU time spent in DB2 executing the program.
ADLLPSSC The number of lock or latch suspensions.
QPACAWTL Waiting time for lock or latch suspensions.
ADIOPSSC The total number of synchronous I/O suspensions.
QPACAWTI The time spent waiting caused by synchronous I/O suspensions.
ADARPSSC The total number of suspensions caused by read I/O performed under a thread other than the one being reported.
QPACAWTR The time spent waiting caused by read I/O performed under a thread other than the one being reported.
ADAWPSSC The number of suspensions caused by write I/O performed under a thread other than the one being reported.
QPACAWTW The time spent waiting caused by write I/O performed under a thread other than the one being reported.
ADSTPSSC Suspensions caused by synchronization execution unit switch to DB2 services from the thread being reported.
QPACAWTE Waiting time caused by synchronization execution unit switch to DB2 services.
ADDRPSSC The total number of suspensions caused by drain lock processing.
QPACAWDR The time spent waiting caused by drain lock suspensions.
ADTSUSCP The total number of class 8 suspensions.
ADTSUSTP The waiting time for all class 8 suspensions.
Note:
All fields can be explicitly qualified by the package name (location, collection ID, package ID).

Query parallelism

This section lists the Accounting keywords for query parallelism that are available for the FIELDID option.

Table 20. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QXMAXDEG The maximum degree of parallel query processing that was executed among all the parallel groups. It indicates the amount of queries that were processed in parallel.
QXTOTGRP The number of parallel groups executed.
QXDEGCUR The number of parallel groups that fall back to sequential mode caused by cursor UPDATE/DELETE.
QXDEGESA The total number of parallel groups that fall back to sequential mode caused by a lack of ESA sort support.
QXDEGBUF The total number of parallel groups that fall back to sequential mode caused by storage shortage or contention on the buffer pool.
QXDEGENC The total number of parallel groups that fall back to sequential mode caused by unavailable enclave service.
ADTOTPFL The total number of parallel groups that fall back to sequential mode.
QXREDGRP The total number of parallel groups executed in reduced parallel degree caused by a shortage of space or contention on the buffer pool.
QXNORGRP The total number of parallel groups executed in the desired degree of parallel query processing.
QWDAXCLM The maximum number of DB2 members that participated in the processing of a query.
QWCOORNO The total number of parallel groups executed on a single DB2 caused by the COORDINATOR subsystem value being set to NO.
QXISORR The total number of parallel groups executed on a single DB2 caused by repeatable-read or read-stability isolation.
QXCRGTT The number of CREATE GLOBAL TEMPORARY TABLE statements executed.

RID list processing

This section lists the Accounting keywords for RID list processing that are available for the FIELDID option.

Table 21. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QXMIAP The number of times RID list processing was used.
QXNSMIAP The number of times RID list processing was not used caused by a shortage of storage space.
QXMRMIAP The number of times RID list processing was not used caused by one or more internal limits being exceeded.
ARTTERM The number of times RID list processing was not used due to any reason.

SQL activity

This section lists the Accounting keywords for SQL activity that are available for the FIELDID option.

Table 22. Accounting keywords used with the DISTRIBUTE command
Keyword Description
QXSELECT The number of SELECT statements executed.
QXINSRT The number of INSERT statements executed.
QXUPDTE The number of UPDATE statements executed.
QXDELET The number of DELETE statements executed.
QXDESC The number of DESCRIBE statements executed.
QXPREP The number of PREPARE statements executed.
QXOPEN The number of OPEN statements executed.
QXFETCH The number of FETCH statements executed.
QXCLOSE The number of CLOSE statements executed.
ASCDML The total number of DML statements executed.
ASSIUDP The sum of SELECT, UPDATE, INSERT, DELETE, and PREPARE statements.
ASSIUD The sum of SELECT, UPDATE, INSERT, and DELETE statements.
ASIUD The ratio of the sum of UPDATE, INSERT, and DELETE statements to the sum of commits and rollbacks.
ASOTHDML The sum of other DML statements.
QXLOCK The number of LOCK TABLE statements executed.
QXGRANT The number of GRANT statements executed.
QXREVOK The number of REVOKE statements executed.
ASCDCL The total number of DCL statements executed.
ASTOTDEF The total number of DCL and DDL statements.
ADTDDL The number of DDL statements executed.

Timing data

This section lists the Accounting keywords for timing data that are available for the FIELDID option.

Table 23. Accounting keywords used with the DISTRIBUTE command
Keyword Description
ADRECETT Class 1 (in application) elapsed time.
ADTCBT Class 1 (in application) CPU time.
ADDB2ETT Class 2 (in DB2) elapsed time.
ADDBTCBT Class 2 (in DB2) CPU time.
ADTWTAP Class 1 waiting time.
ADTWTDB Class 2 waiting time.
ADLLSUSC The number of lock or latch suspensions.
QWACAWTL The time spent waiting caused by lock or latch suspensions.
ADIOSUSC The total number of synchronous I/O suspensions.
QWACAWTI The time spent waiting caused by synchronous I/O suspensions.
ADARSUSC The total number of suspensions caused by read I/O performed under a thread other than the one being reported.
QWACAWTR The time spent waiting caused by read I/O performed under a thread other than the one being reported.
ADAWSUSC The total number of suspensions caused by write I/O performed under a thread other than the one being reported.
QWACAWTW The time spent waiting caused by write I/O performed under a thread other than the one being reported.
ADSTSUSC The total number of suspensions caused by synchronous execution unit switch to DB2 services from the thread being reported.
QWACAWTE The time spent waiting caused by synchronous execution unit switch to DB2 services from the thread being reported.
ADDRSUSC The total number of suspensions caused by drain lock processing.
QWACAWDR The time spent waiting caused by drain lock suspensions.
ADTSUSC The total number of class 3 suspensions.
ADTSUST The time spent waiting for all class 3 suspensions.
ADSUCPU1 The class 1 CPU service unit time (in an application).
ADSUCPU2 The class 2 CPU service unit time (in DB2).