Has anyone tried the option SPLITTED_LOAD for importing table data parallely?
This is the documentation which i can see in the SAP note.
Each R3load process creates a copy of the target
table during import and uses DB2 LOAD to load this copy. Before creating the
first index on the target table, all data is copied from the table copies to the
target table using DB2 LOAD FROM CURSOR. If you use the option SPLITTED_LOAD,
you can make time when using the duplicate loading process: LOAD FROM CURSOR is
significantly faster than LOAD via the CLI client, and the loading of table
copies can happen in parallel. You can use the environment variable
DB6LOAD_TEMP_TBSPACE to specify, in which table space the table copies are
A large LOAD FROM CURSOR ... SELECT statement is
used to copy the data from the table copies to the target table. The SELECT part
of this statement can be accelerated by activating SMP parallelism (SAP Note 2047006). To do so, it is
sufficient to set INTRA_PARALLEL=YES and MAX_QUERYDEGREE='ANY'. You can leave
the value for DFT_DEGREE as 1.