IFCID 002 - Accelerator SQL Call Data V4 or later

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

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

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


                                              ACCELERATOR SQL CALL DATA                                                
                                                                                                                     
INSERT STMTS SENT TO ACCELERATOR ....:                    3   UPDATE STMTS SENT TO ACCELERATOR ....:                    7
DELETE STMTS SENT TO ACCELERATOR ....:                    4   DROP STMTS SENT TO ACCELERATOR ......:                    8
CREATE STMTS SENT TO ACCELERATOR ....:                    5   COMMIT STMTS SENT TO ACCELERATOR ....:                    9
ROLLBACK STMTS SENT TO ACCELERATOR ..:                    6   OPEN STMTS SENT TO ACCELERATOR ......:                   10

INSERT STMTS SENT TO ACCELERATOR

The number of INSERT statements sent by the DB2 system to the accelerator.

Field Name: Q8STINSC

DELETE STMTS SENT TO ACCELERATOR

The number of DELETE statements sent by the DB2 system to the accelerator.

Field Name: Q8STDELC

CREATE STMTS SENT TO ACCELERATOR

The number of CREATE statements sent by the DB2 system to the accelerator.

Field Name: Q8STCRTC

ROLLBACK STMTS SENT TO ACCELERATOR

The number of ROLLBACK statements sent by the DB2 system to the accelerator.

Field Name: Q8STRBKC

UPDATE STMTS SENT TO ACCELERATOR

The number of UPDATE statements sent by the DB2 system to the accelerator.

Field Name: Q8STUPDC

DROP STMTS SENT TO ACCELERATOR

The number of DROP statements sent by the DB2 system to the accelerator.

Field Name: Q8STDRPC

COMMIT STMTS SENT TO ACCELERATOR

The number of COMMIT statements sent by the DB2 system to the accelerator.

Field Name: Q8STCMTC

OPEN STMTS SENT TO ACCELERATOR

The number of OPEN statements sent by the DB2 system to the accelerator.

Field Name: Q8STOPNC