Specifying global PARALLEL values for utilities
You can set the values of the PARALLEL parameter for utilities that are run from Db2 Admin Tool.
Procedure
To specify global PARALLEL values for utilities:
-
On the DB2 Administration Menu (ADB2)
panel, specify
option P, and press Enter.
Alternatively, issue the OPTIONS primary command on any Db2 Admin Tool panel.
- On the DB2 Admin Options (ADB2P) panel, specify option I, and press Enter.
- On the DB2 Admin Installation Defaults (ADBPPI) panel, option 1, and press Enter.
-
On the Utility Settings (ADBPPIU)
panel, specify
the default and maximum values for the PARALLEL keyword for the listed
utilities, and press Enter:
Figure 1. Utility Settings (ADBPPIU) panel ADBPPIU n -------------------- DD1A Utility Settings ------------------- 18:00 Command ===> Set the global default and maximum values for the utilities. Press Enter to save and continue. PARALLEL keyword: DB2 Defaults Utility Default Maximum (Default, Max) -------------------- ------- ------- --------------- CHECK INDEX . . . . . (0, 32767) COPY . . . . . . . . (0, 32767) LOAD . . . . . . . . (0, 32767) REBUILD INDEX . . . . (0, 32767) RECOVER . . . . . . . (0, 32767) REORG TABLESPACE . . (0, 32767) UNLOAD . . . . . . . (0, 32767)