DB2/ZOS V7 - Refresh dynamic cache

Mark McCormack

DB2/ZOS V7 - Refresh dynamic cache
(in response to LUIZ FORONI)
Luiz,

If I remember correctly, the runstats utility on a table will invalidate
any cached dynamic sql stmts against that table.

Mark

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Wayne Driscoll

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to Mark McCormack)
Run a report only runstats on the tablespaces impacted by the statements. I
believe that there are some ALTER statements on the tablespace (like audit)
that will flush any statements for those objects from the cache.
Wayne Driscoll
Product Developer
Western Metal Supply
NOTE: All opinions are strictly my own.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Luiz Roberto Foroni
Sent: Thursday, December 15, 2005 2:25 PM
To: [login to unmask email]
Subject: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache

Hi listers,

I would like to know the easiest way to refresh dynamic statements cached
in edm pool.

thanks in advance.

Luiz Roberto Foroni
DBA - DB2 - ZOS
Caixa Seguros - Brazil


----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Basivi Inaganti

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to Wayne Driscoll)
Here i can think off the quick way.

If you want to refresh the dynamic cached statements for TABLE A, then
rename it to TABLE B. After the rename the cached statements become
invalid. Later rename TABLE B back to TABLE A. Note you first renamed
TABLE A, all the packages/plans get invalidated. In case AUTO BIND is not
set to 'YES', you need to rebind them.

Thanks,
Basivi.





Luiz Roberto Foroni <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12/15/2005 05:24 PM
Please respond to DB2 Database Discussion list at IDUG

To: [login to unmask email]
cc:
Subject: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache


Hi listers,

I would like to know the easiest way to refresh dynamic statements
cached in edm pool.

thanks in advance.

Luiz Roberto Foroni
DBA - DB2 - ZOS
Caixa Seguros - Brazil


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

LUIZ FORONI

DB2/ZOS V7 - Refresh dynamic cache
Hi listers,

I would like to know the easiest way to refresh dynamic statements cached in edm pool.

thanks in advance.

Luiz Roberto Foroni
DBA - DB2 - ZOS
Caixa Seguros - Brazil


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Suresh Sane

Re: DB2/ZOS V7 - Refresh dynamic cache
(in response to Basivi Inaganti)
Basivi,

Assuning you have IBM RUNSTATS, the no-udpate no-report option is the
quickes and painless way.

Cool as your suggestion sounds, I would strongly discourage using RENAME for
this purpose. Here are some reasons why:

- Tables wth views, triggers or synonyms on them create problems (not
allowed)
- The act of invalidating, simple as it sounds, means that all users of that
package must be drained - a batch applicatiopn may delay this for several
minutes
- The act of binding can cause similar issues
- Access path switches for static SQL in the middle of the day could create
other headaches

Just keep it simple, please!

Thanks,
Suresh


>From: Basivi Inaganti <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
>Date: Thu, 15 Dec 2005 15:05:11 -0500
>
>Here i can think off the quick way.
>
>If you want to refresh the dynamic cached statements for TABLE A, then
>rename it to TABLE B. After the rename the cached statements become
>invalid. Later rename TABLE B back to TABLE A. Note you first renamed
>TABLE A, all the packages/plans get invalidated. In case AUTO BIND is not
>set to 'YES', you need to rebind them.
>
>Thanks,
>Basivi.
>
>
>
>
>
>Luiz Roberto Foroni <[login to unmask email]>
>Sent by: DB2 Data Base Discussion List <[login to unmask email]>
>12/15/2005 05:24 PM
>Please respond to DB2 Database Discussion list at IDUG
>
> To: [login to unmask email]
> cc:
> Subject: [DB2-L] DB2/ZOS V7 - Refresh dynamic cache
>
>
>Hi listers,
>
>I would like to know the easiest way to refresh dynamic statements
>cached in edm pool.
>
>thanks in advance.
>
>Luiz Roberto Foroni
>DBA - DB2 - ZOS
>Caixa Seguros - Brazil
>
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
>home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
>select "Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences
>at http://conferences.idug.org/index.cfm
>
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm