IBM Support

JR45635: ORACLE QCAPTURE: SIGNAL TABLE ROWS ARE GROWING AND NEVER PRUNED WHEN ORACLE IS 11G AND HIGHER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Rows in the IBMQREP_SIGNAL table are not pruned when Q Capture
    for Oracle is running against Oracle 11g and higher.
    

Local fix

Problem summary

  • The rows in the IBMQREP_SIGNAL are not pruned because the
    state is never updated to indicate a completion of the
    signal processing. The update fails because the
    SIGNAL_TIME is collected from the log record and Oracle
    had a bug in LogMiner that omitted the sub-second
    precision in Oracle 10g (all versions). The employed
    workaround in Q Capture retrieved the sub-second
    precision from the SIGNAL_TIME contents in the
    IBMQREP_SIGNAL as 0 to allow for matching to a timestamp
    value from the log record. Because the value returned in
    the log record with Oracle 11g contains the sub-second
    precision correctly the SIGNAL_TIME value does not match
    anymore and hence the state update does not occur.
    

Problem conclusion

  •  Q Capture for Oracle query to update the
    signal state has been fixed.  It works now for Oracle versions
    10 and above.
    The fix will be available in DB2 LUW V9.7 FP8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45635

  • Reported component name

    WS Q-REPLIC LUW

  • Reported component ID

    5724N9801

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-04

  • Closed date

    2013-02-04

  • Last modified date

    2013-02-04

  • 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

    WS Q-REPLIC LUW

  • Fixed component ID

    5724N9801

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2013