JR61815: ORACLE CONNECTOR SPARSE LOOKUP DISCONNECT/RECONNECT RESULTS IN SIGSEGV OR SIGTERM

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

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 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