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
