16.10 - Example: Querying Session DBC.SessionInfoX Using BTEQ - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K
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.sessiontbl;
sel logonsource from dbc.sessiontbl;
*** 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