DB2 10.5 for Linux, UNIX, and Windows

FLUSH PACKAGE CACHE statement

The FLUSH PACKAGE CACHE statement invalidates all cached dynamic SQL statements in the package cache. This invalidation causes the next request for any SQL statement that matches an invalidated cached dynamic SQL statement to be compiled instead of reused from the package cache.

Invocation

This statement can be embedded in an application program or issued by using dynamic SQL statements. It is an executable statement that can be dynamically prepared.

Authorization

The privileges that are held by the authorization ID of the statement must include SQLADM or DBADM authority.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-FLUSH PACKAGE CACHE--DYNAMIC--------------------------------><

Notes