Show TOC

Example documentationSESSIONS

 

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