APAR status
Closed as program error.
Error description
In IBM Sterling B2B Integrator SQL query related to WORKFLOW_LINKAGE has slow performance and needs to be optimized for MS SQL Server. The query can be found in jdbc.properties: query.selectWorkflowLinkageCanidates.mssql
Local fix
STRRTC - 580701 DW / DW Circumvention: None
Problem summary
Users Affected: B2BI users with MSSQL DB Problem Description: SQL Queries of business process status and state were taking excessive time to complete for very large WORKFLOW_CONTEXT tables. Platforms Affected: All
Problem conclusion
Resolution Summary: A code fix is provided. The SQL queries for BP Status and State were optimized to provide improved query speeds. Delivered in: 6000202 6010000
Temporary fix
Comments
APAR Information
APAR number
IT28507
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
526
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-03-22
Closed date
2020-03-06
Last modified date
2020-09-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
STR B2B INTEGRA
Fixed component ID
5725D0600
Applicable component levels
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6"}]
Document Information
Modified date:
21 September 2020