Maxsession table functionality explained

Technote (FAQ)


Question

What is the maxsession table used for in Maximo Base Services?

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 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


Cross reference information
Segment Product Component Platform Version Edition
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

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management

Software version:

6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1511900

Modified date:

2014-07-21

Translate my page

Machine Translation

Content navigation