db2 reset monitor question

[Ramachandran Subramanian]

I have a question regarding the db2 reset monitor.
When I issue the command and do a get snapshot I see most of the
counters are reset . How ever the Dynamic SQL snapshot section doesnt
seem to get reset. Is there any way to reset that ?

When do the buffers for the dynamic SQL get updated reset?

[PM \(pm3iinc-nospam\)]

FLUSH PACKAGE CACHE statement

PM

"Ramachandran Subramanian" <rr****@yahoo.com> a écrit dans le message de
news:c4*************************@posting.google.co m...

I have a question regarding the db2 reset monitor.
When I issue the command and do a get snapshot I see most of the
counters are reset . How ever the Dynamic SQL snapshot section doesnt
seem to get reset. Is there any way to reset that ?

When do the buffers for the dynamic SQL get updated reset?

[Ramachandran Subramanian]

The FLUSH PACKAGE CACHE statement doesnt seem to work. The only
statement I see is FLUSH EVENT MONITOR . Any further help will be
appreciated.
Ram

[Knut Stolze]

Ramachandran Subramanian <rr****@yahoo.com> wrote:

The FLUSH PACKAGE CACHE statement doesnt seem to work. The only
statement I see is FLUSH EVENT MONITOR . Any further help will be
appreciated.

Which version of DB2 are you using on which platform?

In DB2 UDB for LUW, there is a FLUSH PACKAGE CACHE statement. You can find
the documentation for it here (right next to the FLUSH EVENT MONITOR doc):

http://www-3.ibm.com/cgi-bin/db2www/...n=r0007117.htm

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Sean McKeough]

Can you post an example (before & after the reset)? Not all counters in
the dyn sql snapshot are resettable...please also append the output of
'db2level' on your server. Thanks.

Ramachandran Subramanian wrote:

I have a question regarding the db2 reset monitor.
When I issue the command and do a get snapshot I see most of the
counters are reset . How ever the Dynamic SQL snapshot section doesnt
seem to get reset. Is there any way to reset that ?

When do the buffers for the dynamic SQL get updated reset?

[Ramachandran Subramanian]

/home/db2inst1>db2level
DB21085I Instance "db2inst1" uses DB2 code release "SQL07023" with
level
identifier "03040105" and informational tokens "DB2 v7.1.0.55",
"s011211" and
"U480359".
/home/db2inst1>db2 get snapshot for dynamic sql on prodord|wc -l
16007
/home/db2inst1>db2 reset monitor all
DB20000I The RESET MONITOR command completed successfully.
/home/db2inst1>db2 get snapshot for dynamic sql on prodord|wc -l
16007
/home/db2inst1>
As you can see the Reset monitor did not reset the Dynamic SQL
snapshot. They seem to have the same data before and after the reset.

Ram

Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bp**********@hanover.torolab.ibm.com>...

Can you post an example (before & after the reset)? Not all counters in
the dyn sql snapshot are resettable...please also append the output of
'db2level' on your server. Thanks.

Ramachandran Subramanian wrote:

I have a question regarding the db2 reset monitor.
When I issue the command and do a get snapshot I see most of the
counters are reset . How ever the Dynamic SQL snapshot section doesnt
seem to get reset. Is there any way to reset that ?

When do the buffers for the dynamic SQL get updated reset?

[Sean McKeough]

Counting the number of lines will not show the effect of a reset.
Resetting the monitor data will 0 out some of the counters reported by
the snapshot. It will not flush the dynamic sql package cache. The
snapshot for dynamic sql will always report the contents of the package
cache. Resetting the data will only allow you to see delta work done by
statements over time.

Ramachandran Subramanian wrote:

/home/db2inst1>db2level
DB21085I Instance "db2inst1" uses DB2 code release "SQL07023" with
level
identifier "03040105" and informational tokens "DB2 v7.1.0.55",
"s011211" and
"U480359".
/home/db2inst1>db2 get snapshot for dynamic sql on prodord|wc -l
16007
/home/db2inst1>db2 reset monitor all
DB20000I The RESET MONITOR command completed successfully.
/home/db2inst1>db2 get snapshot for dynamic sql on prodord|wc -l
16007
/home/db2inst1>
As you can see the Reset monitor did not reset the Dynamic SQL
snapshot. They seem to have the same data before and after the reset.

Ram

Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bp**********@hanover.torolab.ibm.com>...

Can you post an example (before & after the reset)? Not all counters in
the dyn sql snapshot are resettable...please also append the output of
'db2level' on your server. Thanks.

Ramachandran Subramanian wrote:

I have a question regarding the db2 reset monitor.
When I issue the command and do a get snapshot I see most of the
counters are reset . How ever the Dynamic SQL snapshot section doesnt
seem to get reset. Is there any way to reset that ?

When do the buffers for the dynamic SQL get updated reset?