Database and areas selection


The DBD keyword identifies the name of the DEDB (DBD name) to be reorganized. The DBD keyword is required for offline reorganization processing.

The IAREA keyword can be used to select specific areas to be reorganized. If you omit the IAREA keyword, all areas defined in the DEDB are reorganized.

Areas can be specified on the IAREA keyword by using any combination of area names, area numbers, or area ranges. The following parameters are available for the IAREA keyword:

  • IAREA=ALL (default) or IAREA=* specifies all areas of the DEDB.
  • IAREA=areaname specifies one or more areas by using the one-character to eight-character area name for each area specified. Multiple area names must be enclosed in parentheses and separated by commas.
  • IAREA=areanumber specifies one or more areas by using the one-character to five-character area number for each area specified. Multiple area numbers must be enclosed in parentheses and separated by commas.
  • IAREA=(RANGE=(startarea,endarea)) specifies a consecutive range of areas using either areaname or areanumber parameters. The area number associated with startarea must be less than the area number associated with endarea.

An asterisk (*) can be used to specify all areas of the DEDB. When the * character is used with the RANGE keyword, it can be used to specify the beginning or ending range for specific areas of the DEDB.

To reorganize an entire DEDB, use a command set like the example shown in the following figure.

REORGANIZE DBD=dbdname,IAREA=ALL

To reorganize specific areas, use a command set like the example shown in the following figure.

REORGANIZE DBD=dbdname,IAREA=(AREANAM1,AREANAM3,RANGE=(5,8))

This control statement uses a combination of area names and area numbers to request that the specified areas are to be reorganized. The UOWs in areas named AREANAM1 and AREANAM3 will be reorganized. Also, all consecutive areas from area number 5 to area number 8 (area5, area6, area7 and area8) will be reorganized.


 

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