Flush Cache

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you clear all dynamic SQL in the cache for a package and forces IBM DB2 for Linux, Unix, and Windows to recompile the SQL the next time it is called.

Platform Availability

To Flush the Cache for a Package

  1. Initiate a Flush Cache action against a package. For more information see Initiating an object operation.
    The Flush Package Cache dialog opens.
  2. Click Execute. For information on the scheduling option, see Scheduling.