Db2 commands for troubleshooting

You can use commands to perform the tasks that are required to control and maintain your Db2 subsystem.

DISPLAY THREAD SERVICE command for troubleshooting

Begin program-specific programming interface information.

The DISPLAY THREAD(*) SERVICE command helps to identify and rectify some CPU stalls. The following options are available:

SERVICE(WAIT)
Displays threads that are in a long-term suspend. If a thread is suspended on a latch, the command displays latch details, and Db2 attempts to boost the holder to relieve the latch contention. If the thread is suspended on a lock, the command displays lock detail information.
SERVICE(STG)
Displays the information for SERVICE(WAIT), with an additional message that outlines the agent local storage consumption for each thread displayed.

For more information, see -DISPLAY THREAD (Db2).End program-specific programming interface information.