Load Partitions in parallel
Posted: Tue Feb 01, 2011 2:48 pmThis question
Load to partiontioned tablespace.
From: jaggz
Everything I answer next can be found in the manual : http://publib.boulder.ibm.com/infocente ... l_load.htm
Afaik there is no keyword parallel.
you can load different dataset into different partitions with one load statement
parallel index building can be achieved with SORTKEYS
I'm not sure how to combine both, experiment a little.
Load to partiontioned tablespace.
From: jaggz
Hi,
We have 10 partitioned tablespace. We want to load each partition simultaneously for Performance measuring. Do you have any idea to achieve this with one JCL using Parallel keyword
Everything I answer next can be found in the manual : http://publib.boulder.ibm.com/infocente ... l_load.htm
Afaik there is no keyword parallel.
you can load different dataset into different partitions with one load statement
LOAD DATA replace
into table tableA part 1 inddn file1
into table tableA part 2 inddn file2
into table tableA part 1 inddn file1
into table tableA part 2 inddn file2
parallel index building can be achieved with SORTKEYS
LOAD DATA replace
into table tableA inddn file
SORTKEYS 66000 SORTDEVT SYSDA SORTNUM 3
into table tableA inddn file
SORTKEYS 66000 SORTDEVT SYSDA SORTNUM 3
I'm not sure how to combine both, experiment a little.