Db2 Tools

  • 1.  CA Plan Analyzer  SQL Design Rule 0078

    Posted Aug 06, 2017 05:31 AM

    Hi community members
      SQL Design Rule 0078 of CA DB2 Plan Analyzer points to this problem:
    This SQL statement contains qualified table names.
    I would like that this rule would not be applied for SYSIBM tables, as SYSIBM.SYSDUMMY1.
    Is it possible?



  • 2.  Re: CA Plan Analyzer  SQL Design Rule 0078

    Broadcom Employee
    Posted Aug 11, 2017 03:23 AM

    Hi Eugene,

     

    IMHO, I don't think that PPA has a function to exclude objects from consideration by a specific expert rule.

     

    You could create a customised ruleset of your own by Templating an existing Rule Set and turn off(Inactivate) rule 0078 but that would inactivate it for all sql not just the ones you want so that's no good.

     

    I have found that in the Explain Options there is : Search Filters      ===> Y

    The online help for this says:

    Use the Explain Filters screen to limit your explain to only those SQL statements that contain specific character strings. This feature allows you to specify anything as a character string, including column names, table names, objects, and lists.

     

    Also, in the CDBAPARM(PPA) there are these options:

    COLLEXC1, COLLEXC2 and COLLEXC3

    The online help for this (found in the install procedure for setting up the PPA member).

    Field:  Collection Exclusion ID 1 through 3

    Description:  Enter a collection name to exclude when you use Explain services on a plan. Maximum number of characters allowed is 18. You can use wildcards in this field.  For example, enter AB% to exclude all collections beginning with AB.

     

    As for your original question, you could raise an IDEA on this site for consideration. There have been previous requests for an "EXCLUDE FILTERS" function but none I could find on the Rules. 

     

    Hope this helps,

    Lucio.



  • 3.  Re: CA Plan Analyzer  SQL Design Rule 0078

    Posted Aug 17, 2017 02:13 AM

    Lucio,
    It is a pleasure to read you posts!