Re: Detecting an unresponsive Tomcat server on a Midrange box. Any ideas?

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Here's a full sample from RunSQLScripts I have stored in my examples


*--  category:  My IBM i http Services*
*--  description:  httpGetClob*
*--*
*--  Documentation can be found here:*
*--  --------------------------------*
*--  https://www.ibm.com/docs/en/i/7.5?topic=systools-http-function-overview
<https://www.ibm.com/docs/en/i/7.5?topic=systools-http-function-overview>*
*-- *
*-- If this website is up and fine it will return one of the following
based on the server*
*-- that the Edge server directed it to:  GDDATA, GDDATA2, GDDATA3.*
*-- If the website is unavailable you will get an sql state of 38000
or an sql code of  SQL4302.*
values systools.httpgetclob('https://dekkohome.dekko.com/gdintranet.nsf/edge
', '');



*--  To check for SQL4302*Select
MESSAGE_ID,
*-- The message ID for this message.*MESSAGE_TEXT
*-- The first level text of the message including tokens.*from table
(qsys2.joblog_info('*')) A

*-- where message_id='SQL4302'*order by ordinal_position desc
fetch first row only;

On Thu, Jan 23, 2025 at 2:48 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> One thing which I find makes it easy to test web sites of yours is to
> first have a test page in which a certain return is expected.  For example,
> if I go to my internal site
> https://dekkohome.dekko.com/gdintranet.nsf/edge
> I will get a test page of just a very few characters.
> Once I have that working then it becomes quite easy to code the following
> sql:
> values systools.httpgetclob('
> https://dekkohome.dekko.com/gdintranet.nsf/edge','');
> and that returns that character string.
> If it fails you can check the sql return code.
> Works like a champ.
>
> On Thu, Jan 23, 2025 at 2:40 PM James H. H. Lampert via MIDRANGE-L <
> midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> > We have this one case, out of all the Midrange Tomcat installations we
> > manage, in which the server becomes unresponsive, sometimes every other
> > month, sometimes every other week, sometimes every other day, and in any
> > event requiring a forced shutdown and a restart.
> >
> > And somebody suggested that if we could detect the problem, we could
> > automate that.
> >
> > But I have no idea how we'd be able to detect it.
> >
> > Anybody have any ideas?
> >
> > --
> > JHHL
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.