Maximo Open Forum

 View Only

 Separate application server for Reports

  • Maximo User Groups
Pramod Mohite's profile image
Pramod Mohite posted 01-28-2021 09:36
We have performance issues in our environment and hence we want to provision separate report server.

We have Maximo asset managemen-7.6.1.2 and websphere-9.0.0.7 installed on Windows Server 2012R2 and we have dedicated server Windows Server 2012R2 which we want to utilize as report server so all reports will be directed on this server to avoid performance issues.

We need information about what all installations we need to do on the report server .
How to connect existing Maximo WebSphere to this new server and changes that we need to make in Maximo. Properties file.(considering if we have installed WebSphere on the report server also) 

Can anyone help in understanding how we do such installation on separate app server where we can direct these reports?

BROS gives us steps of installation on same app server but as we have dedicated report server we want to have separate app server for these reports.

Thanks in advance!
Steven Shull's profile image
Steven Shull
The way I read this is you're considering a completely isolated server that's not tied into the existing WebSphere environment. We'd recommend adding the server as a new node into the existing WebSphere cell. Your app server can be dedicated to running reports (IE only JVMs supporting the report process on that node) but it's better to still be part of that deployment, especially if LDAP/SAML are involved.

I will caution that in our experience it's rare that executing the reports is a significant cause of performance slowdown. I'd expect the issue more likely lies with the database (where creating a reporting database might be appropriate) or other functionality running in the UI JVM if you haven't separated the background/integration processes into a separate MIF cluster. We support a wide variety of customers and have pretty much stopped doing dedicated reporting JVMs as we haven't identified a noticeable benefit to it.
Pramod Mohite's profile image
Pramod Mohite
Thanks @Steven Shull

So the node federation has to be initiated from existing DMGR or we can perform that addnode from isolated report server?

Thanks 
Pramod

 ​​
Steven Shull's profile image
Steven Shull
You would run addnode on the report server. Then either through the admin console UI or jython scripts create a new JVM (or new cluster if you want to have two JVMs) on the new node. And then finally install the Maximo EARs to that JVM/cluster. 

If you're not already clustered, ensure that you're allowing the traffic required for the nodes to communicate. WebSphere utilizes UDP & TCP connections on a variety of ports to communicate to each other.