- TOTALMEMBERCONNECTIONS > integer-value
- This
condition defines an upper bound on the number of coordinator connections
that can run concurrently on a member. This
value can be zero or any positive integer (SQLSTATE 42820). A
value of zero means that any new coordinator connection will be prevented
from connecting. All currently running or queued connections will
continue. The definition domain for this condition must be DATABASE,
and the enforcement scope must be MEMBER (SQLSTATE 5U037). This
threshold is not enforced for users with DBADM or WLMADM authority.
- TOTALSCMEMBERCONNECTIONS > integer-value
- This condition defines an upper bound on the
number of coordinator connections that can run concurrently on a member in
a specific service superclass. This value can be zero or any positive
integer (SQLSTATE 42820). A value of zero means that any new
connection will be prevented from joining the service class. All currently
running or queued connections will continue. The definition domain
for this condition must be SERVICE SUPERCLASS, and the enforcement
scope must be MEMBER (SQLSTATE 5U037).
- AND QUEUEDCONNECTIONS > integer-value or
AND QUEUEDCONNECTIONS UNBOUNDED
- Specifies a queue size for when the maximum number of coordinator
connections is exceeded. This value can be any positive integer, including
zero (SQLSTATE 42820). A value of zero means that no coordinator connections
are queued. Specifying UNBOUNDED will queue every connection that
exceeds the specified maximum number of coordinator connections, and
the threshold-exceeded-actions will never be executed.
The default is zero.
- CONNECTIONIDLETIME > integer-value DAY
| DAYS | HOUR | HOURS | MINUTE | MINUTES
- This
condition defines an upper bound for the amount of time the database
manager will allow a connection to remain idle. This value can
be any positive integer (not zero) (SQLSTATE 42820). Use a valid
duration keyword to specify an appropriate unit of time for integer-value.
The definition domain for this condition must be DATABASE or SERVICE
SUPERCLASS, and the enforcement scope must be DATABASE (SQLSTATE 5U037). This condition is enforced at the coordinator member.
If
you specify the STOP EXECUTION action with CONNECTIONIDLETIME thresholds,
the connection for the application is dropped when the threshold is
exceeded. Any subsequent attempt by the application to access the
data server will receive SQLSTATE 5U026.
The
maximum value for this threshold is 2 147 483 640 seconds. Any value
specified that has a seconds equivalent larger than 2 147 483 640
seconds will be set to this number of seconds.
- CONCURRENTWORKLOADOCCURRENCES > integer-value
- This
condition defines an upper bound on the number of concurrent occurrences
for the workload on each member. This
value can be any positive integer (not zero) (SQLSTATE 42820). The
definition domain for this condition must be WORKLOAD and the enforcement
scope must be MEMBER (SQLSTATE 5U037).
- CONCURRENTWORKLOADACTIVITIES > integer-value
- This condition defines an upper bound on the
number of concurrent coordinator activities and nested activities
for the workload on each member. This
value can be any positive integer (not zero) (SQLSTATE 42820). The
definition domain for this condition must be WORKLOAD and the enforcement
scope for this condition must be WORKLOAD OCCURRENCE (SQLSTATE 5U037).
Each
nested activity must satisfy the following conditions:
- It must be a recognized coordinator activity. Any nested coordinator
activity that does not fall within the recognized types of activities
will not be counted. Similarly, nested subagent activities, such as
remote node requests, are not counted.
- It must be directly invoked from user logic, such as a user-written
procedure issuing SQL statements.
Consequently,
nested coordinator activities that were automatically started under
the invocation of a database manager utility or routines in the SYSIBM,
SYSFUN, or SYSPROC schemas are not counted toward the upper bound
specified by this threshold.
Internal SQL activities, such as
those initiated by the setting of a constraint or the refreshing of
a materialized query table, are also not counted by this threshold,
because they are initiated by the database manager and not directly
invoked by user logic.
- CONCURRENTDBCOORDACTIVITIES > integer-value
- This condition defines an upper bound on the
number of recognized database coordinator activities that can run
concurrently on all members in
the specified domain. This value can be zero or any positive
integer (SQLSTATE 42820). A value of zero means that any new database
coordinator activities will be prevented from executing. All currently
running or queued database coordinator activities will continue. The
definition domain for this condition must be DATABASE, work action
(a threshold for a work action definition domain is created using
a CREATE WORK ACTION SET or ALTER WORK ACTION SET statement, and the
work action set must be applied to a workload or a database), SERVICE
SUPERCLASS, or SERVICE SUBCLASS. Also,
the enforcement scope must be DATABASE (SQLSTATE 5U037) in environments
other than DB2® pureScale®,
where the condition is enforced across the entire database, and MEMBER
(SQLSTATE 5U037) in DB2 pureScale where
the condition is enforced at each coordinator member. All activities
are tracked by this condition, except for the following items:
- CALL statements are not controlled by this threshold, but all
nested child activities started within the called routine are under
this threshold's control. Anonymous blocks and autonomous routines
are classified as CALL statements.
- User-defined functions are controlled by this threshold, but child
activities nested in a user-defined function are not controlled. If
an autonomous routine is called from within a user defined function,
neither the autonomous routine nor any child activities of the autonomous
routine are under threshold control.
- Trigger actions that invoke CALL statements and the child activities
of these CALL statements are not controlled by this threshold. INSERT,
UPDATE, or DELETE statements that can cause a trigger to activate
continue to be under threshold control.
- To manage concurrency with a CALL statement, you
may be able to use the TOTALSCPARTITIONCONNECTIONS threshold. The
TOTALSCPARTITIONCONNECTIONS threshold is effective for controlling
concurrency of CALL statements when your workload consists of transient
connections. Transient connections are connections that are established
only during the procedure invocation. The TOTALSCPARTITIONCONNECTIONS
threshold is not appropriate if your workload consists of long-lived
connections.
When
a threshold is defined as part of a work action set, the enforcement
scope is determined automatically based on the current environment
(MEMBER, if the current environment is DB2 pureScale;
DATABASE, if it is otherwise).
- AND QUEUEDACTIVITIES > integer-value or
AND QUEUEDACTIVITIES UNBOUNDED
- Specifies
a queue size for when the maximum number of database coordinator activities
is exceeded. This value can be zero or any positive integer (SQLSTATE
42820). A value of zero means that no database coordinator activities
are queued. Specifying UNBOUNDED will queue every database coordinator
activity that exceeds the specified maximum number of database coordinator
activities, and the threshold-exceeded-actions will
never be executed. The default is zero.
Note: If
a threshold action of CONTINUE is specified for a queuing threshold,
it effectively makes the size of the queue unbounded, regardless of
any hard value specified for the queue size.
- ESTIMATEDSQLCOST > bigint-value
- This
condition defines an upper bound for the optimizer-assigned cost (in
timerons) of an activity. This value can be any positive big integer
(not zero) (SQLSTATE 42820). The definition domain for this condition
must be DATABASE, work action (a threshold for a work action definition
domain is created using a CREATE WORK ACTION SET or ALTER WORK ACTION
SET statement, and the work action set must be applied to a workload
or a database), SERVICE SUPERCLASS, SERVICE SUBCLASS, or WORKLOAD,
and the enforcement scope must be DATABASE (SQLSTATE 5U037). This condition is enforced at the coordinator member. Activities
tracked by this condition are:
- Coordinator activities of type data manipulation language (DML).
- Nested DML activities that are invoked from user logic. Consequently,
DML activities that can be initiated by the database manager (such
as utilities, procedures, or internal SQL) are not tracked by this
condition (unless their cost is included in the parent's estimate,
in which case they are indirectly tracked).
- SQLROWSRETURNED > integer-value
- This
condition defines an upper bound for the number of rows returned to
a client application from the application server. This value can
be any positive integer (not zero) (SQLSTATE 42820). The definition
domain for this condition must be DATABASE, work action (a threshold
for a work action definition domain is created using a CREATE WORK
ACTION SET or ALTER WORK ACTION SET statement, and the work action
set must be applied to a workload or a database), SERVICE SUPERCLASS,
SERVICE SUBCLASS, or WORKLOAD, and the enforcement scope must be DATABASE
(SQLSTATE 5U037). This condition is enforced
at the coordinator member. Activities
tracked by this condition are:
- Coordinator activities of type DML.
- Nested DML activities that are derived from user logic. Activities
that are initiated by the database manager through a utility, procedure,
or internal SQL are not affected by this condition.
Result sets returned from within a procedure are treated separately
as individual activities. There is no aggregation of the rows that
are returned by the procedure itself.
- ACTIVITYTOTALTIME > integer-value DAY
| DAYS | HOUR | HOURS | MINUTE | MINUTES | SECONDS
- This condition defines an upper bound for the amount of time the
database manager will allow an activity to execute, including the
time the activity was queued. The definition domain for this condition
must be DATABASE, work action (a threshold for a work action definition
domain is created using a CREATE WORK ACTION SET or ALTER WORK ACTION
SET statement, and the work action set must be applied to a workload
or a database), SERVICE SUPERCLASS, SERVICE SUBCLASS, or WORKLOAD,
and the enforcement scope must be DATABASE (SQLSTATE 5U037). This
condition is logically enforced at the coordinator member.
The
specified integer-value must be an integer that
is greater than zero (SQLSTATE 42820). Use a valid duration keyword
to specify an appropriate unit of time for integer-value.
If the specified time unit is SECONDS, the value must be a multiple
of 10 (SQLSTATE 42615). The maximum value that can be specified for
this threshold is 2 147 483 640 seconds. If any value (using the DAY,
HOUR, MINUTE, or SECONDS time unit) has a seconds equivalent larger
than the maximum value, an error is returned (SQLSTATE 42615).
- UOWTOTALTIME > integer-value DAY
| DAYS | HOUR | HOURS | MINUTE | MINUTES | SECONDS
- This condition defines an upper bound for the amount of time the
database manager will allow a unit of work to execute. This value
can be any non-zero positive integer (SQLSTATE 42820). Use a valid
duration keyword to specify an appropriate unit of time for integer-value.
If the specified time unit is SECONDS, the value must be a multiple
of 10 (SQLSTATE 42615). The definition domain for this condition must
be DATABASE, SERVICE SUPERCLASS, or WORKLOAD, and the enforcement
scope must be DATABASE (SQLSTATE 5U037). This
condition is enforced at the coordinator member.
The
maximum value that can be specified for this threshold is 2 147 483
640 seconds. If
any value (using the DAY, HOUR, MINUTE, or SECONDS time unit) has
a seconds equivalent larger than the maximum value, an error is returned
(SQLSTATE 42615).
- SQLTEMPSPACE > integer-value K
| M | G
- This condition defines the maximum amount of
system temporary space that can be consumed by an SQL statement on
a member. This
value can be any positive integer (not zero) (SQLSTATE 42820).
If integer-value
K (in either upper- or lowercase) is specified, the maximum
size is 1024 times integer-value. If integer-value
M is specified, the maximum size is 1 048 576
times integer-value. If integer-value
G is specified, the maximum size is 1 073 741 824
times integer-value.
The definition domain for this condition must
be DATABASE, work action (a threshold for a work action definition
domain is created using a CREATE WORK ACTION SET or ALTER WORK ACTION
SET statement, and the work action set must be applied to a workload
or a database), SERVICE SUPERCLASS, SERVICE SUBCLASS, or WORKLOAD,
and the enforcement scope must be MEMBER (SQLSTATE 5U037). Activities
tracked by this condition are:
- Coordinator activities of type DML and corresponding subagent
work (subsection execution).
- Nested DML activities that are derived from user logic and their
corresponding subagent work (subsection execution). Activities that
are initiated by the database manager through a utility, procedure,
or internal SQL are not affected by this condition.
- AGGSQLTEMPSPACE > integer-value K
| M | G
This condition defines the maximum amount of
system temporary space that can be consumed by a set of statements
in a service class on a member. This
value can be any positive integer (not zero) (SQLSTATE 42820).
If integer-value K
(in either upper- or lowercase) is specified, the maximum size is
1024 times integer-value. If integer-value M
is specified, the maximum size is 1 048 576 times integer-value.
If integer-value G is specified, the maximum size
is 1 073 741 824 times integer-value.
The definition domain for this condition must
be SERVICE SUBCLASS and the enforcement scope must be MEMBER (SQLSTATE
5U037).
Activities contributing to the aggregate that is tracked
by this condition are:
- Coordinator activities of type DML and corresponding subagent
work like subsection execution.
- Nested DML activities that are derived from user logic and their
corresponding subagent work like subsection execution. Activities
initiated by the database manager through a utility, procedure, or
internal SQL statement are not affected by this condition.
- SQLROWSREAD > bigint-value
- This condition defines an upper bound on the
number of rows that may be read by an activity during its lifetime
on a particular member. This
value can be any positive big integer (not zero) (SQLSTATE 42820). Note
that the number of rows read is different from the number of rows
returned, which is controlled by the SQLROWSRETURNED condition.
The definition domain for this condition
must be DATABASE, SERVICE CLASS, a service subclass (SERVICE CLASS
specifying the UNDER clause), WORKLOAD or a work action (a threshold
for a work action definition domain is created using a CREATE WORK
ACTION SET or ALTER WORK ACTION SET statement, and the work action
set must be applied to a workload or a database), and the enforcement
scope must be MEMBER (SQLSTATE 5U037). This condition is enforced
independently at each member.
Activities
tracked by this condition are:
- Coordinator activities of type DML and corresponding subagent
work (like subsection execution).
- Nested DML activities that are derived from user logic and their
corresponding subagent work (like subsection execution). Activities
that are initiated by the database manager through a utility or procedure
(with the exception of the ADMIN_CMD procedure) are not counted for
this condition.
- Internal SQL activities like those initiated by the setting of
a constraint, or the refreshing of a materialized query table, are
also not tracked by this threshold, because they are initiated by
the database manager and not directly invoked by user logic.
- CHECKING EVERY integer-value SECOND | SECONDS
- Specifies
how frequently the threshold condition is checked for an activity.
The threshold is checked at the end of each request (like a fetch
operation, for example) and on the interval defined by the CHECKING
clause. The CHECKING clause defines an upper bound on how long a threshold
violation may go undetected. The default is 60 seconds. The value
can be any positive integer (not zero) with a maximum value of 86400
seconds (SQLSTATE 42820). Setting a low value may impact system
performance negatively.
- SQLROWSREADINSC > bigint-value
- This condition defines an upper bound on the
number of rows that may be read by an activity on a particular member while
it is executing in a service subclass. Rows read before executing
in the service subclass specified are not counted. This value
can be any positive big integer (not zero) (SQLSTATE 42820). Note
that the number of rows read is different from the number of rows
returned, which is controlled by the SQLROWSRETURNED condition.
The definition domain for this condition must
be a service subclass (SERVICE CLASS specifying the UNDER clause)
and the enforcement scope must be MEMBER (SQLSTATE 5U037). This condition is enforced independently at
each member.
Activities
tracked by this condition are:
- Coordinator activities of type DML and corresponding subagent
work (like subsection execution).
- Nested DML activities that are derived from user logic and their
corresponding subagent work (like subsection execution). Activities
that are initiated by the database manager through a utility or procedure
(with the exception of the ADMIN_CMD procedure) are not counted for
this condition.
- Internal SQL activities like those initiated by the setting of
a constraint, or the refreshing of a materialized query table, are
also not tracked by this threshold, because they are initiated by
the database manager and not directly invoked by user logic.
- CHECKING EVERY integer-value SECOND | SECONDS
- Specifies
how frequently the threshold condition is checked for an activity.
The threshold is checked at the end of each request (like a fetch
operation, for example) and on the interval defined by the CHECKING
clause. The CHECKING clause defines an upper bound on how long a threshold
violation may go undetected. The default is 60 seconds. The value
can be any positive integer (not zero) with a maximum value of 86400
seconds (SQLSTATE 42820).Setting a low value may impact system
performance negatively.
- CPUTIME > integer-value HOUR
| HOURS | MINUTE | MINUTES | SECOND | SECONDS
- This condition defines an upper bound for the
amount of processor time that an activity may consume during its lifetime
on a particular member. The
processor time tracked by this threshold is measured from the time
that the activity starts executing. This value can be any positive
integer (not zero) (SQLSTATE 42820).
The definition domain for this condition
must be DATABASE, a service superclass (SERVICE CLASS), a service
subclass (SERVICE CLASS specifying the UNDER clause), WORKLOAD or
work action (a threshold for a work action definition domain is created
using a CREATE WORK ACTION SET or ALTER WORK ACTION SET statement,
and the work action set must be applied to a workload or a database),
and the enforcement scope must be MEMBER (SQLSTATE 5U037). This condition
is enforced independently at each member.
Activities
tracked by this condition are:
- Coordinator activities of type DML and corresponding subagent
work (like subsection execution).
- Nested DML activities that are derived from user logic and their
corresponding subagent work (like subsection execution). Activities
that are initiated by the database manager through a utility or procedure
(with the exception of the ADMIN_CMD procedure) are not counted for
this condition.
- Internal SQL activities, like those initiated by the setting of
a constraint or the refreshing of a materialized query table, are
also not tracked by this threshold, because they are initiated by
the database manager and not directly invoked by user logic.
- Activities of type CALL. For CALL activities, the processor time
tracked for the procedure does not include the processor time used
by any child activities or by any fenced mode processes. The threshold
condition will be checked only upon return from user logic to the
database engine. For example: During the execution of a trusted routine,
the threshold condition will be checked only when the routine issues
a request to the database engine).
- CHECKING EVERY integer-value SECOND | SECONDS
- Specifies
how frequently the threshold condition is checked for an activity.
The granularity of the CPUTIME threshold is approximately this number
multiplied by the degree of parallelism for the activity. For example:
If the threshold is checked every 60 seconds and the degree of parallelism
is 2, the activity might use an extra 2 minutes of processor time
instead of 1 minute before the threshold violation is detected. The
default is 60 seconds. The value can be any positive integer (not
zero) with a maximum value of 86400 seconds (SQLSTATE 42820). Setting
a low value may impact system performance negatively.
- CPUTIMEINSC > integer-value HOUR
| HOURS | MINUTE | MINUTES | SECOND | SECONDS
- This condition defines an upper bound for the
amount of processor time that an activity may consume on a particular member while
it is executing in a particular service subclass. The processor
time tracked by this threshold is measured from the time that the
activity starts executing in the service subclass identified in the
threshold domain. Any processor time used before that point is not
counted toward the limit imposed by this threshold. This value
can be any positive integer (not zero) (SQLSTATE 42820).
The definition domain for this condition must
be a service subclass (SERVICE CLASS specifying the UNDER clause),
and the enforcement scope must be MEMBER (SQLSTATE 5U037). This condition
is enforced independently at each member.
Activities
tracked by this condition are:
- Coordinator activities of type DML and corresponding subagent
work (like subsection execution).
- Nested DML activities that are derived from user logic and their
corresponding subagent work (like subsection execution). Activities
that are initiated by the database manager through a utility or procedure
(with the exception of the ADMIN_CMD procedure) are not counted for
this condition.
- Internal SQL activities, like those initiated by the setting of
a constraint or the refreshing of a materialized query table, are
also not tracked by this threshold, because they are initiated by
the database manager and not directly invoked by user logic.
- Activities of type CALL. For CALL activities, the processor time
tracked for the procedure does not include the processor time used
by any child activities or by any fenced mode processes. The threshold
condition will be checked only upon return from user logic to the
database engine. For example: During the execution of a trusted routine,
the threshold condition will be checked only when the routine issues
a request to the database engine).
- CHECKING EVERY integer-value SECOND | SECONDS
- Specifies
how frequently the threshold condition is checked for an activity.
The granularity of the CPUTIMEINSC threshold is approximately this
number multiplied by the degree of parallelism for the activity. For
example: If the threshold is checked every 60 seconds and the degree
of parallelism is 2, the activity might use an extra 2 minutes of
processor time instead of 1 minute before the threshold violation
is detected. The default is 60 seconds. The value can be any positive
integer (not zero) with a maximum value of 86400 seconds (SQLSTATE
42820). Setting a low value may impact system performance negatively.
- DATATAGINSC IN (integer-constant, ...)
- This condition defines one or more data tag values specified on
a table space that the activity touches. The data tag on a table space,
or its underlying storage group (where applicable), can be either
not be set or set to a value from 1 to 9. If the activity touches
a table space that has no data tag set (at either the table space
or the storage group level), this threshold will not have any affect
on that activity. The definition domain for this condition must be
a service subclass (SERVICE CLASS specifying the UNDER clause), and
the enforcement scope must be DATABASE PARTITION (SQLSTATE 5U037).
This condition is enforced independently at each database partition.
Activities
tracked by this condition are:
- Coordinator activities of type data manipulation language (DML).
- Nested DML activities that are directly invoked from user logic.
DML activities that can be initiated by the database manager
(such as utilities, procedures, or internal SQL) are not tracked by
this condition.
This threshold is checked only when a scan is
opened on a table or when an insert is performed into a table. Fetching
data from a table after a scan has been opened will not violate the
threshold.
- DATATAGINSC NOT IN (integer-constant, ...)
- This condition defines one or more data tag values not specified
on a table space that the activity touches. The data tag on a table
space, or its underlying storage group (where applicable), can be
either not be set or set to a value from 1 to 9. If the activity touches
a table space that has no data tag set (either at the table space
or the storage group level), this threshold will not have any affect
on that activity. The definition domain for this condition must be
a service subclass (SERVICE CLASS specifying the UNDER clause) and
the enforcement scope must be DATABASE PARTITION (SQLSTATE 5U037).
This condition is enforced independently at each database partition.
Activities
tracked by this condition are:
- Coordinator activities of type data manipulation language (DML).
- Nested DML activities that are directly invoked from user logic.
DML activities that can be initiated by the database manager
(such as utilities, procedures, or internal SQL) are not tracked by
this condition.
This threshold is checked only when a scan is
opened on a table or when an insert is performed into a table. Fetching
data from a table after a scan has been opened will not violate the
threshold.
DB2 10.5 for Linux, UNIX, and Windows
>>-CREATE THRESHOLD--threshold-name-----------------------------> >--FOR--| threshold-domain |--ACTIVITIES------------------------> .-ENABLE--. >--ENFORCEMENT--| enforcement-scope |--+---------+--------------> '-DISABLE-' >--WHEN--| threshold-predicate |--------------------------------> >--| threshold-exceeded-actions |------------------------------>< threshold-domain |--+-DATABASE---------------------------------------------------------+--| +-SERVICE CLASS--service-class-name--+---------------------------+-+ | '-UNDER--service-class-name-' | +-STATEMENT--+-TEXT----statement-text-------+----------------------+ | '-REFERENCE----executable-id---' | '-WORKLOAD--workload-name------------------------------------------' enforcement-scope |--+-DATABASE------------+--------------------------------------| +-MEMBER--------------+ '-WORKLOAD OCCURRENCE-' threshold-predicate |--+-TOTALMEMBERCONNECTIONS-->--integer-value---------------------------------------------------+--| | .-AND QUEUEDCONNECTIONS > 0---------------. | +-TOTALSCMEMBERCONNECTIONS-->--integer-value--+-----------------------------------------+----+ | +-AND QUEUEDCONNECTIONS-->--integer-value-+ | | '-AND QUEUEDCONNECTIONS UNBOUNDED---------' | +-CONNECTIONIDLETIME-->--integer-value--+-DAY-----+------------------------------------------+ | +-DAYS----+ | | +-HOUR----+ | | +-HOURS---+ | | +-MINUTE--+ | | '-MINUTES-' | +-CONCURRENTWORKLOADOCCURRENCES-->--integer-value--------------------------------------------+ +-CONCURRENTWORKLOADACTIVITIES-->--integer-value---------------------------------------------+ | .-AND QUEUEDACTIVITIES > 0---------------. | +-CONCURRENTDBCOORDACTIVITIES-->--integer-value--+----------------------------------------+--+ | +-AND QUEUEDACTIVITIES-->--integer-value-+ | | '-AND QUEUEDACTIVITIES UNBOUNDED---------' | +-ESTIMATEDSQLCOST-->--bigint-value----------------------------------------------------------+ +-SQLROWSRETURNED-->--integer-value----------------------------------------------------------+ +-ACTIVITYTOTALTIME-->--integer-value--+-DAY-----+-------------------------------------------+ | +-DAYS----+ | | +-HOUR----+ | | +-HOURS---+ | | +-MINUTE--+ | | +-MINUTES-+ | | '-SECONDS-' | +-UOWTOTALTIME-->--integer-value--+-DAY-----+------------------------------------------------+ | +-DAYS----+ | | +-HOUR----+ | | +-HOURS---+ | | +-MINUTE--+ | | +-MINUTES-+ | | '-SECONDS-' | +-SQLTEMPSPACE-->--integer-value--+-K-+------------------------------------------------------+ | +-M-+ | | '-G-' | +-AGGSQLTEMPSPACE-->--integer-value--+-K-+---------------------------------------------------+ | +-M-+ | | '-G-' | | .-CHECKING EVERY 60 SECONDS------------------. | +-SQLROWSREAD-->--bigint-value--+--------------------------------------------+---------------+ | '-CHECKING EVERY--integer-value--+-SECOND--+-' | | '-SECONDS-' | | .-CHECKING EVERY 60 SECONDS------------------. | +-SQLROWSREADINSC-->--bigint-value--+--------------------------------------------+-----------+ | '-CHECKING EVERY--integer-value--+-SECOND--+-' | | '-SECONDS-' | | .-CHECKING EVERY 60 SECONDS------------------. | +-CPUTIME-->--integer-value--+-HOUR----+--+--------------------------------------------+-----+ | +-HOURS---+ '-CHECKING EVERY--integer-value--+-SECOND--+-' | | +-MINUTE--+ '-SECONDS-' | | +-MINUTES-+ | | +-SECOND--+ | | '-SECONDS-' | | .-CHECKING EVERY 60 SECONDS------------------. | +-CPUTIMEINSC-->--integer-value--+-HOUR----+--+--------------------------------------------+-+ | +-HOURS---+ '-CHECKING EVERY--integer-value--+-SECOND--+-' | | +-MINUTE--+ '-SECONDS-' | | +-MINUTES-+ | | +-SECOND--+ | | '-SECONDS-' | | .-,----------------. | | (1) V | | '-------DATATAGINSC--+-IN-----+--(----integer-constant-+--)----------------------------------' '-NOT IN-' threshold-exceeded-actions .-COLLECT ACTIVITY DATA--NONE---------------------------. |--+-------------------------------------------------------+----> | .-MEMBER-. | | .-ON COORDINATOR--+--------+-. | '-COLLECT ACTIVITY DATA--+----------------------------+-' | .-MEMBERS-. | '-ON ALL--+---------+--------' .-WITHOUT DETAILS---------------------------. >--+-------------------------------------------+--+-STOP EXECUTION------------+--| | .-,---------------. | +-CONTINUE------------------+ | V (2) | | +-FORCE APPLICATION---------+ '-WITH----+-DETAILS-----+-+--+------------+-' '-| remap-activity-action |-' '-SECTION-----' '-AND VALUES-' remap-activity-action |--REMAP ACTIVITY TO--service-subclass-name---------------------> .-NO EVENT MONITOR RECORD--. >--+--------------------------+---------------------------------| '-LOG EVENT MONITOR RECORD-'