MON_INCREMENT_INTERVAL_ID procedure - increment the monitoring interval
The MON_INCREMENT_INTERVAL_ID procedure increments the monitoring interval by 1 and returns the new value in the output argument.
The current monitoring interval is indicated by the MON_INTERVAL_ID database global variable.
Authorization
One
of the following authorities is required to execute the routine:
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
None
Syntax
The schema is SYSPROC.Procedure parameters
- new_id
- An output argument of type BIGINT that returns the new monitoring interval.
Usage notes
As an autonomous procedure, MON_INCREMENT_INTERVAL_ID executes in its own transaction scope.
When the value of MON_INTERVAL_ID reaches the maximum BIGINT value, it is cycled back to 1.
Example
To increment the interval ID and
return the new value in the argument. This example assumes that MY_ID is
a previously created session global variable.
CALL SYSPROC.MON_INCREMENT_INTERVAL_ID(MY_ID)