Start of change

PROCESS_SYSTEM_LIMITS_ALERTS procedure

The QSYS2.PROCESS_SYSTEM_LIMITS_ALERTS procedure can be called directly to look for any tracked limits that have exceeded their alerting level in the last 24 hours. If any are identified, an alert will be signaled. Calling it repeatedly can send duplicate alerts.

This procedure performs the same checks that are done by the system processing of the alerts. If a limit has reached its alerting level, message SQL7062 is sent to the QSYSOPR message queue. See System limit alerts for details.

This procedure can be submitted in a job to be run at a user-determined time to look for runaway situations.

Authorization: This procedure, implemented by the QSYS2/LIM_ALERTS program, is shipped with *PUBLIC *EXCLUDE authority.

To call this procedure the user must have *OBJOPR and *EXECUTE authorities to the QSYS2/LIM_ALERTS program.

Read syntax diagramSkip visual syntax diagramPROCESS_SYSTEM_LIMITS_ALERTS()

The schema is QSYS2.

Example

To schedule a job that will run every weekday at noon to report system limits that have reached their reporting threshold values in the last 24 hours, the following CL command can be run.
ADDJOBSCDE JOB(CHKALERT) 
CMD(RUNSQL SQL('CALL QSYS2.PROCESS_SYSTEM_LIMITS_ALERTS()') COMMIT(*NONE) )
FRQ(*WEEKLY) SCDDATE(*NONE) 
SCDDAY(*MON *TUE *WED *THU *FRI ) SCDTIME('12:00:00')
End of change