IBM Support

JR36628: REPLICATION ENGINE FIXES FOR DB2 LUW V95 FP7

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Engine Fixes for V95FP7
    

Local fix

  • bug in the code.
    

Problem summary

  • ----------------------------------------------------------
    The following defects have been fixed in
    DB2 LUW V9.5 FP7:
    .
    ----------------------------------------------------------
    .
    Defect 773135: MININFLIGHT_SEQ is not updated when
     SQLCAPTURE is run with AUTOSTOP=Y even though there is
     work captured.
    .
    User Affected: SQLCAPTURE
    .
    Problem Description: The restart point is not moved
     forward when the SQLCAPTURE program run with AUTOSTOP=Y.
     This happens if SQLCAPTURE reaches end of log before the
     commit interval (default 30 seconds) has been triggered.
     We had the customer try 1 second and due to the sparse
     workload, SQLCAPTURE reached end of log much before
     1 second.
    .
     There is low risk no data loss. The consequence is that
     on restart, SQLCAPTURE will start farther behind in the
     log than necessary and will reread some log records.  The
     MAXCOMMIT_SEQ is properly maintained, thus, there is no
     risk of capturing a transaction twice.  The only risk is
     the reading of additional log records that will be
     ignored by SQLCAPTURE.
    .
    ----------------------------------------------------------
    .
    Defect 783022: Restart in partitioned environments could
     result in loss of partial transaction
    .
    User Affected: LUW QCAPTURE and SQLCAPTURE in DB2 DPF
     environments
    .
    Problem Description: Part of a global transaction could be
     skipped (not published) during the restart or reinit of a
     QCAPTURE or SQLCAPTURE program.
    .
    Problem Summary: A timing condition exists which could
     result in part of a global transaction being skipped
     after evaluating a global prepare log record timestamp.
    .
    Problem Conclusion: The problem has been fixed.
    .
    ----------------------------------------------------------
    .
    Defect 776032: Status show details command causes a shared
     memory leak.
    .
    User Affected: QCAPTURE and QAPPLY
    .
    Problem Description: Status show details command causes a
     shared memory leak.  QCAPTURE and QAPPLY do not detach
     from the command program shared memory after issuing
     STATUS SHOW DETAILS response messages.  If status show
     details command is repeatedly executed from a script it
     causes DB2 to display 'SQL1221N  The Application Support
     Layer heap cannot be allocated' messages.
    .
    ----------------------------------------------------------
    .
    Defect 684805: ASNTDIFF gets SQL0104N if the decimal point
     is set to comma
    .
    User Affected: ASNTDIFF
    .
    Problem Description: When the DEFAULT DECIMAL POINT is set
     to comma, ASNTDIFF will encounter SQL0104N.  This is
     because the generated ORDER BY clause contains some comma
     without any space followed by them.
    .
    Problem Conclusion: The problem has been fixed.
    .
    ----------------------------------------------------------
    

Problem conclusion

  • See above
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR36628

  • Reported component name

    REPLICATION SER

  • Reported component ID

    5724N9800

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-18

  • Closed date

    2011-01-13

  • Last modified date

    2011-01-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC70106 IC70122 IC70130 IC70131 IC70135 IC70140 IC70141 IC70143
    IC70144 IC70145 IC71314 IC71316

Fix information

  • Fixed component name

    REPLICATION SER

  • Fixed component ID

    5724N9800

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 January 2011