By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,333 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,333 IT Pros & Developers. It's quick & easy.

Emptying index advisor cache

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.