When we query MON_GET_PKG_CACHE_STMT with an order by clause
error SQL1773N is encountered. Without the orderby the query
works fine. ROS on Standby enabled.
$ db2 "select SUBSTR(STMT_TEXT,1,70) AS STMT, SECTION_TYPE AS
TYPE,NUM_EXECUTIONS from TABLE(MON_GET_PKG_CACHE_STMT ( 'D',
NULL, NULL, -2))"
STMT
TYPE NUM_EXECUTIONS
----------------------------------------------------------------
------ ---- --------------------
select current CLIENT_APPLNAME, current CLIENT_ACCTNG from
sysibm.sysd D 1
select SUBSTR(STMT_TEXT,1,70) AS STMT, SECTION_TYPE AS
TYPE,NUM_EXECU D 0
Select PREP_TIME_WORST ,NUM_EXECUTIONS ,STMT_SORTS
,TOTAL_EXEC_TIME D 1
select * from TABLE(MON_GET_PKG_CACHE_STMT ( 'D', NULL, NULL,
-2)) D 1
select * from TABLE(MON_GET_PKG_CACHE_STMT ( 'D', NULL, NULL,
-2)) ord D 1
Select PREP_TIME_WORST ,NUM_EXECUTIONS ,STMT_SORTS
,TOTAL_EXEC_TIME D 1
6 record(s) selected.
$ db2 "select SUBSTR(STMT_TEXT,1,70) AS STMT, SECTION_TYPE AS
TYPE,NUM_EXECUTIONS from TABLE(MON_GET_PKG_CACHE_STMT ( 'D',
NULL, NULL, -2)) order by TOTAL_ACT_TIME desc"
STMT
TYPE NUM_EXECUTIONS
----------------------------------------------------------------
------ ---- --------------------
SQL1773N The statement or command failed because it requires
functionality
that is not supported on a read-enabled HADR standby database.
Reason code =
"5". |
