Improved table functions provide direct access to WLM statistics

The addition of several monitor elements to the MON_GET_SERVICE_SUBCLASS_STATS and MON_GET_WORKLOAD_STATS table functions allows you to use the table functions to access all WLM statistics through a table function interface, rather than having to create an event monitor. This improves the consistency of monitor data reported between the statistics event monitor and WLM statistics table functions.

The enhanced table functions now report information that was previously available only in the statistics event monitor tables. The elements added to the statistics table functions include:

• CPU_ENTITLEMENT
• CPU_SHARE_TYPE
• ACT_CPU_TIME_TOP
• ACT_ROWS_READ_TOP
• COORD_ACT_EST_COST_AVG
• COORD_ACT_EST_COST_STDDEV
• COORD_ACT_INTERARRIVAL_TIME_AVG
• COORD_ACT_INTERARRIVAL_TIME_STDDEV
• COST_ESTIMATE_TOP
• ROWS_RETURNED_TOP
• TEMP_TABLESPACE_TOP
• AGG_TEMP_TABLESPACE_TOP
• CONCURRENT_CONNECTION_TOP