在db2中怎么确定sql和操作系统进程的关系

guyang2000

I have used update dbm config using DFT_MON_STMT on , seems no effect. let's try update monitor switches using statement on .


Thanks very much for reply

guyang2000

I set up the monitor swith to statment ON

I can only use " get snapshot for dynamic sql on DBxxx" to list all the dynanic sql run against database DBxxx.

But use " get snapshot for application agentid xxx  " I can see how many insert/ update run. but could not see the Real SQL statment.

Who can help on this,  what  the correct "get snapshot for " command.

Thanks.