The Default/Profile element contains the default extraction environmental options.
Note: Other profile elements may be created with a different set of profile settings. Each additional profile element has an element version of "profile", for example "CUSTOM1/PROFILE".
The options of the Profile element are provided in the following table.
Table 11. Profile Elements
| Element | Description |
| RAW | This is the file allocation sizing for the raw files extracting the RDMS records. It is used for intermediate data files used during extraction. |
| FORMAT | This is the file allocation sizing for the formatted files. It is used for the result files that will be read from another system. |
| FETCHSIZE | The number of records dumped as a block. This value limits the number of records retrieved in a single database access. The value should be in the range of 1 to 999999. |
| LOCK | The type of locking to apply to the table during extraction. The value indicates if the table should be locked or not during extraction. The two allowed values are NONE and PROTECTED. |
The same element cycling, image length, and syntax rules that apply to the CONFIG$ file also apply to the contents of the DEFAULT/PROFILE file and its profile settings.
The RAW and FORMAT profile settings provide a value that are a portion of a OS 2200 @CAT statement as follows:
@CAT,P FILE.,value
Where value can contain valid OS 2200 command syntax (including commas) to allow specification of pack-ids.
If a RAW, FORMAT, FETCHSIZE, or LOCK setting is not specified, then a generic default value is assumed as follows:
RAW=F/1/POS/100
FORMAT=F/1/POS/50
FETCHSIZE=999999
LOCK=PROTECTED