Referencing LISTDEF lists in other utility jobs
You can use a list of objects that was defined with a LISTDEF control statement as a target object for another utility.
Procedure
To reference LISTDEF lists in other utility jobs:
Results
In general, utilities process the objects in the list in the order in which they are specified. However, some utilities alter the list order for optimal processing. The following table shows the utilities that support the LIST keyword and how each utility processes the list.
| Utility | Order of list processing |
|---|---|
| CHECK INDEX | Items are grouped by related table space. All index spaces that are related to a particular table space are processed at one time, regardless of list order. |
| COPY | Items are processed in the specified order on a single call to COPY. The PARALLEL keyword is supported for a list, but if used, the order of processing is determined by Db2®. |
| COPYTOCOPY | Items are processed in the specified order on a single call to COPYTOCOPY. |
| MERGECOPY | Items are processed in the specified order. |
| MODIFY RECOVERY | Items are processed in the specified order. |
| MODIFY STATISTICS | Items are processed in the specified order. |
| QUIESCE | All items are processed in the specified order on a single call to QUIESCE. |
| REBUILD | Items are grouped by related table space. All index spaces that are related to a particular table space are processed at one time, regardless of list order. |
| RECOVER | Items are processed in the specified order on a single call to RECOVER. |
REORG![]() |
Items are
processed in the specified order with one exception. Items at the partition level are grouped by
table space when the first partition of a particular table space is encountered. Those partitions
are processed on a single call to REORG. ![]() |
| REPORT | Items are processed in the specified order. |
| RUNSTATS INDEX | Items are grouped by related table space. All index spaces that are related to a particular table space are processed at one time, regardless of list order. |
| RUNSTATS TABLESPACE | Items are processed in the specified order. |
| UNLOAD | Items at the partition level are grouped by table space. All specified partitions of a particular table space are processed at one time, regardless of list order. |
REORG