Session Information
When a session is established, information is added to either individual columns in DBC.SessionTbl and DBC.EventLog, the LogonSource column in various views (such as dbc.LogOnOff and dbc.SessionInfo), or both by the Teradata Database depending on its version.
Individual Columns
The session information consists of multiple columns, each containing a specific value. The following columns may contain values:
Column |
Description |
ClientConnectionType |
Communication type, with the unsigned integer 2 indicating a channel connection |
ClientOsName |
Canonical operating system designation, with the EBCDIC value 'MVS' |
ClientTdHostName |
TDPid as an EBCDIC value |
ClientJobName |
jobname as an EBCDIC value |
ClientEnvName |
Environment, as an EBCDIC value of 'BATCH', 'TSO', 'CICS', or 'IMS' |
ClientUserIdSecProd |
Operating system userid from a security product as an EBCDIC value, if a security product exists |
ClientGroupSecProd |
Group from a security product as an EBCDIC value, if a security product exists |
ClientProgramName |
Application program name as an EBCDIC value |
ClientCoordName |
Optional coordinator name as an EBCDIC value |
ClientTransactionId |
Transaction identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS' |
ClientTerminalId |
Terminal identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS' |
ClientUserOperId |
the user or operator identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS' |
ClientJobId |
job id as an EBCDIC value |
ClientTDPReleaseId |
TDP release as an EBCDIC value |
ClientCLIv2ReleaseId |
CLIv2 release as an EBCDIC value |
ClientSessionDesc |
Optional CLIv2 application Session-desc specification as an EBCDIC value |
ClientWorkload |
Optional CLIv2 application Workload specification as an EBCDIC value |
LogonSource Column
The session information consists of two types of data:
Positional Fixed-Length Items
TDP provides system-dependent information in the LogonSource column, consisting of the following series of eight-character values, each left-justified and padded on the right with blanks:
The format identifier, while cryptic, allows new information to be added after what were originally trailing optional values. If the format identifier is not present, then Jobid is not present, and only the first seven or eleven fields will be present.
Older versions of TDP provided only one eight-character field, which contained the jobname (z/OS jobname).
Self-Defining Variable-Length Items
Zero or more variable-length EBCDIC items can be present, enveloped by a descriptive name and enclosed in parenthesis, each separated by a comma.
If the length of the self-Defining items results in Logon Source Information larger than the size of the DBC.SessionTbl LogonSource column, TDP will truncate them as necessary, indicating such a truncation by the string '...)', if room permits.