Workload objectives
You can use these views to see how well
workloads are meeting their defined response time objectives.
The following table lists the views available for workloads. Many of these views can be accessed from the easy menu EZDTHD, shown in Active-threads.
View name | Type | Description |
|---|---|---|
DOBJ | Tabular | Objectives Review–Interval Shows a workload’s thread performance for each target Db2 subsystem for the current interval |
DOBJAPZ | Summary | Objective Summary by Application Summarizes the average response and CPU times by the workloads in the defined application or composite workloads |
DOBJCPU | Tabular | Interval CPU Objectives Review Shows data about the CPU time objectives for the current workload interval |
DOBJCPUR | Tabular | Realtime CPU Objectives Review Shows data about the CPU time objectives for the current real-time period |
DOBJCPUS | Tabular | Session CPU Objectives Review Shows data about the CPU time objectives for the current session since the Db2 subsystem started |
DOBJPRT | Tabular | Wrkld Obj Resp–10 Intvls Shows workload response time values for the 10 most recent intervals for a quick trend overview |
DOBJPRTC | Tabular | Wrkld Obj Resp/Cnts–10 Intvls Shows workload response time and thread count values for the 10 most recent intervals for a quick trend overview |
DOBJPTC | Tabular | Wrkld Obj Counts Shows workload data for the 10 most recent intervals and the accumulated data for the current period |
DOBJPTRS | Tabular | Wrkld Obj Tran Rate–sec Shows workload data for the 10 most recent intervals and the accumulated data for the current period |
DOBJR | Tabular | Objectives Review–Real Time Shows a workload’s thread performance for each target Db2 subsystem for the current real-time period |
DOBJRZ | Summary | Objective Summary–Real Time Summarizes workload performance across all Db2 subsystems in the current context for the current real-time period |
DOBJS | Tabular | Objectives Review–Session Shows a workload’s thread performance for each target Db2 subsystem for the current session since Db2 was started |
DOBJSZ | Summary | Objective Summary–Session Summarizes workload performance across all Db2 subsystems in the current context for the current session since Db2 was started |
DOBJZ | Summary | Objective Summary–Interval Summarizes workload performance across all Db2 subsystems in the current context for the current interval |