Jiang is certainly correct about the size of the output. It can be HUGE and looking through it is like looking for the proverbial needle in a haystack. The other problem with an event monitor dumping data to disk on a busy system (many thousands of SQL statements per hour) is that you can't run an event monitor continuously. In my experience my event monitor was always turned off when I needed it to capture an ugly SQL statement.
There are 3rd party tools on the market that can continuosuly capture SQL statements and allow you to look at the SQL statements in comparison to each other, in terms of CPU consumed, rows read, etc. They keep a running total of the statements so you can determine how many times they are actually executing and what resources they are consuming. Jiang Tong wrote: > 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 - ::: 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
