Requests vs Activities
DB2 9.7版本首次推出 MON_GET监视元素体系以后,战略上想与 9.5推出的 WLM工作负载管理统一监视体系。
但是,新推出的监视体系中,新增加了两个很关键的概念 Requests 与 Activities。
关于Requests,有以下三种来源:
A request is a directive to a database agent to perform some work that expends database resources. Sources of the request can include:
- A directive issued directly by an external application, such as an OPEN or EXECUTE directive. These are referred to as application requests.
- A directive issued by a coordinator agent to a subagent at the same or a different database member.
- A directive issued by an agent at a different database member.
而触发 Activities 的有下列语句和命令:
- 所有 DML 语句
- 所有 DDL 语句
- CALL 语句
- LOAD
通常,一个 Load 操作会产生多个 Activities,有时一个 CALL调用通常还好产生一系列嵌套的 Activities。
应该用什么层次体系图来描绘 “Requests 与 Activities之间的关系”呢?
收起