Teradata BTEQ 13.00.00.00 for z/OS. Enter your logon or BTEQ command: .logon tdpv/socal .logon tdpv/socal Password: *** Default Character Set Name 'EBCDIC ' *** Logon successfully completed. *** Transaction semantics are BTET. *** Total elapsed time was 0.58 seconds. BTEQ -- Enter your DBC/SQL request or BTEQ command: sel logonsource from dbc.SessionInfoX; *** Query completed. 5 rows found. One column returned. *** Total elapsed time was 0.44 seconds. LogonSource -------------------------------------------------------------------- (TCP/IP) 05BF 155.64.116.42 IETTST 818 DBADMIN BTEQ 01 LSS (TCP/IP) 06F9 208.199.59.157 NAG2N2 1396 POINT BTEQ 01 LSS (TCP/IP) 04DC 10.243.71.25 PW_OLD 2462 ROOT ARCMAIN 01 LSS z/OS TDRT D48734 BATCH CS210041 SOCAL BTQMAIN z/OS TDPV AN1005 TSO AN1005 SOCAL IKJFT01
The first three lines report network-connected sessions. The last two lines report mainframe-connected sessions, where:
| Field | Value in Querying Example Output | Description |
|---|---|---|
| First | (TCP/IP) | Connection name or type (literal) |
| (TCP/IP) | ||
| (TCP/IP) | ||
| Second | 05BF | Port or socket identifier |
| 06F9 | ||
| 04DC | ||
| Third | 155.64.116.42 | IP address of the client (host) |
| 208.199.59.137 | ||
| 10.243.71.25 | ||
| Fourth | IETTST | Teradata Director Program Identifier (TDPID) |
| NAG2N2 | ||
| PW_OLD | ||
| Fifth | 818 | Client process/thread identifier |
| 1396 | ||
| 2462 | ||
| Sixth | DBADMIN | Username used in this session |
| POINT | ||
| ROOT | ||
| Seventh | BTEQ | Name of the application through which the session was initiated |
| BTEQ | ||
| ARCMAIN | ||
| Eighth | 01 | All network sessions (literal) |
| 01 | ||
| 01 | ||
| Ninth | LSS | All network sessions (literal) |
| LSS | ||
| LSS |