IBM
C2180-318 · Question #16
In a production environment, a system administrator tuned the data source statement cache to optimize the processing of prepared statements and callable statements by caching those statements that…
The correct answer is C. Use the Tivoli Performance Viewer. See the full explanation below for the reasoning.
Question
In a production environment, a system administrator tuned the data source statement cache to optimize the processing of prepared statements and callable statements by caching those statements that are not used in an active connection. When the cache is full, old entries in the cache are discarded. The administrator would like to get statistics on the number of statements discarded from the cache to determine how to minimize cache discards. How can the system administrator obtain this information?
Options
- AEnable request metrics.
- BConfigure HPEL and examine the log files.
- CUse the Tivoli Performance Viewer.
- DUse the IBM Support Assistant Data Collector.
How the community answered
(29 responses)- A10% (3)
- B7% (2)
- C79% (23)
- D3% (1)
Community Discussion
No community discussion yet for this question.