Table of Contents

SSN - Session

Module SSN

Description

This table holds an entry reflecting the environment and current or completion status of a process using an application transaction.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Session Text 8 1 Edit Yes Public
BEGDATTIM Start of Session Datetime 15 0 Unknown Yes Public
ENDDATTIM End of Session Datetime 15 0 Unknown Yes Public
STA Termination Status of Session Text 1 1 Edit Yes Public Embedded
LSTDATTIM Last Start of a Transaction Datetime 15 0 Unknown Yes Public
LSTFRM ID of Last Started Transaction Text 8 1 Edit Yes Public ATPTXT
APPSRV Application Server Text 32 1 Edit Yes Public
DISSRV Display Server Text 32 1 Edit Yes Public
ENG Name of Logical Engine Text 8 1 Edit Yes Public
APPPID PID of Process in Application Server Text 16 1 Edit Yes Public
DISPID PID of Process in Display Server Text 16 1 Edit Yes Public
BCKGRD Background Flag Text 1 1 Edit Yes Public Embedded
USR User ID Text 8 1 Edit Yes Public
MLTSSNID Multi Session Indicator Numeric 3 0 Edit Yes Public
ETY Currently Used ETYEXTKEY Text 8 1 Edit Yes Public

Indices

Name Fields Properties
SSN_APP APPSRV, APPPID
SSN_INR INR Unique
SSN_STA STA, INR Unique

/


Lock

INR

Datafield Description and Properties


Datafield INR Internal Unique ID

Description

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter SSN. The field INR is used to maintain links from other tables into this table.

Helpinformation

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.

For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.


Datafield BEGDATTIM Start of Session

Description

The date and time on which the session has been started.

Helpinformation

The date and time when the session was started.


Datafield ENDDATTIM End of Session

Description

The date and time the session has been terminated.

Helpinformation

The date and time the session was terminated.


Datafield STA Termination Status of Session

Description

The status of the session reflects the logical status. There are two statuses reflecting normal execution of the session. The status 'X' is set when no update to the database has taken place. Whenever an update to the database takes place the status of the session is set to 'A' to reflect that this session has processed data.The status 'A' is not reset up to the termination of the session. Depending on the status of the session the associated user count of the security key is checked.

Status 'N' and 'C' is set upon termination of the session.

Status 'R' is set when recovery routines update session entries where there are no associated processes executing.

Status 'U' is set by a manager (via JOBMOD) if the SSN is to be reused by a sub-process triggered by JOBMOD.

Helpinformation

Two status levels reflect normal session processing. 'X' is set when the database has not been updated. Whenever the database is updated, the status level of the session is set to 'A' to reflect the fact that this session has processed data. Depending on the session status, a check is run of the associated user count for the security key.

Status levels 'N' and 'C' are set when the session is terminated.

Status 'R' is set when recovery routines update session entries.

Status level 'U' is set by a Job Manager if the session is to be reused by a sub-process triggered by the Job Manager.

Codetable
Code Text
X Active
N Normal
C Canceled
R Recovered
A Application
U Reuse

Datafield LSTDATTIM Last Start of a Transaction

Description

Date and time when the transaction identified in LSTFRM was started.

Helpinformation

Date and time when the transaction was started.


Datafield LSTFRM ID of Last Started Transaction

Description

This field identifies the last started transaction within the session. Thus this usually holds the currently active transaction. This content is updated by the initialization of SYSMOD within the transaction.

Helpinformation

This field identifies the last transaction started in the session and usually holds the currently active transaction.


Datafield APPSRV Application Server

Description

The name of the server executing the TradeDesign engine used to execute the transaction. In client-server environments this is the name of the application server. In a fat-client environment this is the name of the PC executing Trade2.Exe.

Helpinformation

The name of the server executing the TradeDesign engine used to execute the transaction. In client-server environments this is the name of the application server. In a fat-client environment this is the name of the PC executing Trade2.exe.


Datafield DISSRV Display Server

Description

The name of the server executing the TradeDesign user interface which is used to display the transaction panels and to receive input. In client-server environments this is the name of the user PC. In a fat-client environment this is the name of the PC executing Trade2.Exe. If transaction runs in background and is controlled by ipc(ui.e. uses SYSIPC) this field is set to 'ipc:<queuename>'

Helpinformation

This identifies the server executing the TradeDesign user interface which is used to display the transaction panels and to receive input. In client-server environments this is the name of the user PC. In a fat-client environment this is the name of the PC executing Trade2.Exe.


Datafield ENG Name of Logical Engine

Description

The name of the runtime system used to execute the TradeDesign transactions. (e.g. trade2, td2soci)

Helpinformation

The name of the runtime system used to execute the TradeDesign transactions.


Datafield APPPID PID of Process in Application Server

Description

Process ID (PID) of the application server process executing the runtime environment used for this session. In case of a reconnect this PID holds the current (or last) PID, because in this case a new runtime environment and thus another PID is used.

Helpinformation

Process ID (PID) of the application server process executing the runtime environment used for this session. If a connect has to be re-established this PID holds the current (or last) PID, because in this case a new runtime environment, and thus another PID, is used.


Datafield DISPID PID of Process in Display Server

Description

Process ID (PID) of the display server process executing the TradeDesign client used for this session.

Helpinformation

Process ID (PID) of the display server process executing the TradeDesign client used for this session.


Datafield BCKGRD Background Flag

Description

When checking the background status, the third undefined status must be taken as logical foreground but without access to the user interface.

Thus, if a decision for prompting the user is necessary, the 'F' status should be checked via 'if \SYSMOD\SSN\BCKGRD.is(“F”) then'.

Helpinformation

When checking the background status, the third undefined status must be used as the logical foreground, however without accessing the user interface.

Therefore, if a user prompted becomes necessary, this 'F' status should be checked using 'if SYSMODSSNBCKGRD.is(“F”) then'.

Codetable
Code Text
F Foreground
B Background
Undefined
I Interrupt

Datafield USR User ID

Description

The user ID of the user who started the session. To retrieve the current User-Id of the login user the best way is to use the function GetUserID.

Helpinformation

The ID of the user who started the session.


Datafield MLTSSNID Multi-session indicator

Helpinformation

Multi-session indicator may be part of the title of the application panel.


Datafield ETY Currently Used ETYEXTKEY

Description

The entity used within the session. When a change of the entity has taken place, each change is updated in the session entry.

Helpinformation

The entity used within the session. When a change of the entity has taken place, each change is updated in the session entry.