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.