JR45665: DDL_AWARENESS SYSTEM PARAMETER NOT WORKING PROPERLY WITH DDL STATEMENT "ALTER TABLE ... TRUNCATE PARTITION..."

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Customer set the ddl_awareness system parameter off to turn off
    the ddl awareness for static mapping, this works for most of the
    ddl, but for "ALTER TABLE ... TRUNCATE PARTITION..." it didn't
    work
    

Local fix

Problem summary

  • CDC for Oracle Redo stops when encountering the following
    DDL "ALTER TABLE... TRUNCATE PARTITION" even if the DDL
    awareness system parameter is turned OFF.
    

Problem conclusion

Temporary fix

  • CDC 6.5.2 Interim Fix 7 for Oracle redo has added a new
    parameter called
    for_all_table_mappings_history_is_managed_independently_on_targe
    t.
    This parameter can be used when table partitions are utilized to
    manage historical information in the source table and you want
    to manage the historical information independently on the target
    table. When a partition is dropped or truncated on the source
    side to remove some history that action will not be replicated
    to the target table. The target table will retain that
    historical information until it is removed by your own
    independent cleanup procedures.
    

Comments

APAR Information

  • APAR number

    JR45665

  • Reported component name

    IS CDC ORACLE

  • Reported component ID

    5724U7008

  • Reported release

    650

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-06

  • Closed date

    2013-02-08

  • Last modified date

    2013-02-08

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

    JR45098

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

Fix information

Applicable component levels

  • R651 PSN

       UP

  • R652 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Change Data Capture

Software version:

6.5

Reference #:

JR45665

Modified date:

2013-02-08

Translate my page

Machine Translation

Content navigation