IFCID 239 - RDS Package Accounting

This topic shows detailed information about Record Trace - IFCID 239 - RDS Package Accounting.

Record trace - IFCID 239 - RDS Package Accounting

The field labels shown in the following sample layout of Record Trace - IFCID 239 - RDS Package Accounting are described in the following section.


RDS PACKAGE ACCOUNTING
SELECTS    :          1  INSERTS    :          4  UPDATES    :          7  DELETES    :         10
DESCRIBES  :          2  PREPARES   :          5  OPENS      :          8  CLOSES     :         11
FETCHS     :          3  LOCK TABLES:          6  SQL CALLS  :          9

SELECTS

The number of SQL SELECT statements executed.

Field Name: QPSELECT

This is an exception field.

INSERTS

The number of INSERT statements executed.

Field Name: QPINSRT

This is an exception field.

UPDATES

The number of UPDATE statements executed.

Field Name: QPUPDTE

This is an exception field.

DELETES

The number of DELETE statements executed.

Field Name: QPDELET

This is an exception field.

DESCRIBES

The number of data capture describes.

Field Name: QPDESC

PREPARES

The number of full prepare requests.

Field Name: QPPREP

OPENS

The number of full open requests.

Field Name: QPOPEN

CLOSES

The number of close requests.

Field Name: QPCLOSE

FETCHS

The number of fetch requests.

Field Name: QPFETCH

LOCK TABLES

The number of lock tables.

Field Name: QPLOCK

SQL CALLS

The number of SQL calls.

Field Name: QPCALL