Monitoring Db2 in distributed environments

You can use DISPLAY commands and the trace facility to obtain information. Db2 can also return server-elapsed time to certain types of client applications.

The Db2 DISPLAY commands provide information about the status of threads, databases, tracing, allied subsystems, and applications. The following DISPLAY commands are particularly helpful for monitoring Db2 in distributed environments:

• DISPLAY DATABASE
• DISPLAY DDF DETAIL
• DISPLAY LOCATION
• DISPLAY THREAD
• DISPLAY TRACE