17.20 - Example: Querying Session DBC.SessionInfoX Using BTEQ - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
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 198.51.100.0 INTTST      818  DBADMIN BTEQ  01 LSS
(TCP/IP) 06F9 192.0.2.0 NAG2N2    1396  POINT   BTEQ  01 LSS
(TCP/IP) 04DC 203.0.113.0 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 198.51.100.0 IP address of the client (host)
192.0.2.0
203.0.113.0
Fourth INTTST 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