IBM Support

MAXSESSION table functionality explained

Question & Answer


Question

What is the MAXSESSION table used for in Maximo ?

Answer

The MAXSESSION table is used to track connected servers and users.
The column ISSYSTEM will have a 1 if it is an instance of a server (JVM) that is connected and will have a 0 if it is a user that is connected.
The system instances are used in caching and assigning instance variables from the system application.
The users are cleared when they log out or their session times out.

There are 3 main queries (1 insert and 2 updates) that often happen during login and log out as follows:


1. This insert is run each time a JVM session is created.
Once at application server startup for the application server's session, once each time a user logs in.
 
Insert into maxsession (userid,clienthost,issystem,active,servertimestamp,maxsessionuid,clientaddr,adminlogout,logindatetime,displayname,serverhost,servername) values(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12);


2. This is run once every 60 seconds by each application server running Maximo.
It updates the servertimestamp value to the current timestamp.
This value is used to indicate when a server has crashed/failed (servertimestamp is more than 60 seconds ago) and is used by the ConfigDB to determine if all the servers are shut down (that is, all servertimestamps must be more than 60 seconds ago).
 
update maxsession set servertimestamp = :1 where serverhost = :2 and servername = :3 and issystem = :4;

3. This is run when a session has become inactive.

update maxsession set lastactivity=:1 where maxsessionuid=:2 and rowstamp=:3

[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbCvAAK","label":"System->System Related"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5.0;7.6.0;7.6.1","Type":"MASTER"},{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"ARM Category":[{"code":"a8m500000008b3sAAA","label":"Miscellaneous Category (Portal, UI, Maximo, Install)->Misc - Maximo Base"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.0;7.6.0;7.6.1","Type":"MASTER"}]

Document Information

Modified date:
04 August 2021

UID

swg21511900