Reporting server-elapsed time

Client applications that access Db2 data using DRDA access can request that Db2 return the server-elapsed time.

Server-elapsed time allows remote clients to determine the actual amount of time it takes for Db2 to parse a remote request, process any SQL statements required to satisfy the request, and generate the reply. Because server-elapsed time does not include any of the network time used to receive the request or send the reply, client applications can use the information to quickly isolate poor response times to the network or to the Db2 server without you having to perform traces on the server. When the System Monitor statement switch has been turned on, Db2 returns server-elapsed time information as a new element through the regular Snapshot Monitoring APIs.