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.
This statement can be issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared.
The privileges held by the authorization ID of the statement must include either SECADM or DBADM authority.
- Flushes the authentication cache information for all users. This is the default.
- Flush the authentication cache information for all entries with the following command:
FLUSH AUTHENTICATION CACHE