Previous Topic: How to UseNext Topic: FIRSTKEY= and LASTKEY= Keywords in Parallel Extract


Parallel Extract

Use parallel extract by specifying starting and/or ending key value ranges to be processed. Using parallel extract you could, for example, extract the first half of the data in one job and the remaining half in a concurrently executing second job. CA Datacom/DB places no restrictions on the number of extracts running in parallel. We recommend a starting point of four so that each processes approximately one fourth of the data. It is up to you to determine the appropriate key value ranges.

The parallel extract output file can be used as input to a regular LOAD DBUTLTY function either as all parallel parts concatenated together in key value order (for a full load) or less than all of the parallel parts to allow for deleting a range of rows.