SessionInfoV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Accounting

Database: DBC

View Column Data Type Format Comment
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the Teradata Database userid of the user who is currently logged on.
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.
SessionNo INTEGER NOT NULL --,---,---,--9 Returns the session identifier assigned to the session by the TDP or LAN interface.
DefaultDataBase VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the current default database for the user.
IFPNo SMALLINT NOT NULL -(5)9 Returns the vproc number of the PE through which the session was connected or assigned.
Partition CHAR(16) LATIN NOT CASESPECIFIC X(16) Returns the name of the Teradata Database partition to which the user is currently attached.
LogicalHostId SMALLINT NOT NULL -(5)9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
HostNo SMALLINT NOT NULL ---,--9 Returns the number of the client system through which the user logged on to the Teradata Database.
CurrentCollation CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the current collation of the session.
LogonDate DATE NOT NULL YY/MM/DD Returns the date that the session for which the log entry was made was logged on to the Teradata Database.
LogonTime FLOAT NOT NULL 99:99:99.99 Returns the time on which logon for the session occurred (useful on logoff events).
LogonSequenceNo BYTE(4) X(8) Returns the logon sequence number of the session.
LogonSource VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Channel-Attached Systems Using the CLIv2 API Returns the origin of the CLIv2 mainframe session being reported, such as the user ID or session number of the client system.
ExpiredPassword CHAR(1) LATIN UPPERCASE X(1) Returns a code that indicates whether or not the defined session is in the process of a logon for a user with an expired password.
TwoPCMode VARCHAR(1) LATIN NOT CASESPECIFIC X(1) Returns one of the following codes: 2 = 2PC mode, N = non-2PC mode.
Transaction_Mode VARCHAR(1) LATIN NOT CASESPECIFIC X(1) Returns one of the following codes to indicate the mode of the session: T = TDBS, A = ANSI.
CurrentRole VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the current role for a session.
ProfileName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the profile.
LogonAcct VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the account string used when a session is established.
LDAP CHAR(1) LATIN UPPERCASE NOT NULL X(1) The LDAP column denotes how a directory user for a given session is mapped. The column displays one of these options: P means "permanent user", X means "external user" and N means "not externally authenticated".
AuditTrailId VARCHAR(128) UNICODE UPPERCASE NOT NULL X(128) Returns the identifier that is used for access logging.
CurIsolationLevel VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) Returns the isolation level; SR - Serializable; RU - Read uncommitted; RC - Read Committed; RR - Repeatable Read.
QueryBand VARCHAR(4096) UNICODE NOT CASESPECIFIC X(4096) Returns the band under which the query is submitted.
ProxyUser VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the proxy user.
ProxyCurRole VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the current role of the proxy user.
TemporalQualifier VARCHAR(1024) LATIN NOT CASESPECIFIC X(1024) DBC.SESSIONINFOVX.TemporalQualifier is used to reset the qualifier in the session across a database restart
CalendarName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The SESSIONINFOVX.CalendarName column describes the calendar set in the session
ExtendedLogonSource VARCHAR(2048) UNICODE NOT CASESPECIFIC X(2048) The ExtendedLogonSource column is an identification of the place from where the user accessed the system
ClientIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) The ClientIpAddress column is the standard text representation of the IP address where the user accessed the system
ClientProgramName VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) The ClientProgramName is the client system program name
ClientSystemUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSystemUserId is the client user id
ClientConnectionType BYTEINT -(3)9 The ClientConnectionType is 1 for TCP/IP or 2 for Channel connect
ClientCoordName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientCoordName is the Coordinator name for clients using CICS or IMS
ClientEnvName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientEnvName is the TDP Environment Name
ClientJobId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobId is the TDP Job ID
ClientJobName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobName is the TDP Job Name
ClientOsName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientOsName is the TDP Operating System Name
ClientProcThreadId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientProcThreadId is the client process/thread identifier
ClientSecProdGrp VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSecProdGrp is the TDP Security Product Group
ClientSecProdUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSecProdUserId is TDP Security Product Userid
ClientTcpPortNumber INTEGER --,---,---,--9 The ClientTcpPortNumber is the TCP port number on the client system
ClientTdHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTdHostName is the Teradata Database hostname that the client used to connect to the Teradata Database
ClientTerminalId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTerminalId is TDP Terminal Identifier
ClientTransactionId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTransactionId is TDP Transaction Identifier
ClientUserOperId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientUserOperId is the TDP User/Operator Identifier
ClientVmName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientVmName is the TDP Virtual Machine Name
ClientVmUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientVmUserId is the TDP Virtual Machine User Id
MechanismName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The MechanismName is authentication method used to authenticate the user
ClientTDPReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTDPReleaseId is the TDP Release Identifier
ClientCLIv2ReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientCLIv2ReleaseId is the CLIv2 Release Identifier
ClientSessionDesc VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSessionDesc is the TDP session description
ClientWorkload VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientWorkload is the TDP Workload
ClientJobData VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobData is the client Job Data from the LSINFO environmental variable
ClientODBCDriverVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientODBCDriverVersion is the client ODBC Driver Version
ClientNetDataProviderVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientNetDataProviderVersion is the client .NET Data Provider Version
ClientODBCDriverManagerVersion CHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientODBCDriverManagerVersion is the client ODBC Driver Manager Version
ClientNetFrameworkVersion CHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientNetFrameworkVersion is the client .NET Framework Version
ClientAttributesEx VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) The ClientAttributesEx field contains extra description of the client that do not match any of the other Client Attributes fields
ClientJDBCDriverVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientJDBCDriverVersion is the client JDBC Driver Version
ClientJavaVersion VARCHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientJavaVersion is the client Java Framework Version
ExportDefinitionName VARCHAR(30) LATIN NOT CASESPECIFIC X(30) The ExportDefinitionName is the current ExportDefinitionName of the session that is inherited from the user when a session is logged on.
ExportWidthRuleSet BYTE(20) X(40) The ExportWidthRuleSet is the current ExportWidthRuleSet of the session that is inherited from the user when a session is logged on. It is maintained for the duration of the session (even if the user is modified while the session is active).
RecoverableNetworkProtocol CHAR(1) LATIN UPPERCASE NOT NULL X(1) The RecoverableNetworkProtocol column indicates whether the client supports the RecoverableNetwork client-database interface
LogonRedrive VARCHAR(33) UNICODE NOT CASESPECIFIC X(33) The LogonRedrive column indicates the sessions participation in Redrive
ClientIPAddrByClient VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Client IP Address by Client
ClientPortByClient INTEGER --,---,---,--9 Client Port by Client
ServerIPAddrByClient VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Serve IP Address by Client
ServerPortByClient INTEGER --,---,---,--9 Server Port by Client
ClientIPAddrByUnity VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Client IP Address by Unity
ClientPortByUnity INTEGER --,---,---,--9 Client Port by Unity
UnityClientSideIPAddr VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity Client Side IP Address
UnityClientSidePort INTEGER --,---,---,--9 Unity Client Side Port
UnityServerSideIPAddr VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity Server Side IP Address
UnityServerSidePort INTEGER --,---,---,--9 Unity Server Side Port
ServerIPAddrByUnity VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Server IP Address by Unity
ServerPortByUnity INTEGER --,---,---,--9 Server Port by Unity
ServerIPAddrByServer VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Server IP Address by Server
ServerPortByServer INTEGER --,---,---,--9 Server Port by Server
ClientCOPSuffixedHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client COP Suffixed Hostname
UnitySessNo INTEGER --,---,---,--9 Unity Session Number
UnityVersion VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Unity Version
UnityAuthMechName VARCHAR(1571) UNICODE NOT CASESPECIFIC X(1571) Unity Authorized Mechanism Name
UnityMechanismName VARCHAR(1571) UNICODE NOT CASESPECIFIC X(1571) Unity Mechanism Name
UserAuthenticatedBy VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) User Authenticated by
ClientTDSessionPoolName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client TD Session Pool Name
UnityTcpPortNumber INTEGER --,---,---,--9 Unity TCP Port Number
UnityIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity IP Address
TTGranularity VARCHAR(30) UNICODE NOT CASESPECIFIC X(30) The SESSIONINFOVX.TTGranularity column describes the Transaction Time Granularity set in the session
LoadingOp CHAR(1) LATIN UPPERCASE X(1) The LoadingOp is set to "T" when session isolated loading is enabled and "F" when session isolated loading is disabled.
UnicodePassThrough CHAR(1) LATIN UPPERCASE X(1) The SessionInfoV.UnicodePassThrough returns the Unicode Pass Through attribute of the session.
DirUserNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) This column contains the user's network confidentiality policy that applies on the connection between the client and the gateway or between the client and Unity, obtained from the LDAP directory used for security policy.
DirUserNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When DirUserNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy.
UnityNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) This column contains the user's network confidentiality policy that applies on the connection between Unity and the gateway, obtained from the LDAP directory used for security policy.
UnityNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When UnityNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy.
EffectiveSessionNetConf CHAR(1) LATIN NOT CASESPECIFIC X(1) This column contains the effective network confidentiality policy for the session, that applies on the connection between the client and the gateway or between the client and Unity, integrated from all sources of security policy that do not change.
EffectiveSessionNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When EffectiveSessionNetConfidentiality is "I" or "C", this column contains the level of protection required, integrated from all sources of security policy that do not change within a session.
ProxyLogon CHAR(1) LATIN NOT CASESPECIFIC X(1) The ProxyLogon column indicates T if logon request uses Passwordless Proxy for TD2.
ClientConfType CHAR(1) LATINC X(1) The ClientConfType column indicates Client Confidentiality Type.
ServerConfType CHAR(1) LATINC X(1) The ServerConfType column indicates Server Confidentiality Type.
UnityConfType CHAR(1) LATINC X(1) The UnityConfType column indicates Unity Confidentiality Type.
ServerUnityConfType CHAR(1) LATINC X(1) The ServerUnityConfType column indicates Server Unity Confidentiality Type.
ClientConfVersion VARCHAR(16) LATIN NOT CASESPECIFIC X(16) The ClientConfVersion column indicates Client TLS version number.
ClientConfCipherSuite VARCHAR(64) LATIN NOT CASESPECIFIC X(64) The ClientConfCipherSuite column indicates Client TLS cipher suite.
UnityConfVersion VARCHAR(16) LATIN NOT CASESPECIFIC X(16) The UnityConfVersion column indicates Unity TLS version number.
UnityConfCipherSuite VARCHAR(64) LATIN NOT CASESPECIFIC X(64) The UnityConfCipherSuite column indicates Unity TLS cipher suite.
TimeZoneString VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the time zone string set for the user session.