Data capture (BSTATDR)
------------------------- -------- ------- ------- -------
LOG RECORDS CAPTURED 0 0.00 0.00 0.00
LOGREADS PERFORMED 0 0.00 0.00 0.00
LOG RECORDS RETURNED 0 0.00 0.00 0.00
DATA ROWS RETURNED 0 0.00 0.00 0.00
DESCRIBES PERFORMED 0 0.00 0.00 0.00
DATA DESCRIPTIONS RETRNED 0 0.00 0.00 0.00
TABLES RETURNED 0 0.00 0.00 0.00
The following table describes the fields in the Data capture section.
Field | Description |
|---|---|
LOG RECORDS CAPTURED | Number of captured log records (QWSDCDLC) This counter is incremented as log records are passed to the capture exit interface. Any log record can be passed through either the IFI or the stand-alone data capture exit interface. |
LOGREADS PERFORMED | Number of data capture log reads of IFCID 185 (QWSDCDLR) IFCID 185 is the specific log record used by the IFI capture facility to return before and after images of updated rows. Tuning Tip: An application program must be written or a program product purchased to use this interface. It issues IFI READS requests for IFCID 185. |
LOG RECORDS RETURNED | Number of captured log records returned (QWSDCDRR) This value is a counter Db2 maintains of log records returned through the non-IFI data capture exit. Tuning Tip: This counter can be examined to determine the overhead of invoking the capture exit from the logging subsystem. |
DATA ROWS RETURNED | Number of data capture data rows returned (QWSDCDDR) This counter is incremented by the number of before and after images of specific rows of data returned in IFCID 185. IFCID 185 has a section to parse the data in the row in field QW0185DR. |
DESCRIBES PERFORMED | Number of data capture describes performed (QWSDCDMB) This counter is incremented every time Db2 does catalog access to obtain the data column description to fill in the QW0185DD. Tuning Tip: This process can be quite costly. |
DATA DESCRIPTIONS RETURNED | Number of data capture descriptions returned (QWSDCDDD) This count is of the number of descriptions returned from the IFI interface. When activated, the columns and their lengths are mapped in field QW0185DD. Tuning Tip: This information is obtained from the catalog to allow the user to parse the row data with the data description from the catalog. |
TABLES RETURNED | Number of data capture tables returned to caller (QWSDCDTB) This counter is incremented for each table description that required a catalog lookup. Tuning Tip: This permits the system administrator to determine the number of tables for which the capture facility is activated. |