>>-WLM_COLLECT_STATS--(--+-------------------------------+--)-->< '-wait--,--statistics_timestamp-'
The schema is SYSPROC.
None
CALL WLM_COLLECT_STATS()
Return Status = 0
CALL WLM_COLLECT_STATS('Y', ::collect_timestamp)
Return Status = 0
CALL WLM_COLLECT_STATS()
SQL1632W The collect and reset statistics request was ignored because
another collect and reset statistics request is already in progress.
The WLM_COLLECT_STATS procedure performs the same collection operation (send statistics to the active statistics event monitor) and reset operation that occur automatically on the interval defined by the wlm_collect_int database configuration parameter.
If you call the procedure while another collection and reset request is in progress (for example, while another invocation of the procedure is running or automatic collection is occurring), SQL1632W with SQLSTATE 01H53 is returned, and your new request is ignored.
In asynchronous mode, the WLM_COLLECT_STATS procedure only starts the collection and reset process. The procedure might return to the caller before all statistics have been written to the active statistics event monitor. Depending on how quickly the statistics collection and reset occur, the call to the WLM_COLLECT_STATS procedure (which is itself an activity) is counted in the statistics for either the prior collection interval or the new collection interval that has just started.
In synchronous mode, the WLM_COLLECT_STATS procedure does not return until the statistics collection is complete and all statistics are written to the tables of any active statistics event monitors. The timestamp at which the statistics collection began is returned via the statistics_timestamp output parameter.