Skip to Content

Default language.

ROW ID

This topic describes the ROW ID section of the Accounting summary—long report (BACCTDR) and the Accounting detail trace—long report (BACCTLT).

Related topic

Accounting report fields

Accounting-summary-long-report-BACCTDR

Accounting-detail-trace-long-report-BACCTLT


ROWID            AVERAGE      TOTAL
-------------  ---------  ---------
DIRECT ACCESS       0.00          0
INDEX USED          0.00          0
TS SCAN USED        0.00          0

The following table describes the fields in the ROW ID section:

Field

Description

DIRECT ACCESS

Number of times that Db2 used direct row access to locate a record (QXROIMAT)

INDEX USED

Number of times that Db2 attempted to use direct row access but reverted to using an index to locate a record (QXROIIDX)

TS SCAN USED

Number of times that Db2 attempted to use direct row access but reverted to using a table space scan to locate a record (QXROITS)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1