IBM Support

PM76956: 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- non-parallel ASNTDIFF                     *
    *                 2- SQL capture                               *
    *                 3- SQL Capture customers.                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1-  When the spill file (2GB at most)   *
    *                      is not large enough, the customer will  *
    *                      get the following message: "asntdiff    *
    *                      fseek errno: : EDC5027I The position    *
    *                      specified to fseek() was invalid.       *
    *                      (errno2=0xC03D0020)".                   *
    *                      2- ASN0070 when trying to register a    *
    *                      table with 2 columns that have very     *
    *                      similar names. The first column is 17   *
    *                      characters and the second column is     *
    *                      the exact same name concatenated with   *
    *                      an 18th character. This only occurs     *
    *                      when there is a before image prefix     *
    *                      specified.                              *
    *                      3-  SQL Capture started specifying      *
    *                      STOP_ON_ERROR = 'N' terminates with     *
    *                      ABENDS0C4 after displaying ASN0011E.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Non-parallel ASNTDIFF requires a spill file for storing key
    values, but the spill file (2GB at most) might be not large
    enough to hold all the key values.
    2- Capture was incorrectly checking for 18 character column
    names and treating them as if 18 were the maximum column name
    length. DB2 V7 had maximum column name lengths of 18.
    3-  SQL Capture stops a source table registration and removes
    the registration information from its memory if it was started
    specifying STOP_ON_ERROR = 'N' and the DB2 compression
    dictionary for the source table no longer exists.  SQL Capture
    terminates with ABENDS0C4 when it references the source table
    registration information it has removed.
    

Problem conclusion

  • 1- An ASN message ASN4076E is issued to indicate that the users
    should split and compare the source and target tables.
    2- Capture will correctly load and activate this registration.
    3-  Modify SQL Capture to fix this problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM76956

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-12

  • Closed date

    2012-12-04

  • Last modified date

    2013-01-02

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

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

    PM76957 UK83989 UK83990 UK83991 UK83992

Modules/Macros

  •    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
    ASNCCPWK ASNCDINS ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD
    ASNQAHKT ASNQAPAG ASNQAPP  ASNQCAP  ASNQCCMD ASNQDEP  ASNQMFMT
    ASNQXFMT ASNRBASE ASNTDIFF ASNTRC   ASN2BASE
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • R910 PSY UK83989

       UP12/12/13 P F212

  • R911 PSY UK83990

       UP12/12/14 P F212

  • R912 PSY UK83991

       UP12/12/13 P F212

  • R913 PSY UK83992

       UP12/12/13 P F212

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.

[{"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":"910","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 January 2013