Variable repository

The variable repository stores the values for parameter variables. These values are used to modify storage resources when the advisors recommend changes. Initially, Pool Advisor uses default values when changes are recommended, but if you find that the recommended changes based on these default values are no longer appropriate, you can use the variable repository to modify the values. The variable repository consists of a series of easy-to-use panels that list the variables and provide fields for you to type new values from a range of acceptable values. You can access the variable repository by clicking on the CONFIG button on Pool Advisor reports. The variable repository provides a method for editing parameter variables through a series of panels. The panels outline all of the variables, giving you the opportunity to edit any or all of the values. There are two possible modes of operation for the variable repository which are termed Local Repository Mode and Central Repository Mode.

Setting up Local and Central repository mode

BMC.DB2.SPE2301

The Local Repository Mode is the default mode for the variable repository. To select the Central Repository Mode or to switch between modes, follow these steps:

In any Pool Advisor report, click CONFIG.
From the Configuration Menu, select 4. Central Variable Repository Customization and then press Enter.
After you set the Mode; run DOM, REFRESH command to make latest mode effective.
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
On the Central Variable Repository Selection panel, enter category as #DBC.
PMDECVAR/I          Central Variable Repository Selection          LINE 1 OF 1
Command ====> _______________________________________________ Scroll ===> CSR_


Select an item with following action codes. Then press Enter.

   S - Select/Modify

    DBC
   ----
   #DBC
On the Variable Repository Category Section panel, enter GENERAL as the category.
PMDECDCR/I         Variable Repository Category Selection          LINE 1 OF 1
Command ====> _______________________________________________ Scroll ===> CSR_

Db2: #DBC

Select one or more of the following categories. Then press Enter.
   S - Select/Modify Category

   Category
   --------
   GENERAL
On the Central Repository Variables panel, enter a value for the CENTRAL_VARIABLE variable:
- To select the Central Repository Mode, set the value to Y.
- To select the Local Repository Mode, set the value to N.
PMDEVDVE/I          Variable Repository Variables                  LINE 1 OF 2
Command ====> _______________________________________________ Scroll ===> CSR_

SSID Db2            : #DBC
Current Category    : GENERAL
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
- --------------------------- -----------   --------------- ----------------
_ CENTRAL_VARIABLE                           N/A               Y,N
                               < Y           >

Local Repository Mode

If you decide to monitor the Db2 again with the same Data Collector, default values are computed for all variables until you set new values in the repository. You can delete the entries that are associated with #ALL, but you cannot delete the #ALL record. One variable repository is created for each Data Collector. Use the variable repository for a Data Collector to set values for parameter variables for all Db2 subsystems that have been monitored by that Data Collector (whether or not they are currently being monitored).

Select option 1 (View and edit product variables) from the Configuration Menu to access variable repository functions. The following figure shows Variable Repository SSID Selection panel.

PMDEVDSR/I         Variable Repository SSID Selection              LINE 1 OF 3
Command ====> _______________________________________________ Scroll ===> CSR_

Select an item with one of the following action codes. Then press Enter.

  S - Select/Modify SSID   D - Delete SSID   L - List Repository Variables

   DB2
  ----
_ #ALL
_ DEDK
_ DGE3
_ DHI1

