The CA ACF2 Option for DB2 Catalog Synchronization Utility creates GRANT and REVOKE statements that let you ensure the DB2 catalog is up‑to‑date. However, REVOKE statements can invalidate some of your plans. DB2 invalidates plans whenever a privilege used to create the plan is revoked and the user no longer holds the privilege from another source. Therefore, when the Catalog Synchronization Utility is run and REVOKE statements are issued against privileges used to create a plan (and the user does not hold the privilege from another source), DB2 marks any plan the REVOKE affects as invalid and it must be rebound.
You can list those plans marked invalid in the catalog by performing the following sample SQL query. We suggest you run this query before and after you execute the Catalog Synchronization Utility to determine which plans you need to rebind.
SELECT NAME, CREATOR
FROM SYSIBM.SYSPLAN
WHERE VALID = ‘N’
ORDER BY NAME
|
Copyright © 2011 CA Technologies.
All rights reserved.
|
|