Bookshelf v7.8: Distribute Data Method

The Distribute Data business service method is part of the Load Splitter Service business service that allows you to configure Assignment Manger to run multiple application servers concurrently within the Siebel Enterprise. This method consists of a complex hierarchical input property set.

Arguments


Argument	Description
Configuration Id	The load splitter uses the configuration ID to get the configuration for the servers, threshold, minimum batch size, list of servers to run on, and so on.
Mode	Determines whether Load Balancer runs in Write or Read mode. Read mode is the default.
Object Types	A property set that identifies the types of objects in a run and a child property set which contains a WHERE clause and the table name of each object type. For example: Object Type = Contact WHERE Clause = `Specialty LIKE Cardiology` TableName = S_PARTY
Request Id	Identifies the rows in the S_ASGN_LB_DATA table for a specific assignment request.
Server Component	Identifies the server component—AsgnSrvr or AsgnBatch—that the load splitter uses to pass the object rows for subsequent processing. This parameter also contains a child property set that has the input arguments used by a particular server component. For example: AsgnSrvr can take in the following input arguments: AsgnKey, Copy-postn-specific data, and so on.
Server Component Parameters	The property set that contains all the parameters for the specified server component.
Set Server Component Object Type Parameter	Indicates which server component parameter to populate with the object type.
Set Server Component SQL Parameter	Indicates which server component parameter to populate with the load balanced SQL statement.

Usage

The input for load splitter configuration comes from any service that intends to use it, such as Target Object Selector (TOS), a business service, and so on. Load splitter configuration splits the objects that need processing into separate batches and submits those batches to a target process, such as Assignment Manager.

Invoked From

You can invoke Load Splitter using a workflow process, business service, scripting, and so on.

Example

The following is sample code for invoking load splitter configuration using a business service and AsgnSrvr.

var psInputArgs;
var psOutputArgs;
var psObjTypes;
var psSrvrCompParams;
var pService;

psInputArgs = TheApplication().NewPropertySet();
psInputArgs.SetProperty ("Request Id", "LoadSplitterTest");
psInputArgs.SetProperty ("Configuration Id", "42-4VPGT");
psInputArgs.SetProperty ("Mode", "Write");
psInputArgs.SetProperty ("Server Component", "AsgnSrvr");
psInputArgs.SetProperty ("Set Server Component Object Type Parameter", "AsgnObjName");
psInputArgs.SetProperty ("Set Server Component SQL Parameter", "ObjRowSqlStmt");

psObjTypes = TheApplication().NewPropertySet();
psObjTypes.SetType ("Object Type");
psObjTypes.SetValue ("Account");
psObjTypes.SetProperty("SQL", "SELECT ROW_ID FROM SIEBEL.S_ORG_EXT WHERE NAME LIKE 'K%TEST%'");
psInputArgs.AddChild (psObjTypes);

psObjTypes = TheApplication().NewPropertySet();
psObjTypes.SetType ("Object Type");
psObjTypes.SetValue ("Opportunity");
psObjTypes.SetProperty ("SQL", "SELECT ROW_ID FROM SIEBEL.S_OPTY WHERE NAME LIKE 'K%TEST%'");
psInputArgs.AddChild (psObjTypes);

psSrvrCompParams = TheApplication().NewPropertySet();
psSrvrCompParams.SetType ("Server Component Parameters");

pService = TheApplication().GetService("Load Splitter Service");
pService.InvokeMethod ("DistributeData", psInputArgs, psOutputArgs);