Information about current session pools, which are a collection of sessions that are logged on to the database under the same logonid, may be accessed by entering the DISPLAY POOL command. For more information on DISPLAY POOL, see
Teradata® Director Program Reference, B035-2416.
LogonSource
Teradata recommends using alternative columns instead of the LogonSource column, if available. For information about the recommended columns for LogonSource, see "LogonSource Column Fields and Examples."
Possible Values for ClientConnectionType
Value |
Description |
1 |
Client is connected using TCP/IP via the gateway. |
2 |
Client is connected from a mainframe via a mainframe-attached host. |
Possible Values for CurrentCollation
Value |
Description |
A |
ASCII |
E |
EBCDIC |
H |
Host |
M |
Multinational |
C |
CharSet_Coll |
J |
JIS_Coll |
Possible Values for DirUserNetConfidentiality, UnityNetConfidentiality, EffectiveSessionNetConf
When these columns are set to I or C it indicates the level of protection required.
Value |
Description |
I |
Indicates the level of protection required for Integrity, which is obtained by lookup in the LDAP directory used for security policy. The levels are: Default (D), Low (L), Medium (M), and High (H). |
C |
Indicates the level of protection required for Confidentiality, which is obtained by lookup in the LDAP directory used for security policy. The levels are: Default (D), Low (L), Medium (M), and High (H). |
Possible Values for ExpiredPassword
Value |
Description |
Y |
Yes, by Session Control procedures |
N |
No, by the Parser when a new password is assigned to the user |
Possible Values for LogonRedrive
Value |
Description |
' ' |
Not participating |
MEMORY NON-FALLBACK RESPONSES |
Memory-based Redrive participation |
NULL or blanks |
Session is not participating in Redrive and database restarts will not be transparent to applications and users. |
Possible Values for LoadingOp
Value |
Description |
T |
Session isolated loading is enabled. This is the default setting for a session. |
F |
Session isolated loading is disabled. |
Possible Values for Partition
Value |
Description |
7 |
Console Utility Partition number |
8 |
Partition in which DBC console procedures will be started by the Host utility |
9 |
File System Partition number |
10 |
Gateway partition number |
11 |
Worker Task Partition number |
12 |
Session Control Partition number |
13 |
Dispatcher Partition number |
14 |
Parser Partition number |
15 |
Startup Partition number |
17 |
Resource Sampling Subsystem (RSS) StartUp Partition number |
18 |
Distributed Database File (DDF) Server Partition number |
19 |
Relay Services Gateway (RSG) Partition number |
47 |
Replication Gateway rsgdbsmain partition number |
Possible Values for ProxyLogon
Value |
Description |
T |
The ProxyLogon column indicates if Unity has logged a user onto a TD2 session using existing credentials, when that user was successfully logged on by another Unity-managed Vantage system using TD2. When this occurs, ProxyLogon is set to T. |
F |
False indicates the TD2 session logged on or attempted to log on with a valid password. |
Possible Values for TTGranularity
Value |
Description |
LOGICALROW |
Row is timestamped with the time the row is processed by the AMP. |
REQUEST |
Row is timestamped with the time the request is submitted. |
TRANSACTION |
Row is timestamped with the time when the first non-locking reference is made to a temporal table, or when the built-in function TEMPORAL_TIMESTAMP is first accessed during the transaction. |
Possible Values for UnicodePassThrough
Value |
Description |
S |
UNICODE PASS THROUGH session attribute is enabled. |
F |
UNICODE PASS THROUGH session attribute is not enabled. |