Skip to Content

Adding objects to an object set

Use this procedure to add objects to an object set after it has been retrieved from the repository.

You can select those table spaces and indexes you want to add to the object set. Full subsystem object sets created by ARMBGPS cannot be updated using this method.

Related topics

Updating-object-sets

Creating-a-new-object-set

Before you begin

To perform this procedure, you need the following authorizations (if you are not the creator of the object set):

  • EXECUTE authority for the BMC AMI Recovery Manager Db2 plan
  • TYPE O authority if you do not plan to save changes to the object set
  • TYPE A authority if you plan to save changes to the object set
  • DISPLAY DATABASE authority to list all objects in recover pending status when you attempt to add such objects to the target object set

To add objects to an object set

  1. Display the object set by performing the following steps:
    1. In the BMC AMI Recovery for Db2 Main Menu, select 1. Appl object sets.
    2.  Enter an object set name or wildcard pattern to display one or more object sets.
    3. Place S or SA by the object set you want to select on the Object Set List panel.

  2. In the Object List panel for the target object set, select 5. Add objects and then press Enter.

    Warning

    Important

    You can display a CI column on the Object List panel. CI stands for Clone and Instance. This column is populated with N1 or N2 or Y1 or Y2. N indicates not cloned and Y indicates cloned. The number is the instance of the base. The CI column is for information only and does not affect the operation of this panel. You use the SHOWCI command to display this column. The default is to not display the CI column when entering the panel from an object set. You enter the SHOWCI command on the Command line to display the CI column. Entering the SHOWCI command again toggles the CI column off.

    ARMOB001 ===== Object List - PUBLIC   ACPDBMRN_IS                Row 1 from 25
    Command ===> ________________________________________________ Scroll ===> PAGE
                                                                                  
    Type option or action code. Then press Enter.                                 
      Option. . _ 1. Recovery point  2. Object Set edit   3. Gen recover JCL background
                  4. Gen backup JCL foreground       5. Add objects                
                  6. Gen backup JCL background                                     
    Act codes: X=Exclude Z=Zoom E=ExpandRange                                     
     Act Status T/X Name                        DSNUM                               
    __   OK     T  ACPDBMRN TSMRNN1               0                                
    __   OK      X ACP      ICMRNN1               0                                
    __   OK      X ACP      INMRNN1               0                                
    __   OK     T  ACPDBMRN TSMRNN32              0                                
    __   OK      X ACP      ICMRNN32K             0                                
    __   OK      X ACP      INMRNN32K             0                                
    __   OK     T  ACPDBMRN TSMRNP1               0                                
    __   OK      X ACP      ICMRNP1               0                                
    __   OK      X ACP      INMRNP1               0
    Warning

    Important

    If a table space has not changed, any associated COPY NO indexes are set to the status TS STAT and are not recovered. Indexes are only recovered for changed table spaces.

  3. In the Object Selection panel, select a method of adding objects, then press Enter to continue.

    Warning

    Important

    Volume and Exception status are not valid choices when adding objects to an existing object set

    For SQL, select option 5. Add objects to define additional SQL SELECT statements in the object set definition.

  4. When the Selection for Object List Generation panel appears, perform the following substeps:
    1. Type a wildcard pattern or the name of the object to be added.
    2. Select Replace (the default).
    3. Press Enter to list the specified objects.
    4. Type the action code S by the objects to be added. Type SA to add all objects in the list.
    5. Press Enter.
  5. When the List Generation Options panel appears, perform the following substeps:
    1. Choose to include or exclude objects and indexes related by referential integrity.
    2. Press Enter to return to the Object List panel for the target object set.All selected objects are now included in the object list for the target object set.
  6. Press F3 to exit or save the object set to the repository. Select Save, SaveAs, Exit, or Cancel, as required.

 

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

BMC AMI Recovery Manager for Db2 13.1