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 *EXECUTE authority to the QSYS2/LIM_ALERTS program.

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')