Monitoring QSYSOPR Messages: SQL to Retrieve Messages and Replies

Last Updated on 7 November 2024 by Roberto De Pedrini I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to monitor the messages in QSYSOPR and their corresponding replies. With this simple SQL query, it is possible to check the messages from a specific day or a defined period, obtaining a list of the messages and their corresponding replies, along with the timestamp of both; SELECT A.MESSAGE_TIMESTAMP AS "Date/Time of Error Msg", A.MESSAGE_ID AS "Msg ID", A.FROM_JOB AS "Job Generated Error Msg", A.MESSAGE_TEXT AS "Msg Text", B.MESSAGE_TIMESTAMP AS "Reply Date/Time", SUBSTR(B.MESSAGE_TEXT, 1, 10) AS "Reply", A.FROM_USER AS "Reply by …