15.10 - SessionInfoV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

UserName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

SessionTbl.UserName

AccountName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

SessionTbl.AccountName

SessionNo

INTEGER

NOT NULL

--,---,---,--9

SessionTbl.SessionNo (Composite UPI)

DefaultDatabase

VARCHAR(128)

UNICODE

X(128)

SessionTbl.CurrentDataBase

IFPNo

SMALLINT

NOT NULL

-(5)9

SessionTbl.IFPNo

Partition

CHAR(16) LATIN

X(20)

SessionTbl.Partition

LogicalHostId

SMALLINT

NOT NULL

ZZZ9

SessionTbl.LogicalHostId

HostNo

SMALLINT

NOT NULL

---,--9

SessionTbl.HostNo (Composite UPI)

CurrentCollation

CHAR(1) LATIN

NOT NULL

UPPERCASE

X(1)

SessionTbl.CurrentCollation

LogonDate

DATE

NOT NULL

YY/MM/DD

SessionTbl.LogonDate

LogonTime

TIME

NOT NULL

99:99:99.99

SessionTbl.LogonTime

LogonSequenceNo

BYTE(4)

X(8)

SessionTbl.LogonSequenceNo

LogonSource

VARCHAR(128)

UNICODE

X(128)

SessionTbl.LogonSource

ExpiredPassword

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

SessionTbl.ExpiredPassWord

TwoPCMode

VARCHAR(1) LATIN

X(1)

SessionTbl.Options

Transaction_Mode

VARCHAR(1) LATIN

X(1)

SessionTbl.Options

CurrentRole

VARCHAR(128)

UNICODE

X(128)

SessionTbl.CurrentRole

ProfileName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

SessionTbl.ProfileName

LogonAcct

VARCHAR(128)

UNICODE

NOT NULL

X(128)

SessionTbl.LogonAcct

LDAP

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

SessionTbl.LDAP

AuditTrailId

VARCHAR(128)

UNICODE

UPPERCASE

NOT NULL

X(128)

SessionTbl.AuditTrailId

CurIsolationLevel

VARCHAR(16)

UNICODE

X(16)

SessionTbl.IsolationLevel

QueryBand

VARCHAR(2048)

UNICODE

NOT CASESPECIFIC

X(2048)

SessionTbl.QueryBand

ProxyUser

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

SessionTbl.ProxyUser

ProxyCurRole

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

SessionTbl.ProxyCurRole

TemporalQualifier

VARCHAR(1024) LATIN

NOT CASESPECIFIC

X(1024)

SessionTbl.TemporalQualifier

CalendarName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

SessionTbl.CalendarName

ExtendedLogonSource

VARCHAR (2048)

UNICODE

X(2048)

SessionTbl.ExtendedLogonSource

ClientIpAddress

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ClientIpAddress

ClientProgramName

VARCHAR(1024)

UNICODE

X(1024)

SessionTbl.ClientProgramName

ClientSystemUserId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientSystemUserId

ClientConnectionType

BYTEINT

--9

SessionTbl.ClientConnectionType

ClientCoordName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientCoordName

ClientEnvName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientEnvName

ClientJobId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientJobId

ClientJobName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientJobName

ClientOsName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientOsName

ClientProcThreadId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientProcThreadId

ClientSecProdGrp

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientSecProdGrp

ClientSecProdUserId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientSecProdUserId

ClientTcpPortNumber

INTEGER

--,---,---,--9

SessionTbl.ClientTcpPortNumber

ClientTdHostName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientTdHostName

ClientTerminalId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientTerminalId

ClientTransactionId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientTransactionId

ClientUserOperId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientUserOperId

ClientVmName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientVmName

ClientVmUserId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientVmUserId

MechanismName

VARCHAR(128)

UNICODE

X(128)

SessionTbl.MechanismName

ClientTDPReleaseId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientTDPReleaseId

ClientCLIv2ReleaseId

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientCLIv2ReleaseId

ClientSessionDesc

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientSessionDesc

ClientWorkload

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientWorkload

ClientJobData

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientJobData

ClientODBCDriver
Version

VARCHAR(16)

UNICODE

NOT CASESPECIFIC

X(16)

SessionTbl.ClientODBCDriverVersion

ClientNetDataProvider
Version

VARCHAR(16)

CHARACTER SET

UNICODE

NOT CASESPECIFIC

X(16)

SessionTbl.ClientNetDataProvider
Version

ClientODBCDriver
ManagerVersion

