Defining section defaults

(Apptune only) You can create section default values for each DOMPLEX option set or Apptune filter set. 

The values that you select for section defaults are used whenever a new instance of the section is inserted. If you change a value in a section default, any instance that matched that value is eligible to be updated to the new value.

Related topic

Working-with-option-sets

 

Example

In the DOMPLEX option set, if you have defined the default value of deferred write time as 60 seconds, and then change it to 80 seconds, the product asks if you want to update the value of all instances with the current value of 60 to 80.

Tip

We recommend using generic names for fields such as Db2 Subsystem ID or Data Collector ID to make it obvious that the field needs to be updated when a new instance is inserted.

To define section defaults

  1. On the product or solution main menu, select the Administration option.
  2. On the Administration Menu, select Option 2 (DOMPLEX Option Sets) or Option 4 (APPTUNE filters).

  3. Type E next to the option set for which you want to specify section defaults and press Enter.If there is no option set, you must create one. See Creating-a-DOMPLEX-option-set or Creating-a-filter-option-set.

    For the DOMPLEX option set, a panel similar to Panel for a new option set is displayed.

              OptionsetName - Description                     
     Command ===>                                              Scroll ===> CSR  
                                                                                   
     Filter: Off                                                         More:      
     + DOMPLEX Parameters             Parameters that apply to entire DOMPLEX     
     + Data Collector List (1)        Data Collector(DBC) subsystems in DOMPLEX   
     + DB2 Monitor List (12)          DB2 Sub-systems to be monitored             
     + OutGp DCID DspSize (6)         Output Groups - valid range: 001-256        
     ****************************** End of List *******************************
     +/- expandable section (enter ? for action menu), > zoomable field
    • You can create section defaults for any section that is followed by a number in parentheses. In this example, three sections are followed by a count of instances in parentheses. In this example, there is one Data Collector defined, 12 Db2 subsystems, and 6 output groups.

  4. Type E next to the relevant section.For the DOMPLEX option set, you can create default values for specific parameters of the following sections:

    • Data Collector List
    • DB2 Monitor List
    • Output Groups

    For the Apptune Filter option set, you can create default values on the filter row.

    Important

    To resolve validation errors or to save despite validation errors, see Resolving-validation-errors.

In the example, typing E next to DB2 Monitor List shows the following figure:

                        DB2 Monitor List - Section Defaults  

Command ===>                                    Scroll ===> HALF
                                                                             
Filter: Off                                             More:   +
DB2 Subsystem ID . . . . . . . . . . .  DBAC                 
Is this a production Db2?. . . . . . .  N        (Y=Yes,N=No)
Monitor w/ BMC AMI OpsM for Db2 - DC .  N        (Y=Yes,N=No)
Monitor w/ BMC AMI Pool Advisor for Db2 N        (Y=Yes,N=No)
Monitor w/ BMC AMI Apptune for Db2 . .  Y        (Y=Yes,N=No)
Auth ID for Explain and trace. . . . .           (blank: Install-SYSADM)
Dynamic Explain plan name. . . . . . .  DAA131QA             
> DB2 IFCIDs to be traced automatically                   
> DB2 IFCIDs to be discarded                              
> BMC IFCIDs to be discarded                              
Class  2-In-DB2 elapsed timing info. .  Y        (Y=Yes,N=No)
Class  3-DB2 suspend timing info . . .  Y        (Y=Yes,N=No)
Class  5-Time spent doing IFI requests  N        (Y=Yes,N=No)
Class  7-DB2 events (packages, DBRMs).  N        (Y=Yes,N=No)
Class  8-Wait time for packages. . . .  N        (Y=Yes,N=No)
Class 10-Optional package detail data.  N        (Y=Yes,N=No)
Collect dynamic SQL stats in stmt cache Y        (Y=Yes,N=No)
Collect static SQL stats in stmt cache  Y        (Y=Yes,N=No)
+ SQL Performance/APPTUNE options                            
********************************* End of List ***************
                                                            
+/- expandable section (enter ? for action menu), > zoomable field

For example, if all of the Class fields were changed to N and the previous value of Y matched the existing instances of the 12 defined Db2 subsystems, after pressing F3 to save the changes, the following panel would be displayed:

                      Apply Section Defaults Updates                     
  LGCW1004                                                Changes applied
  Updates to the model can be applied to the following 12 rows.          
                                                                        
  _ Enter "/" to select all rows or select individual rows in the list.  
                                                                        
    DB2 Monitor List                                   More:   +
  _ DB2A           DB2 SSID                            
  _ DB2B           DB2 SSID                            
  _ DB2C           DB2 SSID                            
  _ DB2D           DB2 SSID                            
  _ DB2E           DB2 SSID                            
  _ DB2F           DB2 SSID                            
  _ DB2G           DB2 SSID                            
  _ DB2H           DB2 SSID                            
  _ DB2I           DB2 SSID                            
  _ DB2J           DB2 SSID                            
  _ DB2K           DB2 SSID                            
  _ DB2L           DB2 SSID                            
                                                                        
  Press END to update the selected rows.

To change the value from Y to N for all 12 instances, type / on the first action line containing the prompt: Enter "/" to select all rows or select individual rows in the list.

To change the value from Y to N for only DB2A and DB2B, type / on the action lines next to those Db2 subsystems.

 

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