CONNECTEDUSERS

Definition

The system table CONNECTEDUSERS contains all the database users who are logged on.

Structure

CONNECTEDUSERS

USERNAME

CHAR(32)

Name of the user

TERMID

CHAR(18)

Terminal ID

SESSION

FIXED(10)

Database session

CATALOG_CACHE_SIZE

FIXED(10)

Size of the cache for catalog information in this database session (in pages)

The system table CONNECTEDUSERS exists only to enable compatibility with older database versions. Instead of the system table CONNECTEDUSERS, use the system table SESSIONS.

See also:

Evaluating System Tables, SESSIONS

Concepts of the Database System, Database Users