I'm trying to load and unload about 1 million records into a table and it takes about 45 minutes each action (load/unload).
Could anyone help me giving some tips about how to improve the performance? Is there any DB2 parameter that helps this?
To Optimize the time taken for Execution of Platinum Load Jobs for partitioned table Spaces. Use the below parameter :==>
LOCKPART Indicator specifying whether selective partition locking is used.
Valid values are as follows:
Y - LOCKPART YES - lock only the Loaded partition
blank - LOCKPART NO (or not partitioned) - lock the Entire Table
i.e., It will not lock the Entire Table while loading(only the Loaded partition is locked) and Parallel Loading of all the partitions simultaneusly can be done.