B
Bryan Petersen
Guest
Valeriy, Normally split threads are for regular replication, I don't know of anything written specifically to split bulk loads. Patty mentioned that she modified the generated bulk code for a customer so one bulk load starts with the first record and moves forward and another bulk load procedure starts with the last record and moves backwards, thus in effect creating 2 threads on 1 table. Theoretically, you could edit copies of the bulk copy code and use different date ranges if you have one on an index or use other options with other data. We have not included the split thread code in replproc but have done it for customers as a custom fix. If you want to use split threading for normal replication and need to start multiple replbatch processes, you need to add more replcontrol records, one for each split e.g. 1-2, 1-3. Basically, we add an input from the batch file with the split number to match the new replcontrol record and a mod number. We then add code to replproc to check the sequence number against the mod to see which records to process. Thanks, Bryan
Continue reading...
Continue reading...