Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Maintaining Siebel Business Applications on DB2 for z/OS > Enabling DB2 Dynamic Statement Caching > About Invalidating Cached StatementsAfter DB2 prepares a SQL statement and places it in the global statement cache, it is reused. If you are performing SQL tuning and you want to force DB2 to prepare and reoptimize a cached statement, the global SQL statement cache must be invalidated. To invalidate an entry in the global statement cache for a specific SQL statement, one of the tables referenced by the SQL statement or the table catalog statistics must be altered in some way. You can invalidate a dynamically cached statement using one of the following methods:
|
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |