17.10 - DISPLAY STATS - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The DISPLAY STATS command allows you to display the statistics for the gateway vproc.

Syntax

{ DISPLAY | DI } { STATS | ST }
  {
    { REPEAT | REP } secs reps { USER | US } user_name |
    gtwid |
    ALL
  }

Syntax Elements

REPEAT
Automatically reruns the DISPLAY STATS command at a specified interval a specified number of times.
The DISPLAY STATS command can be repeated automatically only when used to display USER statistics.
secs
Time, in seconds, between runs of DISPLAY STATS.
reps
Number of times to repeat the DISPLAY STATS command.
user_name
The name of the user account for which you want to display connected session statistics.
gtwid
Specified gateway vproc whose statistics are displayed.
ALL
Selected host group.
If you select a host group, gtwglobal returns the statistics for all the gateway vprocs in the selected host group.
If you do not select a host group, gtwglobal returns the statistics for all gateway vprocs.

Example: Displaying gateway vproc statistics

di st all

Gtw Vprocid:         8193
HostMessageReads:     382
HostBlockReads:       125
HostReadBytes:    3829382
DbsMessageReads:      108
HostMessageWrites:    125
HostBlockWrites:      125
HostWriteBytes:      1167
DbsMessageWrites:     104
Gtw Vprocid:         8192
HostMessageReads:    2220
HostBlockReads:      1107
HostReadBytes:      92919
DbsMessageReads:     1103
HostMessageWrites:   1107
HostBlockWrites:     1107
HostWriteBytes:   3950263
DbsMessageWrites:    1103

Example: DISPLAY STATS command with automatic repeats

> di stats repeat 30 2 user ETL01

Repeat 1 of 2 with 30 second intervals started at 19-Oct-2016 11:22:07
User ETL01 has 3 sessions
Clock    HG Session GTW   Node   PE    Node   Partition IP Addr          HostReadBytes Since Last HostWriteBytes Since Last
-------- -- ------- ----- ------ ----- ------ --------- ---------------- ------------- ---------- -------------- ----------
11:22:07 1  55801   22528 001-01 30719 001-02 TPTLOAD   203.0.113.255            36363     36363           17604      17604
11:22:07 1  55802   22528 001-01 30718 001-01 DBC/SQL   198.51.100.0          14768023  14768023         9067819    9067819
11:22:07 1  55804   22528 001-01 30718 001-01 MULTLOAD  198.51.100.0              1183      1183             798        798

Repeat 2 of 2 with 30 second intervals started at 19-Oct-2016 11:22:37
User ETL01 has 3 sessions
Clock    HG Session GTW   Node   PE    Node   Partition IP Addr          HostReadBytes Since Last HostWriteBytes Since Last
-------- -- ------- ----- ------ ----- ------ --------- ---------------- ------------- ---------- -------------- ----------
11:22:37 1  55801   22528 001-01 30719 001-02 TPTLOAD   203.0.113.255            36363          0          17604          0
11:22:37 1  55802   22528 001-01 30718 001-01 DBC/SQL   198.51.100.0          14768193        170        9067879         60
11:22:37 1  55804   22528 001-01 30718 001-01 MULTLOAD  198.51.100.0              1183          0            798          0

Repeat 2 of 2 with 30 second intervals ended at 19-Oct-2016 11:22:37