What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
Posted: Fri Aug 26, 2022 9:58 am
What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.
B. The number of times a temporary error occurred while trying to queue a column- organized prefetch request for a regular table space.
C. The number of times DB2 had to retrieve a page from disk for a temporary column- organized table because the page no longer resided in the buffer pool.
D. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.
A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.
B. The number of times a temporary error occurred while trying to queue a column- organized prefetch request for a regular table space.
C. The number of times DB2 had to retrieve a page from disk for a temporary column- organized table because the page no longer resided in the buffer pool.
D. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.