By default, the runtime statistics are turned off. When the
runtimestatistics attribute is turned on,
maintains information
about the execution plan for each statement executed within the connection
(except for COMMIT) until the attribute is turned off. To turn the
runtimestatistics attribute off, call the procedure with an
argument of zero. To turn the runtimestatistics on, call the
procedure with any non-zero argument.
For statements that do not return rows, the object is created
when all internal processing has completed before returning to the client
program. For statements that return rows, the object is created when the first next() call
returns 0 rows or if a close() call is encountered, whichever
comes first.
Syntax SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(IN SMALLINT ENABLE)
Execute privileges
By default, all users have execute privileges on this procedure.
Example -- establish a connection
-- turn on RUNTIMESTATISTIC for connection:
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
-- execute complex query here
-- step through the result sets
-- access runtime statistics information:
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);