I am using DB2 10.1 (AESE) partitioned, and I am trying to bulk load data as fast as I can into an empty table (along with the secondary indices created on it). Based on what I read, I am using load statement in the following way:
load from /mnt/data/sdb/d1.csv,/mnt/data/sdc/d2.csv of del insert into myTable;
My raw data consists of several chunks, in CSV format, and the files reside on the same machines as DB2 is running. I know (for sure) that there is no duplicate/erroneous record there (The data is generated by a generator and is safe), and I am wondering if there is any way that I force DB2 to just load it (wout any specific check, if any, it is making) - in the fastest way it can.
I am using hash partitioning (in case it makes a difference in your suggestion).