Question

Is there a way to extract all the records in the database (250,000+) in one extract process instead of running multiple sequential extract processes?

Answer

Yes.

Selective Extracts using BIB range, specify an optional parameter at the command line to break the extract into multiple threads (-T).
The BIB range will be divided into that number of threads, with each thread extracting its assigned subset of the range.
Each thread should extract no more than 250,000 records.

Note that if the .ini file allows extracting by any method other than BIB range, the extract will not use multiple threads.

Additional Information

Example: Database has 500,000 records; highest bib_id is 526778

/m1/voyager/xxxdb/sbin/Pprimoexp.sel -f ../ini/PrimoExp-Selective.ini -B1 -E526778 -T5

5 threads, extracting ~100,000 records each would run in this process.

• Article last edited: 07-Jan-2019