GRA views and reporting

_v_sched_gra_ext and _v_sched_sn_ext

These views display information about how busy the system is and how GRA and snippet resources are being allocated and used by the recent jobs on the system. After each report interval, the system adds a row for each active group with its resource compliance totals for that period. If a group is not active, the system does not create a row for that group. For a system with few resource groups, the _v_sched_gra_ext view typically contains records for about a week of activity, and the _v_sched_sn_ext view typically contains a few hours of data. These views are reset when the system stops and restarts.

Note: The deprecated _v_sched_gra view is still provided for compatibility reasons. However, the _v_sched_gra_ext view contains more information, such as the maximum resource allocations and job limit information, and should be used whenever possible.

_v_gra_sched_ext_latest and _v_sched_sn_ext_latest

These views display information about the previous 10-minute update of scheduling information.

Note: The deprecated _v_sched_gra_latest view is still provided for compatibility reasons. However, the _v_gra_sched_ext_latest view contains more information, such as the maximum resource allocations and job limit information, and should be used whenever possible.

_v_plan_resource

This view shows resource usage over time to assist with WLM troubleshooting and capacity planning. It keeps at least 2000 records of query plan activity.

_v_system_util

This view shows system utilization for certain resources such as host and SPU CPU, disk, memory, and fabric (communication) resources. The displayed values are normalized between 0 (no utilization) and 1 (full utilization).

_v_sched_sys

This view shows information about the numbers of queued and running plans and about resource availability and usage for the host and SPUs.

• _v_sched_gra_ext
• _v_sched_sn_ext
• _v_system_util
• _v_sched_sys

SELECT * FROM viewname;