IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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