Neoview Workload Management Services Guide (R2.4)
Table B-3 WMS Commands With New Output Columns (continued)
New Output ColumnsWMS Command
• QUERY_SUBSTATE
• EST_TOTAL_MEM
• CMP_AFFINITY_NUM
• CMP_DOP
• CMP_TXN_NEEDED
• CMP_MANDATORY_X_PROD
• CMP_MISSING_STATS
• CMP_NUM_JOINS
• CMP_FULL_SCAN_ON_TABLE
• CMP_HIGH_DP2_MAX_BUF_USAGE
• CMP_ROWS_ACCESSED_FULL_SCAN
• CMP_DP2_ROWS_ACCESSED
• CMP_DP2_ROWS_USED
• WARN_LEVEL
For a complete list of returned columns, see Table A-11 (page 128).
STATUS QUERY and STATUS
QUERIES
• QUERY_SUBSTATE
• TOTAL_MEM_ALLOC
For a complete list of returned columns, see Table A-11 (page 128).
STATUS QUERY ALL STATS and
STATUS QUERIES ALL STATS
• CUR_SCHEMA
• RULE_NAME
• APPL_NAME
• SESSION_NAME
• DSN_NAME
• ROLE_NAME
For more information, see the Neoview SQL Reference Manual.
GET SERVICE
158 New and Changed Information