Caching security labels
Db2 caches security labels to improve performance when multilevel security with row-level granularity is used.
About this task
Db2 caches all security labels that are checked (successfully and unsuccessfully) during processing. At commit or rollback, the security labels are removed from the cache. If a security policy that employs multilevel security with row-level granularity requires an immediate change and long-running applications have not committed or rolled back, you might need to cancel the application.