PM76957: SQL CAPTURE ABEND0C4 AFTER PERMANENT COMPRESSION DICTIONARY ERROR.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If SQL capture detects a permanent compression dictionary error,
    ASN0011E with RC 00C90064 and option stopOnError=N capture
    deletes the table registration from memory without unlinking
    the table registration.  Capture will then issue abend0c4 when
    it attempts to locate another table in memory.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- Capture                                   *
    *                 2- Q Capture                                 *
    *                 3- A Apply                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- ASN0633W message is continually      *
    *                      issued until the capture program is     *
    *                      restarted.                              *
    *                      2- If the heartbeat_interval is less    *
    *                      than zero, it sends heartbeats every    *
    *                      500ms.                                  *
    *                      3- Q Apply failed to load from a        *
    *                      source table with 2.5 billion rows due  *
    *                      to sqlcode -802                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Capture is not detecting the commit for a transaction in the
    log
    2- Q Capture does not validate heartbeat_interval.
    3- Q Apply failed with sqlcode -802 because the internal host
    variable is not big enough to hold more than 2.1 billion rows
    

Problem conclusion

  • 1- Capture is changed to also detect the BEGIN COMMIT2 log
    record to prevent missing transaction commits
    2- Q Capture will issue ASN7262W and disable heartbeats if the
    heartbeat_interval is less than zero
    3- Change the Q Apply host variable from a 4-byte int to a
    8-byte bigint to hold the number of rows
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM76957

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-12

  • Closed date

    2013-01-30

  • Last modified date

    2013-03-04

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

    PM76956

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

    UK91278 UK91279 UK91281 UK91282

Modules/Macros

  • ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
    ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD ASNQAPP  ASNQASUB
    ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT ASNQXFMT
    ASNQ1001 ASNRBASE ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RA10 PSY UK91278

       UP13/02/07 P F302

  • RA11 PSY UK91279

       UP13/02/08 P F302

  • RA12 PSY UK91281

       UP13/02/07 P F302

  • RA13 PSY UK91282

       UP13/02/07 P F302

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Replication Server

Software version:

A10

Reference #:

PM76957

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation