What is the maxsession table used for in Maximo Base Services?
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 shutdown (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
|Systems and Asset Management||Tivoli Asset Management for IT||Not Applicable||AIX, HP-UX, Linux, Solaris, Windows||6.2.7, 6.2.8, 7.1, 7.1.1, 7.5||All Editions|
|Systems and Asset Management||Tivoli Service Request Manager||AIX, Linux, Solaris||6.2.7, 6.2.8, 7.1, 7.5||All Editions|
|Systems and Asset Management||Tivoli Change and Configuration Management Database||Not Applicable||AIX, Linux, Windows, Solaris, HP-UX, Windows 2000, Windows XP||6.2.7, 6.2.8, 7.1, 7.1.1, 7.5||All Editions|
|Systems and Asset Management||IBM SmartCloud Control Desk||AIX, HP-UX, Linux, Solaris, Windows||7.5|