Updated on 2025-05-29 GMT+08:00

WLM_WORKLOAD_HISTORY_INFO

WLM_WORKLOAD_HISTORY_INFO displays information about workload management after a job is complete or the exception has been handled, as described in Table 1.

Table 1 WLM_WORKLOAD_HISTORY_INFO columns

Name

Type

Description

statement

text

Statement executed for exception handling.

block_time

bigint

Block time before the statement is executed.

elapsed_time

bigint

Elapsed time when the statement is executed.

total_cpu_time

bigint

Total time used by the CPU on the DN when the statement is executed for exception handling.

qualification_time

bigint

Period when the statement checks the skew.

cpu_skew_percent

integer

CPU usage skew on the DN when the statement is executed for exception handling.

control_group

text

Cgroup used when the statement is executed for exception handling.

status

text

Statement status after statement are executed for exception handling, including:
  • pending: waiting to be executed.
  • running: being executed.
  • finished: finished normally.
  • abort: terminated unexpectedly.

action

text

Actions when statements are executed for exception handling, including:
  • abort: terminating the operation.
  • adjust: executing the Cgroup adjustment operations. Currently, you can only perform the demotion operation.
  • finish: finished normally.