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.
To define section defaults
- On the product or solution main menu, select the Administration option.
- On the Administration Menu, select Option 2 (DOMPLEX Option Sets) or Option 4 (APPTUNE filters).
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.
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.
In the example, typing E next to DB2 Monitor List shows the following figure:
Command ===> Scroll ===> HALF
Filter: Off More: +
DB2 Subsystem ID . . . . . . . . . . . DBAC
Is this a production DB2?. . . . . . . N (Y=Yes,N=No)
Monitor with MAINVIEW for DB2 - DC . . N (Y=Yes,N=No)
Monitor with Pool Advisor/System Perf. N (Y=Yes,N=No)
Monitor with APPTUNE . . . . . . . . . N (Y=Yes,N=No)
Dynamic Explain plan name. . . . . . . DAA111D1
> 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:
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.
Related topic