APAR status
Closed as program error.
Error description
In IBM Sterling B2B Integrator SQL query related to setting ARCHIVE_DATE ON ARCHIVE_INFO has slow performance and need to be optimized for MS SQL Server. The query can be found in jdbc.properties: query.updateArchiveDateAISql.mssql
Local fix
STRRTC - 580597 DW / DW Circumvention: None
Problem summary
Problem Description: SQL Queries of business processsStatus and state are taking excessive time to complete for very large WORKFLOW_CONTEXT tables. Users Affected: IBM Sterling B2B Integrator users with MSSQL DB 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
IT28474
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