APAR status
Closed as program error.
Error description
There are 35 external database pools (MySQL, Oracle, SQL Server, DB2 and Informix) defined in the customer_overrides.properties file. Databases that the customer connects to are offline when IBM Sterling B2B Integrator is up from a reboot. When this occurs and you attempt to perform an operation against that database, the system displays "Cannot create a connection with an invalid pool" error. Another restart of the IBM Sterling B2B Integrator application while the database is online resolves the issue. This seems to happen for all DBMS. You must set the databasePool.transaction parameter to true and will resolve the issue and allow the LWJDBC adapter to successfully connect to the external database. The customer external database pools were either defined with transaction set to false or without the transaction parameter (defaults to false). Support has found that setting transaction to true as well as type to remote causes database corruption problems during map translation if the transaction needs to rollback. Customer uses the most external database pools for both LWJDBC connections and map translation. From the documentation, the transaction parameter determines whether the database pool can participate in distributed transactions. Assume this together with type = remote is required for the database two-phase commit.
Local fix
STRRTC - 511071 PC / PC Circumvention: None
Problem summary
Users Affected: All PROBLEM DESCRIPTION: databasePool.transaction parameter affects the connectivity when external database is started after IBM Sterling B2B Integrator. Platforms Affected: All
Problem conclusion
Resolution Summary: A code fix is provided. Delievred In: 5020500_16 5020601_8 5020603_3
Temporary fix
Comments
APAR Information
APAR number
IT19913
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
525
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-28
Closed date
2017-07-12
Last modified date
2017-11-15
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
R525 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]
Document Information
Modified date:
15 November 2017