Integration Workflow Processing and Performance

This page has not been liked. Updated 4/12/13, 3:53 AM by EdSilkyTags: None

When doing integration operations like importing large numbers of floor and space records using Data Connect (DC) you can increase the throughput by understanding what workflows are being executed as part of the process and disabling those that are not needed given the nature of the operation (creating many records with known good data).



One way to find out what workflows are being executed is to enable all workflow instances to be recorded and then inspect them after going through the process once. However, that can be very tedious and it's easy to miss many workflows that are executed as side effects of creating and associating records. In addition, enabling workflow instance recording can cause significant overhead to the process and the entire system so try to avoid it except when debugging some part of the processing. In general you want all instance recording disabled (you can set that option in TRIRIGAWEB.properties and temporarily override it if needed using the Administration Console - Workflow Agent page).

Instead of instance recording, if you want to know what workflows are executing and why, enable the workflow performance logging (both SYNC and ASYNC) and collect the performance.log file from the server (the process server running the workflow agent). You can process the performance.log using the Workflow Performance Analysis Tool to get an interactive view into everything that's running, why it's running, and how long it is taking.

You can get the tool from the IBM ISM site: http://www-304.ibm.com/software/brandcatalog/ismlibrary/details?catalog.label=1TW10TR01#tab-overview



Also, if you do the integration processing on a regular basis, look at using the 'Integration' flag in workflow start conditions to cause workflows to be skipped rather than temporarily retiring them.