Neoview Workload Management Services Guide (R2.5)

List of Tables
1 Cancellation of Queries in Neoview Release 2.4 and 2.5..............................................................14
3-1 Typical Query Workloads in an Enterprise Data Warehouse.......................................................43
3-2 Criteria for Defining Query Workloads........................................................................................44
3-3 Tools for Monitoring Query Performance and System Resource Usage......................................44
4-1 Predefined HPS Services and Rules..............................................................................................47
4-2 WMS System Thresholds...............................................................................................................50
4-3 How an Altered Service Attribute Affects Queries Associated With the Service.........................62
4-4 Conversion of the WMS Configuration to WMS Commands.......................................................65
5-1 Connection Attributes in a Client Application.............................................................................72
6-1 Effect of the Hold Operation.......................................................................................................143
6-2 Effect of the Release Operation...................................................................................................144
6-3 Effect of the Cancel Operation.....................................................................................................145
A-1 WMS Commands.........................................................................................................................171
A-2 INFO RULE Output.....................................................................................................................214
A-3 INFO RULE COMP Output.........................................................................................................216
A-4 INFO RULE CONN Output........................................................................................................217
A-5 INFO RULE EXEC Output..........................................................................................................218
A-6 INFO SERVICE Output...............................................................................................................219
A-7 INFO SERVICE COMP Output...................................................................................................221
A-8 INFO SERVICE EXEC Output.....................................................................................................222
A-9 INFO WMS Output.....................................................................................................................223
A-10 INFO WMS CONN Output.........................................................................................................224
A-11 STATUS ADMIN Output.............................................................................................................228
A-12 Query Compile-Time Statistics....................................................................................................230
A-13 Query Warning Information........................................................................................................232
A-14 Query Runtime Statistics.............................................................................................................233
A-15 Total Number of Executing Queries in Various States................................................................236
A-16 STATUS QUERY With PLAN Output.........................................................................................238
A-17 STATUS QUERY With TEXT Output..........................................................................................238
A-18 STATUS RULE Output................................................................................................................240
A-19 STATUS RULE COMP Output....................................................................................................242
A-20 STATUS RULE CONN Output....................................................................................................243
A-21 STATUS RULE EXEC Output......................................................................................................244
A-22 STATUS SERVICE Output...........................................................................................................245
A-23 STATUS SERVICE COMP Output...............................................................................................247
A-24 STATUS SERVICE EXEC Output.................................................................................................248
A-25 STATUS SERVICE RULE Output................................................................................................249
A-26 STATUS SERVICE SEGMENT STATS Output.............................................................................250
A-27 STATUS WMS Output.................................................................................................................252
A-28 STATUS WMS CONN Output.....................................................................................................254
A-29 STATUS WMS DETAIL Command Output.................................................................................255
A-30 STATUS WMS SEGMENT STATS Output...................................................................................256
A-31 STATUS WMS VERSION Output................................................................................................258
A-32 VERSION_INFO Column String Output....................................................................................258
B-1 Query Types Managed by WMS.................................................................................................261
C-1 Query States and Substates.........................................................................................................263
12 List of Tables