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
