IBM Support

JR54912: Oracle Connector does not always report the actual number of deleted rows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the number of deleted keys is less than the actual number
    of the deleted rows, Oracle Connector does not correctly log the
    actual number of the deleted rows. This message may confuse the
    users.
    

Local fix

Problem summary

  • Prior to this fix, the Oracle Connector was keeping track of the
    number of successful executions of the DELETE statement.
    Sometimes a DELETE statement deletes more than one record. This
    happens when multiple records have the same key. Up until this
    fix, Oracle Connector assumed that the DELETE keys were unique.
    

Problem conclusion

  • Oracle Connector no longer uses the number of successful DELETE
    statements executed to report the count of deleted records.
    Instead, now the Oracle Connector uses the number of
    records deleted as reported by Oracle to log the statistics.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR54912

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    912

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-12-06

  • Closed date

    2016-02-03

  • Last modified date

    2016-04-25

  • 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

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R910 PSY

       UP

  • R912 PSY

       UP

  • RB30 PSY

       UP

  • RB31 PSY

       UP

  • RB50 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"912","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 October 2021