FLUSH AUTHENTICATION CACHE statement

The FLUSH AUTHENTICATION CACHE statement flushes the Db2® authentication cache of all entries, allowing fresh entries to be cached. Running this statement will perform the flush on all database members in which the cache is present.

When the Db2 authentication cache is active, each new authentication request made with a username and password is compared against existing, valid entries in the cache. If a match is found, the authentication request is deemed to be successful and processing continues. If a match is not found, the authentication request is processed and, if successful, the result is placed as a new entry in the cache.

Invocation

This statement can be issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.

Authorization

The privileges held by the authorization ID of the statement must include either SECADM or DBADM authority.

Syntax

Read syntax diagramSkip visual syntax diagramFLUSH AUTHENTICATION CACHE FOR ALL

Description

FOR ALL
Flushes the authentication cache information for all users. This is the default.

Example

  • Flush the authentication cache information for all entries with the following command:
    FLUSH AUTHENTICATION CACHE