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
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).