IBM
C4040-124 · Question #37
Which of the following describes an IBM i solution that is designed to prevent long-running or excessive query jobs from impacting the overall performance of a system?
The correct answer is A. The DB2 Predictive Query Governor can prevent the initiation of a query if the estimated run time. See the full explanation below for the reasoning.
Question
Which of the following describes an IBM i solution that is designed to prevent long-running or excessive query jobs from impacting the overall performance of a system?
Options
- AThe DB2 Predictive Query Governor can prevent the initiation of a query if the estimated run time
- BDB2 Query Management Facility provides a comprehensive set of features and functions to
- CDB2 uses the Open Query File manager to provide a filter between the query and database
- DThe IBM i Universal DB2 Query subsystem (QQUERY) defines how, where, and how many
How the community answered
(43 responses)- A77% (33)
- B14% (6)
- C5% (2)
- D5% (2)
Community Discussion
No community discussion yet for this question.