how to flush a query from the statment cache in Z/Os

rdrechsler · #1 (**permalink**) 11-19-09, 23:23

running dynamic statement cache in db2 v9 Z/Os... how do you flush a query or all statements out of the cache.. haven't found any relevant statements in the sql reference.

sawangupta · #2 (**permalink**) 11-20-09, 00:12

You could try using the KeepDynamic setting.

BIND - IBM DB2 9.7 for Linux, UNIX, and Windows

KeepDynamic CLI/ODBC configuration keyword - IBM DB2 9.7 for Linux, UNIX, and Windows

Regards,
Sawan Gupta

rdrechsler · #3 (**permalink**) 11-20-09, 08:46

The query(ies) are already in the statement cache.. I want to get rid of them..

I don't think ODBC parms will affect whats in the cache

rdrechsler · #4 (**permalink**) 11-20-09, 08:56

ok, one way I found in Z/Os.. set the CACHEDYN zparm to NO compile and
then issue a SET SYSPARM command to load it... clears the whole cache..

It's a BFI method but gets the job done..

any less obtrusive ways for a particular statement?

dav1mo · #5 (**permalink**) 11-20-09, 09:28

You can perform runstats on an object.
Dave

rdrechsler · #6 (**permalink**) 11-20-09, 10:02

the change in zparm which I thought worked , didn't

Internet Services

Web Development

Digital Marketing

Consumer Tech