Determine Network Response Time between Client & DB2 Database



Share this article :

The Ping command in DB2 database can be use to determine the network response time in between a client and a connected DB2 database. This command function can be useful in order for a system administrator to rectify any network or connection error (and maybe slow connection) to the database level.

You can execute the command as below,

For one time ping.

db2 => ping hostdb

Elapsed time: 25427 microseconds

For multiple ping,

db2 => ping hostdb 10

Elapsed time: 59 microseconds
Elapsed time: 21 microseconds
Elapsed time: 19 microseconds
Elapsed time: 20 microseconds
Elapsed time: 19 microseconds
Elapsed time: 19 microseconds
Elapsed time: 21 microseconds
Elapsed time: 20 microseconds
Elapsed time: 19 microseconds
Elapsed time: 19 microseconds

Ping with request packet of 5000 byte and response packet of 4000 byte.

db2 => ping hostdb request 5000 response 4000

Elapsed time: 118 microseconds

Related posts

db2dart: DB2 Database Analysis & Reporting Tool Command
Find DB2 Version
Find DB2 Database Process Status on Windows & UNIX/Linux
How to Start DB2 System Tray in Windows
© 2017 ITsiti. All Rights Reserved
Powered by KEEM