Flush Cache

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

• DB2 LUW

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.