When runninga collection SQL from Toad SQL Analysis, the following error appears:
SQC70323W: Statement parse failed (rc=70015) for SELECT THRESHOLD_PREDICATE, THRESHOLD_DOMAIN, THRESHOLD_NAME, THRESHOLD_ID, DBPARTITIONNUM, SERVICE_SUPERCLASS_NAME, SERVICE_SUBCLASS_NAME, WORK_ACTION_SET_NAME, WORK_CLASS_NAME, WORKLOAD_NAME, LAST_RESET, QUEUE_SIZE_TOP, QUEUE_TIME_TOTAL, QUEUE_ASSIGNMENTS_TOTAL, QUEUE_SIZE_CURRENT, QUEUE_TIME_LATEST, QUEUE_EXIT_TIME_LATEST, THRESHOLD_CURRENT_CONCURRENCY, THRESHOLD_MAX_CONCURRENCY FROM TABLE(WLM_GET_QUEUE_STATS(CAST(NULL AS VARCHAR(27)), CAST(NULL AS VARCHAR(18)), CAST(NULL AS VARCHAR(128)), -1)) UNION ALL SELECT DISTINCT -2 AS THRESHOLD_PREDICATE, -2 AS THRESHOLD_DOMAIN, THRESHOLD_NAME, -2 AS THRESHOLD_ID, -2 AS DBPARTITIONNUM, -2 AS SERVICE_SUPERCLASS_NAME, -2 AS SERVICE_SUBCLASS_NAME, -2 AS WORK_ACTION_SET_NAME, -2 AS WORK_CLASS_NAME, -2 AS WORKLOAD_NAME, CAST(NULL AS TIMESTAMP) AS LAST_RESET, -2 AS QUEUE_SIZE_TOP, -2 AS QUEUE_TIME_TOTAL, -2 AS QUEUE_ASSIGNMENTS_TOTAL, -2 AS QUEUE_SIZE_CURRENT, -2 AS QUEUE_TIME_LATEST, CAST(NULL AS TIMESTAMP) AS QUEUE_EXIT_TIME_LATEST, -2 AS THRESHOLD_CURRENT_CONCURRENCY, -2 AS THRESHOLD_MAX_CONCURRENCY FROM TABLE(WLM_GET_QUEUE_STATS(CAST(NULL AS VARCHAR(27)), CAST(NULL AS VARCHAR(18)), CAST(NULL AS VARCHAR(128)), -1))ORDER BY DBPARTITIONNUM FOR FETCH ONLY WITH UR.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center