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
- Issuing a shortcut command
- To issue a command against all objects in the list
- To exclude listed objects
To issue a command against individually selected objects
In the Cmd (C) column beside each source object name, type the command (see the following figure).
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 *******************************- Press Enter.
Issuing a shortcut command
- In the Cmd(C)column next to the first source object name, type the command.
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 *******************************- 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
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
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 *******************************- Press Enter to process the exclusion.Catalog Manager displays the panel with the marked objects.
- 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.
Related topic