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.
Example: Displaying gateway vproc statistics
di st all
Output:
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
Output:
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