IFCID 225 - Statement Cache / XPROC Detail

This topic shows detailed information about Record Trace - IFCID 225 - Statement Cache / XPROC Detail.

Record trace - IFCID 225 - Statement Cache / XPROC Detail

The field labels shown in the following sample layout of Record Trace - IFCID 225 - Statement Cache / XPROC Detail are described in the following section.


                                              STATEMENT CACHE / xPROC Detail                                              
                                                                                                                          
ALLOCATED STOR FOR DYN SQL STMTS     :                  N/A   REQUESTED STOR FOR DYN SQL STMTS     :                  N/A 
ALLOCATED STOR FOR STATIC SQL STMTS  :                  N/A   HWM REQUESTED STOR FOR DYN SQL STMTS :                  N/A 
ALLOCATED STOR FOR STMT DEPENDENCIES :                47001
                                                                                                                          
TOTAL 31-BIT XPROC DYNAMIC SQL                 :     860160   ALLOCATED 31-BIT XPROC DYNAMIC SQL             :          0 
TOTAL 31-BIT XPROC STATIC SQL                  :          0   HWM ALLOCATED 31-BIT XPROC DYNAMIC SQL         :          0 
                                                                                                                          
STATEMENTS IN 64-BIT AGENT LOCAL POOLS (ALP)   :          0   HWM STMT COUNT IN 64-BIT ALP AT HIGH STOR TIME :          0 
                                                                                                                          
ALLOCATED STMT CACHE IN 64-BIT ALP   :                    0   HWM ALLOCATED STMT CACHE 64-BIT ALP  :                    0 
TIMESTAMP OF HWM AFTER LAST 225 REC: 12/21/10 09:41:48.731613 TOTAL 64-BIT STMT CACHE BLKS 2G      :              2174976 
                                                                                                                          
QW0225F1:                     0                               QW0225F2:                     0

ALLOCATED STOR FOR DYN SQL STMTS

The total shareable storage allocated for dynamic SQL statements used by active threads.

Field Name: QW0225SC8

REQUESTED STOR FOR DYN SQL STMTS

The total shareable storage requested for dynamic SQL statements used by active threads.

Field Name: QW0225LS8

ALLOCATED STOR FOR STATIC SQL STMTS

The total shareable storage allocated for static SQL statements.

Field Name: QW0225SX8

HWM REQUESTED STOR FOR DYN SQL STMTS

A statistics interval high-water mark of requested shareable storage for dynamic SQL statements used by active threads.

Field Name: QW0225HS8

ALLOCATED STOR FOR STMT DEPENDENCIES

The amount of storage allocated above the 2 GB bar to support object dependencies on statements that are in the Dynamic Statement Cache.

Field Name: QW0225DMH

TOTAL 31-BIT XPROC DYNAMIC SQL

The amount of storage allocated for the local cache storage pool below the bar.

Note: For Db2 10, the storage is allocated for executable code sequences of dynamic SQL statements.

Field Name: QW0225SC

ALLOCATED 31-BIT XPROC DYNAMIC SQL

The amount of storage used for thread copies in the local cache storage pool below the bar. This is a subset of the total allocated storage for thread copies QW0225SC.

Note: For Db2 10, the storage is used for executable code sequences of dynamic SQL statements.

Field Name: QW0225LS

TOTAL 31-BIT XPROC STATIC SQL

The amount of storage allocated below the bar for executable code sequences of static SQL statements.

Field Name: QW0225SX

HWM ALLOCATED 31-BIT XPROC DYNAMIC SQL

A statistics interval high-water mark of allocated storage for thread copies in the local cache storage pool below the bar.

Note: For Db2 10, the high water mark is related to executable code sequences of dynamic SQL statements.

Field Name: QW0225HS

STATEMENTS IN 64-BIT AGENT LOCAL POOLS (ALP)

The number of dynamic SQL local cache statements used by active threads. This value is related to shared agent local variable pools above the bar.

Field Name: QW0225LC

HWM STMT COUNT IN 64-BIT ALP AT HIGH STOR TIME

The number of dynamic SQL local cache statements used by active threads at high storage time. This value is related to shared agent local variable pools above the bar.

Field Name: QW0225HC

ALLOCATED STMT CACHE IN 64-BIT ALP

The total non-shareable storage requested for dynamic SQL statements used by active threads. This value is related to shared agent local variable pools above the bar.

Field Name: QW0225L2

HWM ALLOCATED STMT CACHE 64-BIT ALP

This value is related to shared agent local variable pools above the bar.

Field Name: QW0225H2

TIMESTAMP OF HWM AFTER LAST 225 REC

The timestamp at high-water storage.

Field Name: QW0225HT

TOTAL 64-BIT STMT CACHE BLKS 2G

The total statement cache storage blocks above the bar (64-bit shared variable pool).

Field Name: QW0225S2

QW0225F1

This field is for IBM service.

Field Name: QW0225F1

QW0225F2

This field is for IBM service.

Field Name: QW0225F2