Re: Message queue QSYS/QSYSMSG

[Bradley Stone <bvstone@xxxxxxxxx>]

So I was just looking into this.  If you're on V7R2 or higher you can use
SQL to query message queues.

I would think this would be pretty easy to then monitor for messages.  It's
still something I can add to JOBWATCH if Jim or others are interested, but
with simple SQL it seems it can be done fairly easily.

Message queues are never fun to deal with, but this really simplifies
things.   Here's the article I found:
http://www.rpgpgm.com/2017/05/using-sql-for-message-queue-data.html

Let me know if I am off base here... :)  Again I'm happy to add this
feature, but I would use the SQL method as I recall the APIs for message
queues were not fun to work with.  That means V7R2 or higher (with the
appropriate PTFs, Refresh, etc).

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #22 <https://www.bvstools.com/mailtool.html>: Cost
starting at under $300 a year per partition!

On Thu, Sep 28, 2017 at 11:40 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

> I will dig into it, Jim.  It gives me a reason to move JOBWATCH up to
> V7R1, if that's not an issue.  I still have my V5R4 devo box I could do it
> on.  :)  I do have many customers on old OS versions.
>
> Bradley V. Stone
> www.bvstools.com
> MAILTOOL Benefit #20 <https://www.bvstools.com/mailtool.html>: The
> ability to specify multiple email routers/relays to make sure emails are
> sent when they need to be.
>
> On Thu, Sep 28, 2017 at 8:09 AM, Jim Oberholtzer <
> midrangel@xxxxxxxxxxxxxxxxx> wrote:
>
> > Brad,
> >
> > I like the idea.  Might push me over the top to put this on all my
> > customer
> > machines.....
> >
> >
> > --
> > Jim Oberholtzer
> > Agile Technology Architects
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > Bradley Stone
> > Sent: Wednesday, September 27, 2017 10:32 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: Message queue QSYS/QSYSMSG
> >
> > I've been meaning to add this to my JOBWATCH application.  It already
> > monitors for MSGW (or any status) job and also can make sure at least "X"
> > jobs are running.   This would be a cool addition.
> >
> > Bradley V. Stone
> > www.bvstools.com
> > MAILTOOL Benefit #1 <https://www.bvstools.com/mailtool.html>: Command and
> > ILE Interfaces available which means easily sending email from your
> > programs.