How to determine what is keeping Catalog and Catproc invalid in the Registry
1. Run this SQL script until it returns ‘CATPROC can be validated now’. For any objects that are reported by this script, they must be addressed in some manner and made valid to continue. To check CATALOG, simply change the two entries in the script. (i.e. replace CATPROC with CATALOG before running) 2. Then run … Read more