Data Capture

This topic shows detailed information about Accounting - Data Capture.

This block shows data for Data Capture activities.

For formatting reasons, OMEGAMON XE for Db2 PE shows different labels for report and trace. In the following example both layouts are shown, the report on the left, and the trace layout on the right.

Accounting - Data Capture

The field labels shown in the following sample layout of Accounting - Data Capture are described in the following section.


Report:                         Trace:

DATA CAPTURE        AVERAGE     DATA CAPTURE     TOTAL
-----------------  --------     ------------  --------
IFI CALLS MADE          N/P     IFI CALLS          N/P
RECORDS CAPTURED        N/P     REC.CAPTURED       N/P
LOG RECORDS READ        N/P     LOG REC.READ       N/P
ROWS RETURNED           N/P     ROWS RETURN        N/P
RECORDS RETURNED        N/P     RECORDS RET.       N/P
DATA DESC. RETURN       N/P     DATA DES.RET       N/P
TABLES RETURNED         N/P     TABLES RET.        N/P
DESCRIBES               N/P     DESCRIBES          N/P

IFI CALLS MADE (IFI CALLS)

The total number of IFI calls. This field is only calculated if accounting class 5 is active.

Field Name: ADIFICAL

RECORDS CAPTURED (REC.CAPTURED)

The number of retrievable log records that were written for tables defined with DATA CAPTURE CHANGES. This number includes only those log records that can be retrieved by an IFI READS call for IFCID 185. Some records can be written but not retrieved, for example if monitor trace class 6 is not active.

Field Name: QIFAANRC

LOG RECORDS READ (LOG REC.READ)

The number of log reads performed for processing IFI READS requests for IFCID 185.

Field Name: QIFAANLR

ROWS RETURNED (ROWS RETURN)

The number of data rows returned in IFCID 185. Two rows are returned for each row altered by an SQL UPDATE statement.

Field Name: QIFAANDR

RECORDS RETURNED (RECORDS RET.)

The number of log records returned to the caller of the IFI READS call for IFCID 185.

Field Name: QIFAANRR

DATA DESC. RETURN (DATA DES.RET)

The number of data descriptions returned in IFCID 185. The data descriptions are mapped in IFCID 185.

Field Name: QIFAANDD

TABLES RETURNED (TABLES RET.)

The total number of tables returned to the caller of IFI READS call for IFCID 185.

Field Name: QIFAANTB

DESCRIBES

The number of data capture describes for processing READS requests for IFCID 185 data.

Field Name: QIFAANMB