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

Start & Stop DB2 Instance Command
Find the List of Active DB2 Databases
Get the Lists and Information on DB2 Tablespace
Enable & Disable DB2 Instance Auto Start
© 2017 ITsiti. All Rights Reserved
Powered by KEEM