Example documentationSESSIONS Locate this document in the navigation structure

 

Use of the system table SYSINFO.SESSIONS

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

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

  • All database 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'

More Information

All defined database users: See USERS