IBM Support

Importance of WORKFLOW_LINKAGE table in IBM Sterling B2B Integrator(SBI).

Technical Blog Post


Abstract

Importance of WORKFLOW_LINKAGE table in IBM Sterling B2B Integrator(SBI).

Body

In SBI, the WORKFLOW_LINKAGE table stores information about the Parent and the Child Business Process(BP). Let us consider the BPs Parent_BP and Child_BP
<process name="Parent_BP">
<sequence name="Loop">
<operation name="Invoke Business Process Service">
<participant name="InvokeBusinessProcessService"/>
<output message="InvokeBusinessProcessServiceTypeInputMessage">
<assign to="." from="*"></assign>
<assign to="INVOKE_MODE">ASYNC</assign>
<assign to="WFD_NAME">Child_BP</assign>
<assign to="message_to_child" from="string(&apos;&apos;)"></assign>
</output>
<input message="inmsg">
<assign to="." from="*"></assign>
</input>
</operation>
</sequence>
</process>
---------------------------------------
<process name="Child_BP">
<sequence name="Main">
<operation name="Assign">
<participant name="AssignService"/>
<output message="AssignServiceTypeInputMessage">
<assign to="." from="*"></assign>
<assign to="invokeCount">0</assign>
<assign to="invokeMax">1000</assign>
</output>
<input message="inmsg">
<assign to="." from="*"></assign>
</input>
</operation>
</sequence>
</process>
Parent_BP invokes the Child_BP as shown below
image

In the background, this execution not only creates an entry for itself in the WORKFLOW_CONTEXT table, but also creates the information about the parent and the child BP link in the WORKFLOW_LINKAGE table.
SELECT *FROM WORKFLOW_CONTEXT WHERE WORKFLOW_ID='139248'
image

SELECT *FROM WORKFLOW_CONTEXT WHERE WORKFLOW_ID='139249'

image

SELECT *FROM WORKFLOW_LINKAGE WHERE P_WF_ID='139248'

image

After the Schedule_Purge service purges this parent and child BPs from the system, the information available in the WORKFLOW_LINKAGE table for this parent and child BP also has to be removed. This is taken care of the system schedule - BPLinkagePurgeService.This schedule kicks off Schedule_BPLinkagePurgeService BP by default every day at 2:30 AM.

The status report at the Business Process Linkage Data Purge service is as shown below, as per this screen shot the Schedule_BPLinkagePurgeService has purged 94 records from the WORKFLOW_LINKAGE table.

image

If the WORKFLOW_LINKAGE table is huge, this schedule can be run at frequent intervals and also there are parameters available in the BPLinkagePurge Service which can be tuned to purge more records from the WORKFLOW_LINKAGE table.The below tech note provides more information about the same.

http://www-01.ibm.com/support/docview.wss?uid=swg21673664

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11121913

Page Feedback