how to read debug info after set SUBQUERY_UNNESTING to 'debug'

[Liu, Ming (Ming)]

hi, all,

I am trying to understand better about subquery optimization in Trafodion. So I 
set the SUBQUERY_UNNESTING CQD to 'DEBUG', and try a few queries, but I don't 
know how to see the output of that DEBUG? I saw the code will generate some 
WARNs into diagArea, but not seeing them.
If someone know how to use this debug skill, please help me.

thanks,
Ming