有两个主要工具,用途不一,有了它们您就可以访问数据库监控信息:快照监控器和事件监控器。
There are two primary tools, each serving a different purpose, with which you can access database monitor information: the snapshot monitor and event monitors.
本文通过实例演示了如何使用锁事件监控器来收集所有种类的并发性问题:死锁、锁超时及锁等待。
It showed, by example, how you can use the lock event monitor to collect information about any kind of concurrency issue: deadlocks, lock-timeouts, and lock-waits.
快照监控器允许您捕获特定时间内数据库活动的状态,而事件监控器只在特定数据库事件发生时记录数据。
The snapshot monitor enables you to capture a picture of the state of the database activity at a specific moment in time, while event monitors log data only as specified database events occur.
它将读取从事件监控器表执行的sql语句,然后对每个语句运行Explain实用程序以生成对应的访问计划。
It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
在使用首次创建的事件监控器之前,您必须首先禁用数据库然后再激活它,或手动运行事件监控器,如清单15所示。
Before you can use the event monitors after you first create them, you either have to deactivate and activate the database or manually start the event monitors, as shown in Listing 15.
本文已经显示了一个过程,您可以使用该过程自动生成表函数,其以关系格式报告以XML文档形式捕获的事件监控器元素。
This article has shown a procedure that you can use to automatically generate table functions that report event monitor elements captured as an XML document in a relational format.
为了格式化锁事件监控器收集的死锁事件数据,并将其写到普通文本文件中,再次调用db 2evmonfmt工具。
To format the data about the deadlock event that the lock event monitor collects and write it to a plain text file, call the db2evmonfmt utility again.
默认情况下,事件监控器创建之后带有AUTOSTART选项,这表示在数据库下一次被激活时将自动运行事件监控器。
By default, the event monitors are created with the AUTOSTART option, which means that the event monitors are automatically started the next time the database is activated.
在IBMDB 2 9.7中,活动和统计事件监控器都具有DETAILS_XML监控器元素,该元素存储包含大量活动和系统指标的XML文档。
In IBM DB2 9.7, both the activity and statistics event monitors have a DETAILS_XML monitor element that stores an XML document which contains a wealth of activity and system metrics.
MDMServer环境中事件监控器的一个常见用途是死锁事件监控,用于了解和解决 MDM Server 数据库中偶尔发生的过度死锁(excessive deadlocks)。
One common usage of event monitor in the MDM Server environment is deadlock event monitoring to understand and resolve excessive deadlocks that sometimes happen in an MDM Server database.
MDMServer环境中事件监控器的一个常见用途是死锁事件监控,用于了解和解决 MDM Server 数据库中偶尔发生的过度死锁(excessive deadlocks)。
One common usage of event monitor in the MDM Server environment is deadlock event monitoring to understand and resolve excessive deadlocks that sometimes happen in an MDM Server database.
应用推荐