A fix is available
APAR status
Closed as program error.
Error description
SQL INSERT to SQL Server hangs if statement contains tabs
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of WebSphere Message Broker who * * interact with SQL Server databases using * * the V5.3 DataDirect Drivers. * **************************************************************** * PROBLEM DESCRIPTION: Message flows which interact with an * * SQL Server database can hang when the * * SQL statement is executed. No further * * input messages are processed by the * * message flow and the execution group * * becomes unresponsive to reconfiguration * * requests like mqsireload and has to be * * killed manually. * **************************************************************** * RECOMMENDATION: * **************************************************************** Message flows that execute SQL statements against a SQL Server database can hang. A defect in the DataDirect SQL Server ODBC driver causes the driver to hang when executing an SQL statement that includes multiple tabs.
Problem conclusion
WebSphere Message Broker has been modified to include a new DataDirect SQL Server driver where the hang no longer occurs.
Temporary fix
Comments
APAR Information
APAR number
IZ54475
Reported component name
MSSG BROKER AIX
Reported component ID
5724J0501
Reported release
100
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-07-01
Closed date
2009-07-24
Last modified date
2009-08-05
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
MSSG BROKER AIX
Fixed component ID
5724J0501
Applicable component levels
R100 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSKM8N","label":"WebSphere Message Broker"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]
Document Information
Modified date:
05 August 2009