Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Issuing Wait-for-Enter commands against multiple objects


Some 

Catalog Manager

 commands are referred to as Wait-for-Enter (WFE) commands. These commands enable you to select multiple source objects in a list and process them collectively to save time.

You can issue commands against all objects in a list, or against sequential or nonsequential objects by using the following methods:

To issue a command against individually selected objects

  1. In the Cmd (C) column beside each source object name, type the command (see the following figure).

    Warning

    Note

    To avoid possible conflicts, include a space after commands that you type in the Cmd (C) column when those commands overlap the value in the adjoining column.

    DEFF-R ------------------------  TABLESPACE LIST  ----------------- ROW 1 OF 5
    Command ===>                                                  Scroll ===> CSR
                                                                                02
    CMD will show commands for this list.  Type command and press ENTER
    Lists: ACCTB AL BMCUHIST CA CL CO DB DS FK IC IM IS IX LK MQT MX NP OS PA PDD
    QUALIFIER: DATABASE=QZUDA1
    Cmd Tablespace      Owner  Segsz Bpool Prts  Tbls     ActivPg    Status Enc Ty
    ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
    BMCCOPY1.QZUS01A1   ASUQA      4 BP0       0    1       130        A    A
      QZUDA1.QZUS02A1   ASUQA     16 BP0       0    2       146        A    A
    BMCCOPY1.QZUS03A1   ASUQA      0 BP0       4    1      1440        A    A
      QZUDA1.QZUS04A1   ASUQA     64 BP0       0    2       540        A    A
    BMCCOPY1.QZUS05A1   ASUQA      0 BP0       4    1       720        A    A
    ******************************  BOTTOM OF DATA  *******************************
  2. Press Enter.

Issuing a shortcut command

  1. In the Cmd(C)column next to the first source object name, type the command.
  2. Type an equal sign (=) to the left of the names of the other source objectsThese objects must be of the same type as the object on which you issued the command.

    DEFF-R ------------------------  TABLESPACE LIST  ----------------- ROW 1 OF 5
    Command ===>                                                  Scroll ===> CSR
                                                                                02
    CMD will show commands for this list.  Type command and press ENTER
    Lists: ACCTB AL BMCUHIST CA CL CO DB DS FK IC IM IS IX LK MQT MX NP OS PA PDD
    QUALIFIER: DATABASE=QZUDA1
    Cmd Tablespace      Owner  Segsz Bpool Prts  Tbls     ActivPg    Status Enc Ty
    ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
    BMCCOPY1.QZUS01A1   ASUQA      4 BP0       0    1       130        A    A
    = QZUDA1.QZUS02A1   ASUQA     16 BP0       0    2       146        A    A
    = QZUDA1.QZUS03A1   ASUQA      0 BP0       4    1      1440        A    A
      QZUDA1.QZUS04A1   ASUQA     64 BP0       0    2       540        A    A
      QZUDA1.QZUS05A1   ASUQA      0 BP0       4    1       720        A    A
    ******************************  BOTTOM OF DATA  *******************************
  3. Press Enter.

To issue a command against all objects in the list

Type the command followed by the keyword ALL on the Command line of the list panel.

Table space List panel with command to copy all listed table spaces

DEFF-R ------------------------  TABLESPACE LIST  ----------------- ROW 1 OF 5
Command ===> BMCCOPY ALL                                      Scroll ===> CSR
                                                                            02
CMD will show commands for this list.  Type command and press ENTER
Lists: ACCTB AL BMCUHIST CA CL CO DB DS FK IC IM IS IX LK MQT MX NP OS PA PDD
QUALIFIER: DATABASE=QZUDA1
Cmd Tablespace      Owner  Segsz Bpool Prts  Tbls     ActivPg    Status Enc Ty
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
  QZUDA1.QZUS01A1   ASUQA      4 BP0       0    1       130        A    A
  QZUDA1.QZUS02A1   ASUQA     16 BP0       0    2       146        A    A
  QZUDA1.QZUS03A1   ASUQA      0 BP0       4    1      1440        A    A
  QZUDA1.QZUS04A1   ASUQA     64 BP0       0    2       540        A    A
  QZUDA1.QZUS05A1   ASUQA      0 BP0       4    1       720        A    A
******************************  BOTTOM OF DATA  *******************************

To exclude listed objects

  1. On the object list panel, in the Cmd (C) column next to each of the objects, mark the objects that you want to exclude by typing the designator X.

    DEFF-R ------------------------  TABLESPACE LIST  ----------------- ROW 1 OF 5
    Command ===>                                                  Scroll ===> CSR
                                                                                02
    CMD will show commands for this list.  Type command and press ENTER
    Lists: ACCTB AL BMCUHIST CA CL CO DB DS FK IC IM IS IX LK MQT MX NP OS PA PDD
    QUALIFIER: DATABASE=QZUDA1
    Cmd Tablespace      Owner  Segsz Bpool Prts  Tbls     ActivPg    Status Enc Ty
    ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v----
      QZUDA1.QZUS01A1   ASUQA      4 BP0       0    1       130        A    A
    X QZUDA1.QZUS02A1   ASUQA     16 BP0       0    2       146        A    A
      QZUDA1.QZUS03A1   ASUQA      0 BP0       4    1      1440        A    A
    X QZUDA1.QZUS04A1   ASUQA     64 BP0       0    2       540        A    A
      QZUDA1.QZUS05A1   ASUQA      0 BP0       4    1       720        A    A
    ******************************  BOTTOM OF DATA  *******************************
  2. Press Enter to process the exclusion.Catalog Manager displays the panel with the marked objects.
  3. On the Command line, type the appropriate command followed by the keyword ALL.Catalog Manager processes the command against all objects except those objects excluded by the X designator.



 

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

BMC AMI Catalog Manager for Db2 12.1