What is the difference between both Plan Analyzer rule sets delivered with the product ?

book

Article ID: 16449

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction



What is the difference between both Plan Analyzer rule sets delivered with the product ?

_  @@RULDBA Rule Set for DBA       

_  @@RULDEV Rule Set for Developer

Environment

Release:
Component: PPADB2

Resolution

These are the role based CA-Defined rule sets that were made available in r18.  While the rule sets are not update-able. It can be easily templated to allow the ability to customize them.  

@@RULDBA -    contains all the rules SQL, Physical, Plan, and Predicate with exception of Physical RI rules 1056-1061.

@@RULDEV -    contains only the SQL and Predicate rules.