Skip to main contentIBM dmctop Wiki

Throughput / Workload Assignment

Purpose

Work assignment view shows what workload each connection is mapped to, and the client info fields. This is useful for debugging connections that are not being mapped as expected. This view also shows some WLM specific metrics related to connections.

The primary fields shown are the application handle (identifies the connection), the workload it is currently mapped to and the connection attributes (aka client info fields) for the connection.

Screenshot

image

Metrics Shown

Application handle

A system-wide unique ID for the application.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).APPLICATION_HANDLE

Event state

State of the event last processed by this agent. The possible values are as follows:

  • EXECUTING
  • IDLE

Source: MON_GET_AGENT(NULL,NULL,NULL,#MEMBER#).EVENT_STATE

Event type

Type of event last processed by this agent. The possible values are as follows:

  • ACQUIRE
  • PROCESS
  • WAIT

Source: MON_GET_AGENT(NULL,NULL,NULL,#MEMBER#).EVENT_TYPE

Event object

Object of the event last processed by this agent. The possible values are as follows:

  • COMPRESSION_DICTIONARY_BUILD
  • IMPLICIT_REBIND
  • INDEX_RECREATE
  • LOCK
  • LOCK_ESCALATION
  • QP_QUEUE
  • REMOTE_REQUEST
  • REQUEST
  • ROUTINE
  • WLM_QUEUE

Source: MON_GET_AGENT(NULL,NULL,NULL,#MEMBER#).EVENT_OBJECT

Workload name

Name of the workload.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES.WORKLOAD_NAME

User ID

The system authorization id for the connection.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).SYSTEM_AUTH_ID

Session user ID

The current authorization ID for the session being used by this application.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).SESSION_AUTH_ID

Client workstation

Client workstation name

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).CLIENT_WRKSTNNAME

Client accounting string

The data passed to the target database for logging and diagnostic purposes.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).CLIENT_ACCTNG

Client user ID

Current value of the CLIENT_USERID special register for this workload occurrence.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).CLIENT_USER

Client application name

Identifies the server transaction program performing the transaction.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).CLIENT_APPLNAME

Role ID

All rolename’s where the GRANTEE matches WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES.SYSTEM_AUTH_ID and present them as a comma separated list.

Source:

SYSCAT.ROLEAUTH.ROLENAME

SYSCAT.ROLEAUTH.GRANTEE

WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).SYSTEM_AUTH_ID

Group ID

The group for the connection.

Source: AUTH_LIST_GROUPS_FOR_AUTHID(SYSTEM_AUTH_ID).GROUP

Activities completed

The total number of coordinator activities that completed successfully.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).SUM(ACT_COMPLETED_TOTAL)

Wlm queue assignment

The total number of times that activities or connections have been queued by a WLM threshold.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).SUM(WLM_QUEUE_ASSIGNMENTS_TOTAL)

Threshold violations

The total number of times a threshold was violated.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).SUM(THRESH_VIOLATIONS)

Activities aborted

The total number of coordinator activities that completed with errors.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).SUM(ACT_ABORTED_TOTAL)

Activities rejected

The total number of coordinator activities that were rejected instead of being allowed to execute.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).SUM(ACT_REJECTED_TOTAL)

Recent sql

It takes long time to get all the sql text, so it only returns - currently.

Address

The IP address from which the activity connection was initiated.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).ADDRESS

Internal application

Indicates whether the application is a system application.

SELECT CASE 
          WHEN IS_SYSTEM_APPL = 0 THEN VARCHAR('NO', 3) 
          ELSE                         VARCHAR('YES', 3) 
       END AS INTERNAL_APPL
FROM   TABLE(MON_GET_AGENT(NULL,NULL,NULL,#MEMBER#)

Source: MON_GET_AGENT(NULL,NULL,NULL,#MEMBER#).IS_SYSTEM_APPL

Coordinator member

Coordinating member for an application.

Source: WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES(”, ”, #MEMBER#).COORD_MEMBER

Connection start time

The time at which the connection was established with the database server.

Source: MON_GET_CONNECTION(NULL, #MEMBER#, 1).MIN(CONNECTION_START_TIME)

Previous
Throughput: Workloads
Next
Throughput: Service classes