467,189 Members | 1,344 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Emptying index advisor cache

Hi Gents,

I'm trying to tune our DBs using the Desing Advisor feature. I'm
interested just in the indexes area.
Following the IBM infocenter I came to this page:
http://publib.boulder.ibm.com/infoce...n/t0011424.htm
which explains how to create a workload from the dynamic statements
cache.
The problem comes when I reset the statements cache before starting
the monitoring period, issuing:
db2 reset monitor for database <database-name>

I have some doubts on the usefulness of this command, because it does
not seem to clear the cache. In fact if I run
db2 get snapshot for DYNAMIC SQL on <database-name>
I never get an empty list. It seems this is not the right command to
empty the statements cache.

Would anybody be so kind to help me with this index advisor? Am I
using this db2advis in the wrong way?

Thanks in advance.

Quasar

Aug 6 '07 #1
  • viewed: 2454
Share:
2 Replies
"Quasar" <qu*****@gmail.comwrote in message
news:11*********************@d55g2000hsg.googlegro ups.com...
Hi Gents,

I'm trying to tune our DBs using the Desing Advisor feature. I'm
interested just in the indexes area.
Following the IBM infocenter I came to this page:
http://publib.boulder.ibm.com/infoce...n/t0011424.htm
which explains how to create a workload from the dynamic statements
cache.
The problem comes when I reset the statements cache before starting
the monitoring period, issuing:
db2 reset monitor for database <database-name>

I have some doubts on the usefulness of this command, because it does
not seem to clear the cache. In fact if I run
db2 get snapshot for DYNAMIC SQL on <database-name>
I never get an empty list. It seems this is not the right command to
empty the statements cache.

Would anybody be so kind to help me with this index advisor? Am I
using this db2advis in the wrong way?

Thanks in advance.

Quasar
connect to <db-name>
db2 flush package cache dynamic
Aug 6 '07 #2
connect to <db-name>
db2 flush package cache dynamic
Thanks a lot Mark, I owe you a beer! :)

Quasar

Aug 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Larry Trutter | last post: by
3 posts views Thread by xixi | last post: by
3 posts views Thread by UnixSlaxer | last post: by
5 posts views Thread by Bas Scheffers | last post: by
reply views Thread by Daren | last post: by
15 posts views Thread by rAinDeEr | last post: by
7 posts views Thread by reachsamdurai@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.