Which statement regarding event monitors is TRUE?
Which statement regarding event monitors is TRUE?
Event monitor data can be reviewed while the event monitor is active. This means you can query and analyze the collected information even as more data is being gathered, allowing for real-time monitoring and analysis. This makes it unnecessary to stop the event monitor to review the data, enabling continuous and uninterrupted monitoring.
The answer D is correct. Indeed, The event monitor can be used to obtain information at a specific point in time. Other uses have not been ruled out. The answer A is wrong. The Event Monitor data can be reviewed even after deactivating the event monitor.
The answer A is correct. You can view data collection with a SQL query even if the event monitor is active. But, Optionally, depending on how you are using the event monitor data, deactivate data collection before you start examining the event data. If the event monitor remains active, it continues to write data to the output tables. Therefore, the results from one query might differ from the results that you obtain by running the same query later on. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/t0059089.html
The answer C is wrong. All event monitors can write to regular tables that can be queried directly using SQL. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/c0059021.html
The answer B is wrong. Indeed, By default, some event monitors activate automatically upon database activation; others require that you activate them manually. However, an event monitor created with the AUTOSTART option will not automatically be activated until the next database activation. Use the SET EVENT MONITOR STATE statement to force a recently-created event monitor into the active state. To determine whether an event monitor starts automatically, refer to the reference information for the relevant CREATE EVENT MONITOR statement. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/t0059044.html See paragraph "2. Activate the event monitor."
The answer D is wrong. Indeed, Monitoring table functions and snapshot routines return the values of monitor elements at the specific point in time the routine is run, which is useful when you want to check the current state of your system. However, you might not always want to monitor points in time. There are many times when you need to capture information about the state of your system at exactly the time that a specific event occurs. Event monitors serve this purpose. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.mon.doc/doc/r0005993.html