What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply