Answer by csdmhoff (2174) | Jul 02, 2015 at 03:48 AM
To trace db2haicu command, also when it seems to hang you can do: Open a different window to get a trace of the hanging db2haicu command:
Before issuing db2haicu have on a different window (window1)
a) db2trc on -t -l 1024M (window1)
b) switch to the other window with your db2haicu (window2)
when this starts to be hung
on the db2trc window issue (window1)
db2trc dump Trace1
sleep 120
db2trc dump Trace2
sleep 120
db2trc dump Trace3
You can stop the trace with db2trc off
To format the trace (this can be done at any time later)
db2trc flow -t Trace1 flow1.out
db2trc flow -t Trace2 flow2.out
db2trc flow -t Trace3 flow2.out
db2trc format Trace1 format1.out
db2trc format Trace2 format2.out
db2trc format Trace3 format3.out
If the problem is related to creation of TSAMP resources please also collect "getsadata -all" from all nodes together with db2diag.log