PrepAway - Latest Free Exam Questions & Answers

What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

PrepAway - Latest Free Exam Questions & Answers

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.

2 Comments on “What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?


Leave a Reply