SESSIONS

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableSESSIONS to determine the following database information, among other things:

·        All users currently logged on and the name of the computer on which the application is running

SELECT username, applicationnode
  FROM SYSINFO.SESSIONS
    WHERE own = 'YES'

·        Parameters of your database session

SELECT sqlmode, isolationlevel, timeout, sessionid
  FROM SYSINFO.SESSIONS
    WHERE own = 'YES'

All defined users: see USERS