Session Information - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
xuf1527114222341.ditamap
dita:ditavalPath
ft:empty
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 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 connection through TDP
ClientOsName Canonical operating system designation, with the EBCDIC value 'MVS'
ClientOsProductDesc Description of the operating system product as provided by the vendor
ClientTdHostName TDPid as an EBCDIC value
ClientTDPReleaseId TDP release as an EBCDIC value
ClientTDPoolName When the session being established is for a TDP session pool, the name of that pool. When this field is present, the remaining fields are not.
ClientEnvName Application environment, as an EBCDIC value of 'BATCH', 'TSO', 'CICS', or 'IMS'
ClientUserIdSecProd Application operating system user ID from a security product as an EBCDIC value, if a security product exists
ClientGroupSecProd Application group from a security product as an EBCDIC value, if a security product exists
ClientProgramName Program name as an EBCDIC value
ClientCoordName Application optional coordinator name as an EBCDIC value
ClientTransactionId Application transaction identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS'
ClientTerminalId Application terminal identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS'
ClientUserOperId Application user or operator identifier as an EBCDIC value, if the environment is 'CICS' or 'IMS'
ClientJobId Application job id as an EBCDIC value
ClientJobName Application jobname as an EBCDIC value
ClientCLIv2ReleaseId CLIv2 release as an EBCDIC value
ClientSessionDesc Optional CLIv2 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 will truncate them as necessary, indicating such a truncation by the string '...)', if room permits.