Default workloads

The default user workload SYSDEFAULTUSERWORKLOAD provides a workload for your data server to which all connections are assigned initially. The default administration workload SYSDEFAULTADMWORKLOAD permits you to take corrective administrative action that cannot otherwise be performed. Both workloads are created at database creation time and you cannot drop them.

The default user workload (SYSDEFAULTUSERWORKLOAD)

Connections that are assigned to the default user workload are mapped to the default user service superclass SYSDEFAULTUSERCLASS, which provides the default execution environment. You can map connections to user-defined service classes by creating user defined workloads. In addition, you can alter SYSDEFAULTUSERWORKLOAD so that it maps connections to a different service class than SYSDEFAULTUSERCLASS.

You can view the SYSDEFAULTUSERWORKLOAD workload by querying the SYSCAT.WORKLOADS table.

The following table shows the columns returned for the SYSDEFAULTUSERWORKLOAD workload in the SYSCAT.WORKLOADS view, along with values and whether you can modify these values. See Workload assignment for information on how to assign a connection to the SYSDEFAULTUSERWORKLOAD workload.

Table 1. SYSDEFAULTUSERWORKLOAD entry in SYSCAT.WORKLOADS
Column	Value	Modifiable using the ALTER WORKLOAD statement if you have DBADM or WLMADM authority (and SQLADM for COLLECT clauses)
WORKLOADID	1	No
WORKLOADNAME	SYSDEFAULTUSERWORKLOAD	No
EVALUATIONORDER	Second last one	No
CREATE_TIME	Timestamp of database creation	No
ALTER_TIME	Timestamp of the last update of the workload definition	No (but the data server modifies this column when you update the workload definition)
ENABLED	Y	No
ALLOWACCESS	Y	Yes
SERVICECLASSNAME	SYSDEFAULTSUBCLASS	Yes
PARENTSERVICECLASSNAME	SYSDEFAULTUSERCLASS	Yes
COLLECTAGGACTDATA	N	Yes
COLLECTACTDATA	N	Yes
COLLECTACTPARTITION	C	Yes
COLLECTDEADLOCK	W	Yes
COLLECTLOCKTIMEOUT	W	Yes
COLLECTLOCKWAIT	N	Yes
LOCKWAITVALUE	0	Yes
COLLECTACTMETRICS	N	Yes
COLLECTUOWDATA	N	Yes
EXTERNALNAME	NULL	No
REMARKS	BLANK	Yes

For more information, see SYSCAT.WORKLOADS.

The default administration workload (SYSDEFAULTADMWORKLOAD)

This workload permits ACCESSCTRL, DATAACCESS, DBADM, SECADM, or WLMADM users to query the database and perform administrative or monitoring tasks at any time, but is typically used in cases when:

The workload to which the administrator is assigned is not permitted to access the database (that is, the DISALLOW DB ACCESS keyword of the CREATE WORKLOAD or ALTER WORKLOAD statement was specified for the workload).
A threshold was violated, preventing the administrator from performing work on the database.

The SYSDEFAULTADMWORKLOAD workload differs from other workloads in the following ways:

You cannot drop or disable it.
You cannot specify DISALLOW DB ACCESS for it.
None of the thresholds apply to occurrences of this workload and the activities in it.
You can run this workload only in the SYSDEFAULTUSERCLASS service superclass. See Default service superclasses and subclasses for more information.
You can assign a connection to this workload by using the SET WORKLOAD command from the CLP interface, or by invoking the WLM_SET_CLIENT_INFO stored procedure (and specifying SYSDEFAULTADMWORKLOAD for the client_workload parameter). For more information, see Taking corrective action using the default administration workload.

You can view the SYSDEFAULTADMWORKLOAD workload by querying the SYSCAT.WORKLOADS table. The following table shows the columns returned for the SYSDEFAULTADMWORKLOAD workload in the SYSCAT.WORKLOADS catalog view, along with values and whether you can modify these values:

Table 2. SYSDEFAULTADMWORKLOAD entry in SYSCAT.WORKLOADS
Column	Value	Modifiable using the ALTER WORKLOAD statement if you have DBADM or WLMADM authority (and SQLADM for COLLECT clauses)
WORKLOADID	2	No
WORKLOADNAME	SYSDEFAULTADMWORKLOAD	No
EVALUATIONORDER	Last one	No
CREATE_TIME	Timestamp of database creation	No
ALTER_TIME	Timestamp of the last update of the workload definition	No (but the data server modifies this column when you update the workload definition)
ENABLED	Y	No
ALLOWACCESS	Y	No
SERVICECLASSNAME	SYSDEFAULTSUBCLASS	No
PARENTSERVICECLASSNAME	SYSDEFAULTUSERCLASS	No
COLLECTAGGACTDATA	N	Yes
COLLECTACTDATA	N	Yes
COLLECTACTPARTITION	C	Yes
COLLECTDEADLOCK	W	Yes
COLLECTLOCKTIMEOUT	W	Yes
COLLECTLOCKWAIT	N	Yes
LOCKWAITVALUE	0	Yes
COLLECTACTMETRICS	N	Yes
COLLECTUOWDATA	N	Yes
EXTERNALNAME	NULL	No
REMARKS	BLANK	Yes

For more information, see SYSCAT.WORKLOADS.

Note:

When the Db2 console is started or restarted, the default settings or user-defined settings for the SYSDEFAULTUSERWORKLOAD and SYSDEFAULTADMWORKLOAD workloads are changed as follows:

Table 3. Changes for SYSDEFAULTUSERWORKLOAD
COLLECTACTDATA set by Db2 default	COLLECTACTDATA set by console
N	D

Table 4. Changes for SYSDEFAULTADMWORKLOAD
COLLECTAGGACTDATA set by Db2 default	COLLECTAGGACTDATA set by console
N	B

For Db2 systems that are monitored by DSM or DMC, the workload settings depend on the configuration of activity event monitors as described in Monitoring events.

If you create your own activity event monitors, consider that they collect data for the SYSDEFAULTUSERWORKLOAD and SYSDEFAULTADMWORKLOAD workloads, and for the console-specific DSM_WORKLOAD workload.