DISPLAY STATS - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

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
  }
REPEAT secs reps
Automatically reruns the DISPLAY STATS command at a specified interval a specified number of times.
  • secs is the time, in seconds, between runs of DI ST.
  • reps is the number of times to repeat the DI ST command
The DI ST command can be repeated automatically only when used to display USER statistics.
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