Parameter variables and rules

When the Pool Advisor Data Collector contacts a Db2 subsystem for the first time, it reads the Db2 ZPARM values and uses them to create the default values for product parameters.

The parameters based on the ZPARM values are stored in a repository. These computed values are stored in the repository only once. If the Db2 value changes (either temporarily or permanently), Pool Advisor is not aware of the change and continues to apply thresholds to the values in the repository.


Related topic

Using

When Pool Advisor determines that changes should be made to the size of resources or what the maximum and minimum thresholds should be, it uses the following values by default:

  • Increase resource by 10% of ZPARM value
  • Decrease resource by 10% of ZPARM value
  • Increase resource by a maximum of 25% of ZPARM value
  • Decrease resource by a maximum of 25% of ZPARM value

If you find that the recommended changes based on these default values are no longer appropriate (for example, because of changes to ZPARM values), you can modify the default values.

Modifications are made in the variable repository. You can access the variable repository by clicking on the CONFIG button on Pool Advisor reports.

PMDECNFG/I                    Configuration Menu                      05:52:10
Command ====> ________________________________________________________________
                                                                             
                                                                             
Select one of the following options.  Then press Enter.                       
                                                                             
  1. View and edit product variables                                          
  2. Refresh object names from Db2 catalog                                    
  3. Reset initialization parameters to default values                        
  4. Central Variable Repository Customization                                
  5. Model Variables from Local to Central Repository

Use the Configuration menu to perform the following tasks:

  • View and edit product variables
    Select this option to display and edit the values for the thresholds upon which Pool Advisor acts to recommend corrective actions.
  • Refresh object names from Db2 catalog
    Select this option to issue a command that refreshes the names of all objects that have been created since Data Collector startup.
  • Reset initialization parameters to default values
    Use this option to cancel any changes that you made to the parameter values for a Db2 subsystem. The parameters revert to the default values shipped with the product.
    Selecting this option displays the Advisor Interface. The product inserts the PMDZDROP command in the Advisor text field. Use the following syntax to revert to default values: PMDZDROP DB2ssid.
  • BMC.DB2.SPE2301Central Variable Repository Customization
    Select this option to set the Product either in Local or in Central Repository Mode. When either of the options is selected then execute DOM, REFRESH command to make it effective.

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*