Jiang I have one of these underway now ... thanks for confirming my thoughts.
I will have to get around to finding out exactly what snapshot yes is ..... Les -----Original Message----- From: Jiang Tong [mailto:jiang@;cdg.ws] Sent: Tuesday, October 22, 2002 3:04 PM To: Pendlebury-Bowe, Leslie Cc: DB2EUG; [EMAIL PROTECTED] Subject: Re: [DB2EUG] Explains of Dynamic SQL ??? I think the statement event monitor needs to be switched on. The size of output is quite big. Jiang "Pendlebury-Bowe, Leslie" <Leslie.Pendlebury-Bowe@eu To: DB2EUG <[EMAIL PROTECTED]> .sony.com> cc: Sent by: Subject: [DB2EUG] Explains of Dynamic SQL ??? [EMAIL PROTECTED] 10/22/02 08:42 AM Please respond to "Pendlebury-Bowe, Leslie" Hi everyone, is there an easy way of captuing information about all the SQL coming through DB2? Should I use and event monitor or can I switch explain on and then look at it all using snapshot data in the Visual Explain tool? I have tried switching on explain snapshot .. but this produces me nothing in the tables : db2 set current explain snapshot yes .... nothing is obtained when the application (java) is executed. many thanks for your help. Leslie **************************************************************************** ****************** The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only. This email and any response may be monitored by Sony United Kingdom Limited. (05) **************************************************************************** ****************** - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
