Emptying index advisor cache

[Quasar]

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

[Mark 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

[Quasar]

connect to <db-name>
db2 flush package cache dynamic

Thanks a lot Mark, I owe you a beer! :)

Quasar