Session Information - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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 user ID 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 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)
  • User ID 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 truncates them as necessary, indicating such a truncation by the string '...)', if room permits.