CHAR(30)

UNICODE

NOT CASESPECIFIC

X(30)

SessionTbl.ClientODBCDriverManagerVersion

ClientNetFramework
Version

CHAR(30)

UNICODE

NOT CASESPECIFIC

X(30)

SessionTbl.ClientNetFrameworkVersion

ClientAttributesEx

VARCHAR(512)

UNICODE

X(512)

SessionTbl.ClientAttributesEx

ClientJDBCDriverVersion

VARCHAR(16)

UNICODE

X(16)

None

ClientJavaVersion

VARCHAR(30)

UNICODE

X(30)

None

ExportDefinitionName

VARCHAR(30)

LATIN

X(30)

SessionTbl.ExportDefinitionName

ExportWidthRuleSet

BYTE(20)

X(40)

SessionTbl.ExportWidthRuleSet

RecoverableNetwork
Protocol

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

SessionTbl.RecoverableNetwork
Protocol

LogonRedrive

VARCHAR(33)

UNICODE

X(33)

SessionTbl.LogonRedrive

ClientIPAddrByClient

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ClientIPAddrByClient

ClientPortByClient

INTEGER

--,---,---,--9

SessionTbl.ClientPortByClient

ServerIPAddrByClient

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ServerIPAddrByClien

ServerPortByClient

INTEGER

--,---,---,--9

SessionTbl.ServerPortByClient

ClientIPAddrByUnity

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ClientIPAddrByUnity

ClientPortByUnity

INTEGER

--,---,---,--9

SessionTbl.ClientPortByUnity

UnityClientSideIPAddr

VARCHAR(45)

UNICODE

X(45)

SessionTbl.UnityClientSideIPAddr

UnityClientSidePort

INTEGER

--,---,---,--9

SessionTbl.UnityClientSidePort

UnityServerSideIPAddr

VARCHAR(45)

UNICODE

X(45)

SessionTbl.UnityServerSideIPAddr

UnityServerSidePort

INTEGER

--,---,---,--9

SessionTbl.UnityServerSidePort

ServerIPAddrByUnity

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ServerIPAddrByUnity

ServerPortByUnity

INTEGER

--,---,---,--9

SessionTbl.ServerPortByUnity

ServerIPAddrByServer

VARCHAR(45)

UNICODE

X(45)

SessionTbl.ServerIPAddrByServer

ServerPortByServer

INTEGER

--,---,---,--9

SessionTbl.ServerPortByServer

ClientCOPSuffixedHost
Name

VARCHAR(128)

UNICODE

X(128)

SessionTbl.ClientCOPSuffixedHost
Name

UnitySessNo

INTEGER

--,---,---,--9

SessionTbl.UnitySessNo

UnityVersion

VARCHAR(128)

UNICODE

X(128)

SessionTbl.UnityVersion

UnityAuthMechName

VARCHAR(1571)

UNICODE

X(1571)

SessionTbl.UnityAuthMechName

UnityMechanismName

VARCHAR(1571)

UNICODE

X(1571)

SessionTbl.UnityMechanismName

UserAuthenticatedBy

VARCHAR(1)

X(1)

SessionTbl.UserAuthenticatedBy

ClientTDSessionPool
Name

VARCHAR(128)

X(128)

SessionTbl.ClientTDSessionPoolName

UnityTcpPortNumber

INTEGER

--,---,---,--9

EventLog.UnityTcpPortNumber

UnityIpAddress

VARCHAR(45)

UNICODE

X(45)

EventLog.UnityIpAddress

TTGranularity

VARCHAR(30)

UNICODE

NOT CASE SPECIFIC

NOT NULL

X(30)

SessionTbl.TTGranularity

LoadingOp

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

SessionTbl.LoadingOp

Information about current session pools, which are a collection of sessions that are logged on to the Teradata 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.

LogonSource

Teradata recommends using alternative columns instead of the LogonSource column, if available. For information about the recommended columns for LogonSource, see Appendix B: “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 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 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 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.

The following SELECT statement displays information on all current session.

==> SELECT UserName, SessionNo, DefaultDatabase, LogonSource
       FROM DBC.SessionInfoV;

Result:

UserName  SessionNo DefaultDatabase LogonSource
--------- --------- --------------- ----------------------------
DBC       1,005     DBC             <TCP/IP> EB9F 141.206.1.84
 

For information about ...

See ...

interpreting the ExportWidthRuleSet column

“ExportWidthV” on page 138.

using the DBSControl utility to make export width definition changes

International Character Set Support.