---Does anyone know whether monitoring for SQL0000, SQ20000, and SQ30000 will trap all of the SQLxxxx, SQ2xxxx, and SQ3xxxx errors?
Yes, that is how MONMSG works in CL programs.
--Will SQ*nnnn messages that are really *not* errors be flagged as well?
--- Dan
You shouldn't have to worry about message ids that are "not" errors.
The command only sends failure messages as Escape, which is all you can monitor for with a MONMSG.
A failure message is one with a Negative SQL Code.
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.