ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

QSYSMSG Message Queue

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • QSYSMSG Message Queue

    We've got a QSYSMSG message queue created, which we monitor with the idea being that we'll be notified of serious system issues (IBM says: "QSYSMSG is a queue that you can create if you plan to handle the list of serious messages that are sent to the queue.").

    Unfortunately, certain serious messages may or may not be sent to QSYSMSG, apparently depending on the SRC code involved (which is weird because the SRC isn't part of the message). Anyway, we received a CPPEA02 -
    "*Attention* Contact your hardware service provider now." Seems pretty serious, but it didn't make the cut - never hit QSYSMSG.

    So, I'm wondering about using the relatively new MESSAGE_QUEUE_INFO function - this SQL easily finds these messages:

    PHP Code:
    select message_text from QSYS2.MESSAGE_QUEUE_INFO
    where message_text like 
    '%Attention%' 
    But I don't want to have to run this SQL constantly to find these fairly rare messages. Does anyone know of a way to use this function or a duplicate of the function to trigger an external action, like sending an email if "Attention" is found in message text?

    Thanks,

    Emmanuel
Working...
X