SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING procedure
Derby Reference Manual
176
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);
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure
Statistics timing is an attribute associated with a connection that you turn on and off
by using the
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING
system procedure.
Statistics timing is turned off by default. Turn statistics timing on only when the
runtimestatistics
attribute is already on. Turning statistics timing on when the
runtimestatistics
attribute is off has no effect.
Turn statistics timing on by calling this procedure with a non-zero argument. Turn
statistics timing off by calling the procedure with a zero argument.
When statistics timing is turned on, Derby tracks the timings of various aspects of the
execution of a statement. This information is included in the information returned by the
system function. When statistics
timing is turned off, the
system
function shows all timing values as zero.
Syntax
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(IN SMALLINT ENABLE)
Execute privileges
By default, all users have execute privileges on this procedure.
Example
To turn the
runtimestatistics
attribute and then the statistics timing attribute on:
CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);
SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure
The
SYSCS_UTIL.SYSCS_SET_USER_ACCESS
system procedure sets the connection
access permission for the user specified.
Syntax
SYSCS_UTIL.SYSCS_SET_USER_ACCESS (USERNAME VARCHAR(128),
CONNECTION_PERMISSION VARCHAR(128))
USERNAME
An input argument of type VARCHAR(128) that specifies the user ID in the Derby
database.
CONNECTION_PERMISSION
Valid values for CONNECTION_PERMISSION are:
