Fixes are available
APAR status
Closed as program error.
Error description
Customer is trying to leverage the disconnect/reconnect feature within a Sparse Lookup (Oracle CC). In a real-time or "always on" job, the job starts initially, processes data, disconnects, but then is never able to reconnect, and throws a SIGSEGV.
Local fix
N/A
Problem summary
Customer may wish to leverage the disconnect/reconnect feature within a Sparse Lookup using the Oracle Connector. In a real-time or "always on" job, the job starts initially, processes data, and then disconnects after a specified period of inactivity, but then is never able to reconnect, and throws a segmentation violation (SIGSEGV).
Problem conclusion
Multiple issues were resolved within the total solution. There are 2 patches required in implementation to allow the Oracle Connector in sparse lookup mode on PX canvas to disconnect and reconnect when the inactivity period is achieved. Prior to implementation of this feature, the Oracle Connector would throw a fatal SIGSEGV error. The Oracle Connector portion of the solution makes the following changes: - The dataset definition shared between the Oracle connector and the Connector Framework is not recreated after reconnecting. - The external dataset definition is not recreated after reconnecting. - The accessor index is not re-allocated when reconnecting. The Connector Framework (CCFW) portion of the solution makes the following changes: - A setter method was added for the pointer shared between the CCFW and the Oracle Connector. The pointer is owned by the CCFW, but the memory location it points to is owned by the Connector. - When the connection is re-established, the pointer must retain its original value. The setter mentioned above is called to maintain the correct value when the big buffer is registered for the 2nd or subsequent time.
Temporary fix
Comments
APAR Information
APAR number
JR61815
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-12-12
Closed date
2020-02-12
Last modified date
2020-02-12
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
INFO SRVR PLATF
Fixed component ID
5724Q3612
Applicable component levels
RB50 PSY
UP
RB70 PSY
UP
RB71 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021