Db2 Buffer Pool Stats View
Db2 Buffer Pool Stats View shows the buffer pool statistics for the Db2 Analytics Accelerator.
PROFILE NAME |
The name of the profile. |
JOB_MEASUREMENT_TS |
The timestamp when the measurement was started. |
OWNER |
The user ID or job name that initiated the request. |
PROFILE_PATH |
The full path where the profile is located. |
RUN_DATE |
The date when the reporter processed the sample data set output from the measurement session to create the performance profile. |
RUN_TIME |
The time when the reporter processed the sample data set output from the measurement session to create the performance profile. |
RUN_TS |
The timestamp when the reporter processed the sample data set output from the measurement session to create the performance profile. |
ENTRY_ID |
The ID of Db2 entry. |
END_USER_ID |
The end user's ID. |
END_USER_TRANS |
The end user's transaction name. |
END_USER_WORKSTATION |
The end user's workstation name. |
CORRELATION_ID |
The correlation ID of the requester executing the SQL. |
TRAN_CODE |
The transaction code. |
AUTH_ID |
The authorization ID. |
WLM_NAME |
The name of the WLM class under which the workload ran if it was assigned. |
BUFFER_POOL_ID |
Shows the buffer pool ID. |
GET_PAGES |
Shows the number of GETPAGE requests. |
ASYNCHRONOUS_READS |
Shows the number of pages that were found in a hiperpool and moved to a virtual buffer pool because of a prefetch that was triggered by the agent. |
SYNCHRONOUS_READS |
Shows the number of synchronous read I/O operations. |
SEQUENTIAL_PREFETCH |
Shows the number of SEQUENTIAL PREFETCH requests. |
LIST_PREFETCH |
Shows the number of List Prefetch requests. |
DYNAMIC_PREFETCH |
Shows the number of (dynamic) PREFETCH requests. |
IMMEDIATE_WRITE |
Shows the number of immediate (synchronous) write I/O operations. |
PAGE_UPDATES |
Shows the number of times a buffer update occurs. |
GET_PAGE_FAILS |
Shows the number of times that a page requested for a query processed in parallel was unavailable because an I/O was in progress or the page was not found in the buffer pool. |