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