Each row represents a work action that is defined for a
work action set.
Table 1. SYSCAT.WORKACTIONS Catalog View
| Column Name |
Data Type |
Nullable |
Description |
| ACTIONNAME |
VARCHAR (128) |
|
Name of the work action. |
| ACTIONID |
INTEGER |
|
Identifier for the work action. |
| ACTIONSETNAME |
VARCHAR (128) |
Y |
Name of the work action set. |
| ACTIONSETID |
INTEGER |
|
Identifier of the work action set to which this work action
belongs. This column refers to the ACTIONSETID column in the SYSCAT.WORKACTIONSETS
view. |
| WORKCLASSNAME |
VARCHAR (128) |
Y |
Name of the work class. |
| WORKCLASSID |
INTEGER |
|
Identifier of the work class. This column refers to the WORKCLASSID
column in the SYSCAT.WORKCLASSES view. |
| CREATE_TIME |
TIMESTAMP |
|
Time at which the work action was created. |
| ALTER_TIME |
TIMESTAMP |
|
Time at which the work action was last altered. |
| ENABLED |
CHAR (1) |
|
- N = This work action is disabled.
- Y = This work action is enabled.
|
| ACTIONTYPE |
CHAR (1) |
|
The type of
action performed on each Db2® activity that matches the
attributes in the work class within scope.
- B = Collect basic aggregate activity data, specifiable only for work action sets that apply to
service classes or workloads.
- C = Allow any Db2 activity under the associated work class to
execute and increment the work class counter.
- D = Collect activity data with details at the coordinating member of the activity.
- E = Collect extended aggregate activity data, specifiable only for work action sets that apply
to service classes or workloads.
- F = Collect activity data with details, section, and values at the coordinating member of the
activity.
- G = Collect activity details and section at the coordinating member of the activity and collect
activity data at all members.
- H = Collect activity details, section, and values at the coordinating member of the activity and
collect activity data at all members.
- M = Map to a service subclass, specifiable only for work action sets that apply to service
classes.
- P = Prevent the execution of any Db2 activity under the work class with which this
work action is associated.
- S = Collect activity data with details and section at the coordinating member of the
activity.
- T = The action represents a threshold, specifiable only for work action sets that are associated
with a database or a workload.
- U = Map all activities with a nesting level of zero and all activities nested under these
activities to a service subclass, specifiable only for work action sets that apply to service
classes.
- V = Collect activity data with details and values at the coordinating member.
- W = Collect activity data without details at the coordinating member.
- X = Collect activity data with details at the coordinating member and collect activity data at
all members.
- Y = Collect activity data with details and values at the coordinating member and collect
activity data at all members.
- Z = Collect activity data without details at all members.
|
| REFOBJECTID |
INTEGER |
Y |
If ACTIONTYPE is 'M' (map) or
'N' (map nested), this value is set to the ID of the service subclass to which the Db2 activity is mapped. If ACTIONTYPE is 'T'
(threshold), this value is set to the ID of the threshold to be used. For all other actions, this
value is NULL. |
| REFOBJECTTYPE |
VARCHAR (30) |
|
If the ACTIONTYPE is 'M' or 'N', this value is set to 'SERVICE
CLASS'; if the ACTIONTYPE is 'T', this value is 'THRESHOLD'; the null
value otherwise. |
| SECTIONACTUALSOPTIONS |
VARCHAR (32) |
|
Specifies what section actuals are collected during the execution
of a section. The first position
in the string represents whether the collection of section actuals
is enabled.
- B = Enabled and collect basic operator cardinality counts and
statistics for each object referenced by the section (DML statements
only).
- N = Not enabled.
The second position is always 'N' and reserved for for future
use. |