IFCID 003 - Accelerator SQL Call Data V4 or later

This topic shows detailed information about Record Trace - IFCID 003 - Accelerator SQL Call Data V4 or later.

Record trace - IFCID 003 - Accelerator SQL Call Data V4 or later

The field labels shown in the following sample layout of Record Trace - IFCID 003 - Accelerator SQL Call Data V4 or later are described in the following section.


                                              ACCELERATOR SQL CALL DATA                                                
                                                                                                                     
INSERT STMTS SENT TO ACCELERATOR .....:                    7  ROWS INSERTED ........................:             10800005
DELETE STMTS SENT TO ACCELERATOR .....:                    0  ROWS DELETED .........................:                    0
UPDATE STMTS SENT TO ACCELERATOR .....:                    0  ROWS UPDATED .........................:                    0
OPEN STMTS SENT TO ACCELERATOR .......:                    0  ROWS FETCHED .........................:                    0
CREATE STMTS SENT TO ACCELERATOR .....:                    0  DROP STMTS SENT TO ACCELERATOR .......:                    0
COMMIT STMTS SENT TO ACCELERATOR .....:                    1  ROLLBACK STMTS SENT TO ACCELERATOR ...:                    0

INSERT STMTS SENT TO ACCELERATOR

The accumulated number of INSERT statements sent to the accelerator from DB2.

Field Name: Q8ACINSC

DELETE STMTS SENT TO ACCELERATOR

The accumulated number of DELETE statements sent to the accelerator from DB2.

Field Name: Q8ACDELC

UPDATE STMTS SENT TO ACCELERATOR

The accumulated number of UPDATE statements sent to the accelerator from DB2.

Field Name: Q8ACUPDC

OPEN STMTS SENT TO ACCELERATOR

The accumulated number of OPEN statements sent to the accelerator from DB2.

Field Name: Q8ACOPNC

CREATE STMTS SENT TO ACCELERATOR

The accumulated number of CREATE statements sent to the accelerator from DB2.

Field Name: Q8ACCRTC

COMMIT STMTS SENT TO ACCELERATOR

The accumulated number of COMMIT statements sent to the accelerator from DB2.

Field Name: Q8ACCMTC

ROWS INSERTED

The accumulated number of rows inserted to the accelerator by DB2.

Field Name: Q8ACROWI

ROWS DELETED

The accumulated number of rows deleted on the accelerator by DB2.

Field Name: Q8ACROWD

ROWS UPDATED

The accumulated number of rows updated on the accelerator by DB2.

Field Name: Q8ACROWU

ROWS FETCHED

The accumulated number of rows returned by the accelerator to DB2.

Note: For completed queries, this is the total number of rows returned to DB2. For in-process queries, this is the number of rows that have been sent so far (and more rows may still be coming).

Field Name: Q8ACROWC

DROP STMTS SENT TO ACCELERATOR

The accumulated number of DROP statements sent to the accelerator from DB2.

Field Name: Q8ACDRPC

ROLLBACK STMTS SENT TO ACCELERATOR

The accumulated number of ROLLBACK statements sent to the accelerator from DB2.

Field Name: Q8ACRBKC