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
- positional fixed-length items
- optional self-defining variable-length items
Positional Fixed-Length Items
- Operating System Name (MVS)
- 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
- 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.