Access Storage Group Functions

carcudb219
You can access storage group functions by requesting to create, alter, template, or drop a storage group.
To access storage group functions, do one of the following:
  • To create a storage group, enter 
    C
     in the Option field and 
    S
    G in the Object field of the main header and press Enter.
  • To alter, template, or drop a storage group, enter 
    A
    T
    , or 
    D
    , respectively, in the Option field and 
    SG
     in the Object field of the main header and press Enter. Enter a storage group name in the Item Name field and a user ID in the Creator field to get a more specific selection list.
 
 
2
 
2
 
 
Selection Panels
When altering, dropping, or creating (by template) a view, a selection panel is presented to select the view if not already specified. Make the view selection list more specific by specifying selection criteria for the Item (view) Name and Creator ID prompts in the header.
Use the EQF facility to further specify the views displayed, and use scrolling commands to scroll through information.
The View Selection screen displays all the fields available in the SYSIBM.SYSTABLES table. This information is available to make selection of the views easier.
To choose items from the listing, type 
next to the items to select. Press Enter to register the selection. For information about the fields, press F1 (Help).
Selection Criteria
The Item Name and Creator fields let you specify a specific storage group name or search conditions for retrieving multiple objects. These fields accept the following SQL search criteria:
  •  
    Asterisk (*)
    Selects all objects. All storage groups in the system are displayed.
  •  
    Percent sign (%)
    Is a wild card character that will match zero or more characters.
  •  
    Underscore (_)
    Indicates that any one character can occupy that position.
The Stogroup selection panel displays information from the SYSIBM.SYSSTOGROUP table to make selection of the storage groups easier.
To choose items from the listing, type an S (select) in the S column next to the items you want to select. You can also enter a question mark (?) or query option, to display a CA RC/Query menu or report for the option specified. CA RC/Query provides report options for different object types.
Press Enter to register the selection:
  • For templates and alters, each storage group selected is processed individually, beginning with the storage group first on the selection list, and continuing in the order of the selection list.
  • For standard drops, all selected storage groups are dropped together.
  • For recoverable drops, each storage group is dropped one at a time.
VCAT Selection List
If the name of the VCAT you want to use is not known, enter an asterisk (*) in the Vcat field of the storage group screen. This provides a complete listing of VCATs currently referenced within DB2. Selection criteria can also be entered for a partial listing. When you press Enter, a list of VCATs appears from which you can select.
Insert a Volume from Another Storage Group
The Volser field on the storage group screen indicates the names of the volume serial IDs that you want to include.
 
Follow these steps:
 
  1. Insert a new volume (unless overwriting an existing volume).
  2. Enter the first letters of the volume name followed by a percent sign (%) in the Name field.
    If the volume name is unknown, you can enter an asterisk (*) to display a list of 
    all
     volumes from 
    all
     current storage groups. However, this can be very time-consuming.
  3. Press Enter.
    The Volume Selection List screen appears.
  4. Type 
    S
     next to each volume to select and press Enter.
    Enter the S (shrink) toggle command in the command line to view the volumes that have been queued.
  5. Press F3 (End) to return to the Storage Group screen.
    The selected volumes are automatically inserted.
Storage Groups vs. VSAM Data Sets
To maintain closer control over the physical storage of tables and indexes, users can define and manage their own VSAM data sets instead of using storage groups. To do this, there must be at least one VSAM catalog. The VSAM data sets can then be defined and managed by selecting a specific (explicit) VCAT when creating tablespaces and indexes.
Storage Group Commands
The HEADER and COMPARE commands can make working with storage groups easier as follows:
  •  
    HEADER
    Toggles the header on and off. This is helpful when viewing a long list of VCATs or volumes. Enter 
    or 
    HEADER 
    in the command line to toggle the header.
  •  
    COMPARE
    Displays old and new versions of the storage group for comparison. Use the RESET command to reset a changed volume to its original status.