15.00 - DISPLAY STATS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DISPLAY STATS

Purpose  

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

Syntax  

 

Syntax element...

Is the...

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  

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