How to collect DB2 diagnose data if reproduce the issue hangs the DB2 host machine
ChunGao 270006J5PY Comment (1) Visits (5352)
Sometimes customer encounters issue that hangs the DB2 host machine. In this situation, no command can be issued on the host machine, nor can connect to it. Which makes collecting data impossible when the host machine hangs. So we have to use the time window between starting of reproduce and the server hang to collect the data. Sometimes this window is not long enough for all the commands to be finished, to withhold the window and collect as much data as possible, we can force sending "sigstop" to stop db2sysc, and collect data, then send "sigcont" to let it continue and "sigstop" again, to stop db2sysc to collect data to see what is changed.
On terminal 2:
On terminal 3:
Then repeat steps on terminal 2 and 3 again for as many iterations as needed.