DB2 Buffer Pool Stats View

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.