Editing an option set
You can edit the option sets by executing the product's CLIST or the LGCISPF CLIST. All methods invoke the same LGC dialog.
Before you begin
The DBC started task must be running and the LGC agents must be active.
To edit an option set
- On the Options Set panel, type E next to the option set that you want to edit and press Enter.
Expand each section and review or change the values.
- Save your option set by pressing F3.
Example of working with default values for option sets
This example demonstrates how to create default values for a section in an option set. Doing so allows you to define your own default values so that whenever you insert new instances of a section, you will have fewer values to update.
The values that you specify for section defaults are used whenever you insert a new instance. If you change a value in a section default, any value in an instance that matched that value prior to the change is eligible for being updated to the new value. This process allows you to change the values in multiple instances of a section at once, without opening and closing each instance.
Access the LGC panel for editing the option set (as described in Accessing-the-online-interface).
The following figure shows an example of a panel for a new DOMPLEX option set used by the System and SQL Performance products. Each product lists different options.
Panel for a new option set
File Filter Confirm Help
-----------------------------------------------------------------------------
DBCRIOPT - DOMPLEX FOR DBCRI101
Command ===> Scroll ===> CSR
Filter: Modified More:
+ DOMPLEX Parameters Parameters that apply to entire DOMPLEX
+ Data Collector List (3) Data Collector(DBC) subsystems in DOMPLEX
+ DB2 Monitor List (16) DB2 Sub-systems to be monitored
+ OutGp DCID DspSize (9) Output Groups - valid range: 001-256
********************************* End of List ********************************
+/- expandable section (enter ? for action menu), > zoomable fieldTo update section default values, type E next to the relevant section.
The LGC interface displays a panel that allows you to define the default values pertinent to that section.
For example, typing E next to DB2 Monitor List displays the panel shown in the following figure.
Example panel for defining defaults
File Filter Confirm Help
-----------------------------------------------------------------------------
LGCP1001 DB2 Monitor List - Section Defaults
Command ===> Scroll ===> CSR
Filter: Off More: +
DB2 Subsystem ID . . . . . . . . . . . SSID
Is this a production DB2?. . . . . . . N (Y=Yes,N=No)
Monitor with MAINVIEW for DB2 - DC . . Y (Y=Yes,N=No)
Monitor with Pool Advisor/System Perf. Y (Y=Yes,N=No)
Monitor with APPTUNE . . . . . . . . . Y (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 Y (Y=Yes,N=No)
Class 7-DB2 events (packages, DBRMs). Y (Y=Yes,N=No)
Class 8-Wait time for packages. . . . Y (Y=Yes,N=No)
Class 10-Optional package detail data. Y (Y=Yes,N=No)
Collect dynamic SQL stats in stmt cache N (Y=Yes,N=No)
Collect static SQL stats in stmt cache N (Y=Yes,N=No)
+ SQL Performance/APPTUNE options
********************************* End of List ********************************Make the changes to the option set.
For example, assume that all of the Class fields were changed to N and the previous value of Y matched the existing instances of the defined Db2 subsystems.
Press F3 to save the changes and display the panel shown in the following figure.
Apply Sections Defaults Updates
--------------------- 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.- Take one of the following actions:
- To change the value from Y to N for all instances, type / next to Enter '/' to select all rows or select individual rows in the list field.
- To change the value from Y to N for only select instances, type / on the action lines next to those specific entries.
- Press F3 to save your changes.
Related topic