Setting, updating, and deleting parameter values


Use these procedures to set, update and delete parameter values.

To set the parameter values

Related topic

  1. Use the S (Select/Modify) action code from the Variable Repository SSID Selection panel to set or change repository values.

    This panel lists the categories into which the variables are grouped.

    PMDEVDCR/I         Variable Repository Category Selection         LINE 1 OF 12
    Command ====> _______________________________________________ Scroll ===> CSR_
                                                                                  
    DB2:  DBI2                                                                     
                                                                                  
    Select one or more of the following categories.  Then press Enter.             
      S - Select/Modify Category                                                   
                                                                                  
      Category                                                                     
      ---------------------------------------                                      
    _ GENERAL                                                                      
    _ VIRTUAL STORAGE
    _ REAL STORAGE                                                             
    _ EDM POOL                                                                     
    _ PERFORMANCE PROFILE VARIABLES
    _ RID POOL                                                                     
    _ SORT POOL                                                                    
    _ BUFFER POOLS                                                                 
    _ GROUP BUFFER POOLS  
    _ NOTIFICATIONS                                                         
    _ LOGGING                                                                      
    _ THREADS                                                                      
    _ DDF                                                                          
    _ OPEN DATASETS
  2. Use the S (Select/Modify Category) action code to display a list of variables associated with the selected category.

    • If you select a category that represents a single entity (for example, RID pool), the Variable Repository Variables panel is displayed.
    • If you select a category that represents multiple entities (for example, buffer pools), the Repository Subcategory Selection panel is displayed below.
    PMDEVDSC/I           Repository Subcategory Selection             LINE 1 OF 81
    Command ====> _______________________________________________ Scroll ===> CSR_
                                                                                  
    DB2:  DBI2                                                                     
    Current Category :  BUFFER POOLS                                               
                                                                                  
    Select one or more items from the following list. Then press Enter.            
      S - Select/Modify Category                                                   
                                                                                  
     Subcategory                                                                   
     ---------------------------------------                                       
    _ BP GLOBAL                                                                    
    _ BP0                                                                          
    _ BP1                                                                          
    _ BP2                                                                          
    _ BP3                                                                          
    _ BP4                                                                          
    _ BP5                                                                          
    _ BP6                                                                          
    _ BP7                                                                          
    _ BP8                                                                          
    _ BP9                                                                          
    _ BP10                                                                         
    _ BP11
  3. Use the S (Select/Modify Category) action code to select one or more entries to be updated.When you select a category or a subcategory, the following panel is displayed:

    PMDEVDVE/I          Variable Repository Variables                  LINE 1 OF 12
    Command ====> ________________________________________________ Scroll ===> CSR_

    SSID DB2            :  DEKS
    Current Category    :  RID POOL
    Current Subcategory :  N/A

    Type a new value in the < New Value > field. Then press Enter to validate.
    Type F3 to exit and update or F12 to cancel.

    Use the D action code to remove a value from the repository. Press Enter.
      D - Delete
                                   Current/                                        
    A Variable name                New Value     Units            Range            
    - ---------------------------  -----------   ---------------  ----------------
    _ RIDSIZE_DEC                   40000        KB                0-25000000
                                  <             >                             
    _ RIDSIZE_DEC_PERCENT                        PERCENTAGE        1-10
                                  <             >
    _ RIDSIZE_INC                   40000        KB                0-25000000
                                  <             >
    _ RIDSIZE_INC_PERCENT                        PERCENTAGE        1-10
                                  <             >
    _ RIDSIZE_MIN                   300000       KB                0-10000000
                                  <             >
    _ RIDSIZE_MAX                   500000       KB                0-10000000
                                  <             >
  4. Use this panel to set new values for the variables listed on the panel or to change existing values.If no value was previously set in the repository for a variable, no Current value is listed. If a value was previously set in the repository, it is displayed as the Current value.

To change the value or to set a new value

  1. Type the new value in the New Value field.Ensure that the new value falls within the range specified on the panel.
  2. Press Enter.The new value is validated.
  3. Press F3 to update the value.Message BMC24253 confirms that the update is successful.

To delete a value

  1. Use the D action code to mark an entry to be deleted from the repository. The Current value is removed from the panel when you press Enter, but the value is not deleted until you exit from the panel.
  2. Press F12 to cancel any changes or deletions that you made.


 

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

BMC AMI Pool Advisor for Db2 13.1