IBM Support

JR61452: IIDR IS PROCESSING ORACLE REDO LOG FILE VERY SLOWLY WHEN IT IS READING REDO LOG FILE OF SIZE MORE THAN 4GB.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • IIDR is processing Oracle redo log file very slowly when it is
    reading redo log file of size more than 4gb.
    

Local fix

  • Decrease the size of redo log files to less then 4GB.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * This issue may affect you if you use CDC Oracle as a source  *
    * datastore, and the Oracle instance to which CDC connects has *
    * large redo logs.                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You may see increased latency or decreased throughput when   *
    * CDC Oracle processes large redo log files.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDR 11.4.0.2-5506 or newer for Oracle.            *
    ****************************************************************
    

Problem conclusion

  • Upgrading to IDR 11.4.0.2-5506 or newer for Oracle resolves the
    issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR61452

  • Reported component name

    IS CDC ORACLE

  • Reported component ID

    5725E30OR

  • Reported release

    B40

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-08-30

  • Closed date

    2020-04-15

  • Last modified date

    2020-04-15

  • 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

    IS CDC ORACLE

  • Fixed component ID

    5725E30OR

Applicable component levels

  • RB40 PSY

       UP

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

Document Information

Modified date:
25 August 2020