Purpose
Lists all active client session connections to the Unity server.
Syntax
SESSION LIST [INTERRUPTED [ALL]];Parameters
- INTERRUPTED
- Displays interrupted sessions with database errors.
- INTERRUPTED ALL
- Displays all interrupted sessions.
Examples
Lists managed and passive sessions to the Unity server.
unityadmin> session list;
Unity Session Number : 1000
Client TDP Session Number : 1050
Associated endpoint : region1_ept (1)
Username : testuser1
Logon Source : fast 634 testuser1 bteq 01 LSS
Client IP Address : 153.65.194.177
Connected Since : 10/28 16:58:53
Mode : Read-Only (managed)
Error List : DefaultErrorList
Session Routing : managedrouting1
Session State : Available (in transaction)
Session in transaction : 1 day 15 hr 54 min 17 sec
Ordered Read Systems : [1*] flash [2] blaze
System Sessions:
[1] flash - 5316060 (Active)
[2] blaze - 5223551 (Active)
---------------------------------------------------------------
Unity Session Number : 40001
Client TDP Session Number : 1049
Associated endpoint : region1_ept (1)
Username : testuser1
Logon Source : fast 630 testuser1 bteq 01 LSS
Connected Since : 10/28 16:58:50
Mode : Passive
Error List : DefaultErrorList
Session Routing : passiverouting1
Session State : Available (not in transaction)
System Sessions : flash - 5316059 (Active)
Output | Description |
---|---|
Unity Session Number | Number of the Unity session. |
Client TDP Session Number | Associated Unity Session Number. |
Associated endpoint | Name of the Endpoint associated with the session. |
Username | Name of the Teradata user. |
Account | Account string if specified. |
Group | Group name for the user if specified. Define a group in the routing files or with the USER commands.
|
Client IP Address | IP Address |
Connected Since | Time stamp set when a session begins. |
Mode | Mode indicates Read-only, Read-Write, or Passive. |
Error List | Error list associated with the session routing rule. |
Session Routing | Routing rule session is using. |
Session State | Availability for sessions. |
Session in Transaction | Length of time session has been in transaction (valid only for Managed Routing rules). |
Ordered Read Systems | [Optional] Read system associated with session routing rule. Only shown when the routing rule has the read system specified. |
Ordered Write Systems | [Optional] Write system associated with session routing rule. Only shown when the routing rule has the write system specified. |
System Sessions | Session names and Teradata session numbers. Shows which Teradata Database system is in use and status. |
Lists information on an interrupted session with a database error. In this example, Unity is trying to access a database that does not exist.
unityadmin> session list INTERRUPTED; --------------------------------------------- Unity Session Number : 1000 Unity Transaction ID : 0 System : jasonu4 Root Cause : Yes Interrupt Time : 09/29 16:17:16 Time of Original Query : 09/29 16:07:09 Error Code : 3802 Error Text : Database 'jason2' does not exist. SQL Text : database jason2; ---------------------------------------------
Output | Description |
---|---|
Unity Session Number | Number of the Unity session. |
Unity Transaction ID | Number associated with transaction. |
System | System associated with interrupted session. |
Root Cause | Yes indicates the cause was from a database issue. No indicates the session was interrupted by another session. |
Interrupt Time | Timestamp when system became interrupted. |
Time of Original Query | Timestamp when session attempted to access database. |
Error Code | Code associated with error. |
Error Text | Text string indicating error. |
SQL Text | SQL Text string showing error. |