Copyright © Cloud Software Group, Inc. All Rights Reserved

active_logins

The active_logins table stores details of all users who are currently logged in to this iProcess Engine node.

Structure

The active_logins table has the following structure:

TABLE active_logins(
logical_machine_id number(5) NOT NULL,
logical_process_name varchar2(10) NOT NULL,
logical_process_instance number(5) NOT NULL,
user_name varchar2(64) NOT NULL,
user_id varchar2(37) NOT NULL,
process_id number(10) NOT NULL,
filsh number(5) NOT NULL,
windows number(2) NOT NULL,
station_id varchar2(32) NOT NULL)

Column	Description
logical_machine_id	ID of the server where the process that made the login request is running, as defined in the node_cluster table.
logical_process_name	Logical name of this process instance. Note: See "Administering iProcess Engine Server Processes" in TIBCO iProcess Engine Administrator's Guide for a list of logical process names.
logical_process_ instance	ID of this process instance, as defined in the process_config table.
user_name	Name of the user who is logged in, as defined in the user_names table.
user_id	ID of the user who made the login request (for internal use only).
process_id	Process ID (PID) of the process that made the login request.
filsh	FIL session handle (for internal use only).
windows	Flag that defines whether the login request came from TIBCO iProcess Objects (0) or from an TIBCO iProcess® Workspace or other SAL application (1).
station_id	Comment that identifies where a user is logged in.

Primary Key

None.

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_active_logins1	logical_machine_id	node_cluster

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following indexes are defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_active_ logins_fk	logical_machine_id	SMALLINDEXSPACE
idx_active_logins	user_id	MEDIUMINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	SMALLTABLESIZE
Percentage Increase	SMALLTABLEPCTINCREASE
Tablespace	SMALLTABLESPACE

Table Activity

The active_logins table contains one row for each user who is currently logged into this iProcess Engine node.

Rows are added, updated and deleted in the following situations.

A row is...	When...
added	a user is logged in.
updated	never.
deleted	a user is logged out or the iProcess Engine shuts down.

Copyright © Cloud Software Group, Inc. All Rights Reserved