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

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.