Static SQL Cache Attributes

Use these attributes to view static SQL cache information.

Accum In-DB2 CPU Time The accumulated in-DB2 CPU time. This time includes CPU consumed on an IBM specialty engine (Field name: QW0401CP).

Accum In-DB2 Time Accumulated in-DB2 elapsed time (Field name: QW0401ET).

Accumulated wait for lock The accumulated wait time for locks (Field name: QW0401LK).

Append RID exceeded The number of times that appending to a RID list for a hybrid join was interrupted because the number RIDs exceeded one or more internal limits.

Append RID no stg The number of times that appending to a RID list for a hybrid join was interrupted because no RID pool storage was available to hold the list of RIDs.

Avg parallel degree The average actual degree of parallelism for all parallel groups. The actual degree of parallelism is calculated at execution time, after buffer pool negotiation and system negotiation are taken into account (Field name: Q401ESTI).

Avg parallel est degree The average estimated degree of parallelism for all parallel groups. The estimated degrees are calculated at bind time, based on the cost formula. The average is calculated at execution time (Field name: Q401ACT).

Avg parallel plan degree The average planned maximum degree of parallelism for all of the parallel groups. The average is calculated at execution time. It is the optimal degree of parallelism that can be obtained at execution time, after host variables or parameter markers are resolved, and before buffer pool negotiation and system negotiation are performed : Q401PLAN).

Buffer Write The number of buffer writes (Field name: QW0401WT).

Collection The package collection ID (Field name: QW0401CL).

Consistency Token Consistency token of the package (Field name: QW0401CT).

DB2 Subsystem The DB2 subsystem ID.

DB2 Version The DB2 version.

DSG Member Name The Data Sharing Group (DSG) member name.

Data Sharing Group The Data Sharing Group name.

Executions The number of executions (Field name: QW0401EX). Reason that the SQL statement was expanded. See QW0053ER for possible values.

Expansion reason Expansion reason (Field name: Q401EXR).

Filler Filler.

Filler2Filler for padding.

Global child\L-locks waitWaits due to global contention for child L-locks (Field name: QW401WC).

Global other\L-locks waitWaits due to global contention for other L-locks (Field name: QW401WD).

Global P/P P-locks waitWaits due to global contention for Pageset/Partition P-locks (Field name: QW401WE).

Global Page\P-locks waitWaits due to global contention for Page P-locks (Field name: QW401WF).

Global Other\P-locks waitWaits due to global contention for other P-locks (Field name: QW401WG).

Getpages The number of Getpages (Field name: QW0401GP).

Global Locks Wait Time The accumulated wait time for global locks (Field name: QW0401GL).

Index Scan The number of index scans (Field name: QW0401IX).

Insert Date STCK The date or time when the statement was inserted into the EDM pool (in store clock format) (Field name: QW0401TM2).

Insert Date The date or time when the statement was inserted into the EDM Pool, in internal format (Field name: QW401TM).

Interval Start The start time of this interval.

MVS System ID The MVS identifier.

Originating System The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Package Name The package ID (Field name: QW0401PK).

Parallel Groups Created The number of parallel groups created (Field name: QW0401PG).

RID list retrieval failed The number of times that RID list retrieval for multiple index access was not done because DB2 could determine the outcome of index ANDing or ORing (Field name: QW401RSM).

RID overflow RIDs The number of times a RID list was overflowed to a work file because the number of RIDs exceeded one or more internal limits (Field name: QW401WRT).

RID overflow no stg The number of times that a RID list overflowed to a work file because no RID pool storage was available to hold the list of RIDs (Field name: QW401WRS).

Reads other Wait Time The accumulated wait time for a read activity done by another thread (Fieldname: QW0401OR).

Rows Exam The number of rows examined (Field name: QW0401ER).

Rows Proc The number of rows processed (Field name: QW0401PR).

Sorts The number of sorts (Field name: QW0401ST).

Statement ID The statement identifier (Field name: QW0401ID).

Storage Limit Exceeded The number of times that a RID list was not used because there was not enough storage available to hold the RID list, or work file storage or resources were not available (Field name: QW0401RS).

Sync I/O Wait Time The accumulated wait time for synchronous I/O (Field name: QW0401SI).

Sync Read The number of synchronous buffer reads (Field name: QW0401SR).

Tablespace Scan The number of tablespace scans (Field name: QW0401TB).

Update Date 2 The date or time when statement statistics were updated in internal format (Field name: QW401UT2).

Update Date The date or time when statement statistics were updated in store clock format (Field name: QW401UT1).

Wait for drain lock The accumulated wait time for drain locks (Field name: QW0401DL).

Wait for latch req The accumulated wait time for a latch request (Field name: QW0401LH).

Wait for log writer The accumulated wait time for log writers (Field name: QW0401LW).

Wait for page latch The accumulated wait time for page latches (Field name: QW0401PL).

Writes other Wait Time The accumulated wait time for a write activity done by another thread (Field name: QW0401OW).

Wait for claim release The accumulated wait time for drain locks that are waiting for claims to be released (Field name: QW0401CM).

Wait for sync exec switch The accumulated wait time for synchronous execution unit switch (Field name: QW0401EU).