This panel lists all of the Db2 subsystems that are associated with the Data Collector. The panel also includes an option (#ALL) for assigning the same variable values to all Db2 subsystems in the list. This panel is only displayed when Pool Advisor has been initialized in Local Repository Mode.

Important

If you specify a global value for a parameter (using #ALL) and you specify a different value for the same parameter for a specific Db2 subsystem, the Db2 subsystem value overrides the global value.

If you change a global value for a parameter using #ALL, you must recycle the Data Collector for changes to take effect for all Db2 subsystems that do not have a Db2-specific parameter specified. If you have previously specified a Db2-specific parameter and would like the #ALL variable to take effect after a Data Collect recycle, you must delete the parameter coded for the Db2 SSID.

If you are no longer using the current Data Collector to monitor a Db2 subsystem that is included in the list, you can use the D action code to delete the subsystem from the list. All of the specifications for that Db2 subsystem are removed from the repository for the Data Collector.

If you delete the variables from the repository, you should also delete the Db2 subsystem from the list of Db2 subsystems being monitored by this Data Collector in the DOMPLEX option set. If you do not remove it from the monitor list, you must recycle the Data Collector to reestablish the default values.

Central Repository Mode

BMC.DB2.SPE2301

The variable repository is created for each Data Collector. Use the variable repository for a Data Collector to set values for parameter variables for all Db2 subsystems that have been monitored by that Data Collector (whether or not they are currently being monitored).

Select option 1 (View and edit product variables) from the Configuration Menu to access variable repository functions. The following figure shows Variable Repository SSID Selection panel.

PMDEVDSR/I         VARIABLE REPOSITORY SSID SELECTION             LINE 1 OF 18
COMMAND ====> _______________________________________________ SCROLL ===> CSR_


SELECT AN ITEM WITH ONE OF THE FOLLOWING ACTION CODES. THEN PRESS ENTER.

   S - SELECT/MODIFY SSID   D - DELETE SSID   L - LIST REPOSITORY VARIABLES

       DB2
   -----------
_ #PLX
_ @D#DSNDLY
_ @D#DSNDNY
_ @D#DSNDOD
_ @D#DSNDOE
_ @D#DSNDOF
_ @L#ESAJ
_ @L#SYSM
_ DEJV
_ DENF
_ DLYK
_ DLY7
_ DNYK
_ DOD1
_ DOD2
_ DOE1
_ DOE2
_ DOF

This panel lists all of the Db2 subsystems that are associated with all Data Collectors defined in a DOMPLEX. The panel also includes following options:

#PLX—Assign the same variable values to all Db2 subsystems in the list.
@D#(dataSharingGroup)—Assign the same variable values to all Db2 subsystems that belongs to the same Data-sharing Group.
@L#(LPAR)—Assign the same variable values to all Db2 subsystems that belongs to the same LPAR.

Important

If you specify a global value for a parameter (using #PLX or Data-sharing Group or LPAR) and you specify a different value for the same parameter for a specific Db2 subsystem, the Db2 subsystem value overrides the global value.

If you change a global value for a parameter using Data-sharing Group, you must recycle the Data Collector for changes to take effect for all Db2 subsystems that are part of the Data-sharing Group that do not have a Db2-specific parameter specified. If you have previously specified a Db2-specific parameter and would like the Data-sharing Group variable to take effect after a Data Collect recycle, you must delete the parameter coded for the Db2 SSID.

If you change a global value for a parameter using LPAR, you must recycle the Data Collector for changes to take effect for all Db2 subsystems running on that LPAR that do not have a parameter specified at Db2 or Data-sharing Group level. If you have previously specified parameter at Db2 or Data-sharing Group level and would like the LPAR variable to take effect after a Data Collect recycle, you must delete the parameter coded for these levels.

If you change a global value for a parameter using #PLX, you must recycle the Data Collector for changes to take effect for all Db2 subsystems that do not have a parameter specified at Db2 or Data-sharing Group or LPAR level. If you have previously specified parameter at Db2 or Data-sharing Group or LPAR level and would like the #PLX variable to take effect after a Data Collect recycle, you must delete the parameter coded for these levels.

If you are no longer using the current Data Collector to monitor a Db2 subsystem that is included in the list, enter D on the Variable Repository SSID Variable panel to delete the subsystem from the list. All of the specifications for that Db2 subsystem are deleted from the repository for the Data Collector. If you delete the variables from the repository, you must also delete the Db2 subsystem from the list of Db2 subsystems being monitored by this Data Collector in the DOMPLEX option set. If you do not remove it from the monitor list, you must recycle the Data Collector to reestablish the default values. If you decide to monitor the Db2 again with the same Data Collector, default values are computed for all variables until you set new values in the repository. You can delete the entries that are associated with #PLX, but you cannot delete the #PLX record.

To migrate variables from the Local Repository to the Central Repository

(BMC.DB2.SPE2304)

Before the introduction of the Central Repository mode, all variables were maintained in the local variable repository. If you have already established variable settings in the Local Repository mode, you might want to migrate those variable settings to the central variable repository by using the following procedure, eliminating the need to manually transcribe each individual variable setting: This functionality will allow users to select source and destination targets. For example, one might decide that the #ALL variable settings from a local repository are sufficient for use as the #PLX variables in Central Repository Mode.

To migrate variable settings under Local Repository Mode to Central Repository Mode, follow these steps:

From the Configuration Menu, select option 5. Model Variables from Local to Central Repository.
PMDECNFG/I                    Configuration Menu                      05:52:10
Command ====> ________________________________________________________________


Select one of the following options. Then press Enter.

5 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
To migrate the variables for one Db2 subsystem or #ALL, enter S next to it, and press ENTER.
PMDEMVLC/I         Local Variable Repository Selection             LINE 1 OF 4
Command ====> _______________________________________________ Scroll ===> CSR_


Select an item and then press Enter.

  S - Select/Copy SSID

      Db2
  -----------
_ #ALL
_ DEJV
_ DLX1
s DNYK
The Local Variable Repository Variable List panel lists all variables that are currently being used by the local variable repository and their values.
PMDEMVL1/I         Local Variable Repository Variable List       LINE 1 OF 131
Command ====> _______________________________________________ Scroll ===> CSR_

SSID Db2 : DNYK

This SSID contains the following variables with their values.
Press Enter to continue and PF3 to exit.
Variable name                Value
--------------------------- -----------
BP#ALL_DPMAX                 100000
BPREALMB                     40
BPREDUCE                     N
DBDSIZE_DEC                  5000
DBDSIZE_INC                  5000
DBDSIZE_MAX                  51200
DBDSIZE_MIN                  30720
DEFRSTAVAIL_ALERT            629.2
DEFRSTAVAIL_NOTE             943.8
DEFRSTAVAIL_WARN             786.5
EDMSIZE_DEC                  25000
EDMSIZE_INC                  25000
EDMSIZE_MAX                  307200
EDMSIZE_MIN                  184320
GBP_STATE_GP0                2
GBP_STATE_GP16K0             2
GBP_STATE_GP32K              2
GBP_STATE_GP8K0              2
PMDJ_PROCESSED               Done
RIDSIZE_DEC                  100000
RIDSIZE_INC                  100000
PF 1=Help    2=Split   3=End     4=Sort A 5=Sort D 6=Zoom    7=Up
PF 8=Down    9=Swap   10=Left   11=Right 12=Cancel
Press ENTER to confirm your selection, or click PF3 to terminate.
Press ENTER again.
The Central Variable Repository Selection panel is displayed, listing the Db2 subsystems, data sharing groups, LPARs, and #PLX that are associated with all Data Collectors defined in a DOMPLEX
PMDEMVL2/I         Central Variable Repository Selection           LINE 1 OF 9
Command ====> _______________________________________________ Scroll ===> CSR_


Select SSID and then press Enter.

   S - Select SSID

       Db2
   -----------
_ #PLX
_ @D#DSNDLX
_ @D#DSNDLY
_ @D#DSNDNY
_ @L#ESAJ
_ DEJV
_ DLX1
_ DLYC
_ DNYK
Specify the destination to which to migrate the variables from the local variable repository by entering S next to the Db2 subsystem, data sharing group, LPAR, or #PLX.
PMDEMVL2/I         Central Variable Repository Selection           LINE 1 OF 9
Command ====> _______________________________________________ Scroll ===> CSR_


Select SSID and then press Enter.

   S - Select SSID

       Db2
   -----------
s #PLX
_ @D#DSNDLX
_ @D#DSNDLY
_ @D#DSNDNY
_ @L#ESAJ
_ DEJV
_ DLX1
_ DLYC
_ DNYK
Press ENTER.
The variables are migrated to the central variable repository.
PMDEMVL2/I         Central Variable Repository Selection           LINE 1 OF 9
Command ====> _______________________________________________ Scroll ===> CSR_
BMC24253 : Variable repository successful update

Select SSID and then press Enter.

  S - Select SSID

      Db2
  -----------
_ #PLX
_ @D#DSNDLX
_ @D#DSNDLY
_ @D#DSNDNY
_ @L#ESAJ
_ DEJV
_ DLX1
_ DLYC
_ DNYK

This section contains the following topics: