Script for Parallel Batch Loads

Because FDM supports parallel processing of batch files, (up to 50 files) can run simultaneously. FDM groups files into processes. The files within each process run sequentially (requiring that one file completes its run before the next file starts its run), and the processes run simultaneously.

Example: For example, if parallel processing is enabled for a batch that contains 20 files and the number of processes is set to five, five processes (each including 4 files that run sequentially) run simultaneously.

Note:

When processing batch files in parallel, FDM groups files that are loading to one FDM location into one process, ensuring that multiple processes do not attempt to load data simultaneously to avoid inaccurate results.

Sub ParallelBatch()
‘------------------------------------------------------------------
‘ FDM Custom Script: 
‘
‘Created By:    	Admin
‘Date Created:  	3/23/2006 13:50
‘
‘Purpose:       	Execute a FDM Batch Loader with parallel processing
‘------------------------------------------------------------------
‘Declare Local Variables
Dim lngProcessLevel
Dim strDelimiter
Dim blnAutoMapCorrect
Dim lngParallelProcessCount
Dim strLoadBalanceServerName

‘Initialize Variables
lngProcessLevel = 12   ‘Up-To-Check
strDelimiter = “_”
blnAutoMapCorrect = 0
lngParallelProcessCount = 5
strLoadBalanceServerName = “LocalHost”

‘Create the file collection
Set BATCHENG.PcolFiles = BATCHENG.fFileCollectionCreate(CStr(strDelimiter))

‘Execute a Standard Parallel batch
BATCHENG.mFileCollectionProcessParallel BATCHENG.PcolFiles, CLng(lngProcessLevel), CLng(lngParallelProcessCount), CStr(strLoadBalanceServerName), , CBool(blnAutoMapCorrect)

End Sub