Entering content frame

This graphic is explained in the accompanying textSESSIONS Locate the document in the library structure

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'

Note

All defined users: see USERS

 

Leaving content frame