SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Reorganizing SQL/MX Tables and Maintaining Data
HP NonStop SQL/MX Installation and Management Guide—544536-007
10-32
Support for restarting import
You might specify the three import commands as follows:
/usr/bin:import corpcat.persnl.employee -I empfile -C 3000 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile -C 2000 -F 3000 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile -C 2000 -F 5000 -T 500
The count of the number of records for each partition must be less than or equal to
the space available in each partition, and the rows to be imported into each
partition must have an appropriate clustering key. In the preceding example, the
first partition permits employee numbers ranging from 0 to 2999.
•
Run multiple instances of the import command—one for each partition in the
destination table—to load data into a partitioned table by using a separate input file
for each partition. Each of the input files contains the data for each partition.
For example, you might specify the three import commands for the partitioned
EMPLOYEE table as:
/usr/bin:import corpcat.persnl.employee -I empfile1 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile2 -T 500
/usr/bin:import corpcat.persnl.employee -I empfile3 -T 500
Support for restarting import
For more information on this topic, see HP NonStop SQL/MX Reference Manual.
Note. Check that the ranges specified are exact. For example, check that there are no
gaps or omissions and no overlap of rows.