Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Determine JVM status via Maximo UI or DB client

    Posted Thu August 12, 2021 07:43 PM
    Edited by System Admin Wed March 22, 2023 11:48 AM
    MAM 7.6.1.2:

    I'm not a WebSphere admin; I only have access to the Maximo UI and a DB client.

    With that said, there are occasions when it would be helpful if I could determine the status of WebSphere JVMs.

    For example, we had some known issues in a clustered environment. I needed to check whether the environment was "up". So I went to the environment URL, logged in, and poked around in a few applications. It certainly seemed like the environment was up and working correctly.

    However, it turned out that a couple of the "messaging engines" (JVMs?) were down. But I had no way of knowing that.

    (screenshot sent to me by a WebSphere admin after the fact)

    Is there a way for me to determine the status of JVMs in an environment -- using the tools I have available to me (Maximo UI or DB client)?

    Thanks.
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Determine JVM status via Maximo UI or DB client

    Posted Thu August 12, 2021 09:39 PM
    Check out the maximo managemet interface work centre.  This will provide a lot of info on the underlying health/status of WAS. It also gives you views of  and the ability to perform basic tests your queues as well.

    Also looking at your image, thats the message bus and not a JVM.  If your having issue starting up your message bus it's possible that you may be using file based data stores for messaging and something has impacted one or more of the files.

    ------------------------------
    Michael Kasteel
    Director
    ISW
    0402830412
    ------------------------------



  • 3.  RE: Determine JVM status via Maximo UI or DB client

    Posted Fri August 13, 2021 06:47 AM
    Its not pretty but if you have access to a DB query then the following query will show you each JVM, its status and how many users are on it

    select ss.servername, ss.reloadcache, ss.servertimestamp, ss.active, count(ms.userid)
    from SERVERSESSION SS
    left join MAXSESSION ms on ss.servername = ms.servername
    group by ss.servername, ss.reloadcache, ss.servertimestamp, ss.active
    order by ss.servername

    This gives a quick and dirty report

    Which is fine for my purposes!  Looking at user numbers it is obviously lunchtime...

    Regards

    ------------------------------
    Brian Williams
    Maximo System Administrator
    Ineos FPS
    ------------------------------



  • 4.  RE: Determine JVM status via Maximo UI or DB client

    Posted Fri August 13, 2021 08:20 AM
    I really have to second Michael's response if you're interested in deeper health questions like JMS. For each JVM you should see how many users are logged into it, whether that JVM is admin mode or not (since you're clustered, it's possible for some to be in admin mode and others not), how many database connections are active, MBO counts, memory utilization, etc. If you don't have access to monitoring tools this provides most of the information you could need.

    These are all supported via REST API requests, so if you need to script it (so you didn't have to navigate to the work center and test the connection manually on your queues) you would be able to as well. 

    Serversession as Brian mentioned is a valuable resource for some questions (is the JVM up, are my users being properly distributed across the JVMs, etc.) and has some information there that you can't access in the MMI work center (such as the queued up cache reloads, Maximo log directory, and the PID for that Java process). Aside from the cache reloads, most of that isn't relevant unless you have access to the server though. I'd suggest most people start with the MMI work center.

    ------------------------------
    Steven Shull
    ------------------------------