ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 16449

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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.