Session Information - Director Program

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

optional self-defining variable-length items

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:

Operating System Name (MVS or VOS3)

TDPid

Jobname (z/OS jobname)

Environment Name (either BATCH, TSO, IMS, or CICS for z/OS)

Userid from Security Product (blank if no such product)

Group from Security Product (blank if no such product)

Program Name - contains either the executable application name or an identifier provided by the application using the CLIv2 Workload specification. Since it cannot be determined which is present, the value is deprecated. The executable application name is reliably provided by the later Actual Program Name item.

Coordinator name (omitted if not for CICS or IMS)

Transaction identifier (omitted if not for CICS or IMS)

Terminal identifier (omitted if not for CICS)

User/operator identifier (omitted if not for CICS)

Actual Program Name - contains the executable application name.

Jobid (z/OS Job ID)

A format identifier that can be used to parse the previous positional information. If the information ends with the four characters ' LSS' (note the leading blank), then the format identifier value is present. The first two characters of the format identifier indicate the number of values present before any Actual Program Name (currently either 07 or 11). The next two characters indicate the version of format identifier. If ‘01’, the Jobid value is present; if ‘02’, the Actual Program Name and Jobid values are present.

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.

TDP() provides the TDP release identifier

CL2() provides the CLIv2 release identifier

SESSDESC() provides information specified by the application using the CLIv2 Session-desc specification. This is purely descriptive information, otherwise unused.

WORKLOAD() provides information specified by the application using the CLIv2 Workload specification. This is information formatted as defined, and intended for use, by the Database.

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.