Load Partitions in parallel



IBM's flagship relational database management system

Load Partitions in parallel

Postby GuyC » Tue Feb 01, 2011 2:48 pm

This question
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


parallel index building can be achieved with SORTKEYS
LOAD DATA replace
into table tableA inddn file
SORTKEYS 66000 SORTDEVT SYSDA SORTNUM 3

I'm not sure how to combine both, experiment a little.
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post