IBM Support

PI59985: DB2 ABENDS CAPTURE WITH CODE: 004E REASON CODE: 00E7000C AFTER CAPTURE ATTEMPTS TO EXECUTE SQL STATEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL and Q capture can fail to start and issues error
    ASN0661E if this query returns rows:
    SELECT DISTINCT TBNAME FROM SYSIBM.SYSFIELDS FOR FETCH ONLY
    --
    The Select checks for the presence of field procs.
    If any field procs are found, even if the tables are not
    being replicated, Capture will fail with ASN0661E.
    --
    
    Capture data may be lost if it is unable to allocate
    memory for a row.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- Q Apply                                   *
    *                 2- All Capture customers that have one or    *
    *                 more field procs defined on tables in the    *
    *                 DB2 system catalog.                          *
    *                 3- Capture may experience data loss if it    *
    *                    cannot allocate memory for a row          *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Q Apply does not ensure that         *
    *                      graphic column data in                  *
    *                      IBMQREP_EXCEPTIONS TEXT includes        *
    *                      shift-in / shift-out bytes as needed    *
    *                      for certain CCSIDs.                     *
    *                      2- DB2 abends Capture with CODE: 004E   *
    *                      REASON CODE: 00E7000C after Capture     *
    *                      attempts to query SYSIBM.SYSFIELDS      *
    *                      using an invalid SQLDA.                 *
    *                      3- Capture may have data loss if it is  *
    *                      unable to allocate memory for a row     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Q Apply is not ensuring Shift-in/Shift-out bytes do get
    added for graphic data in IBMQREP_EXCEPTIONS text for certain
    CCSIDs that need them. IBMQREP_EXCEPTIONS Text is not pure DBCS
    so needs SI/SO bytes for embedded graphic data for certain
    CCSIDs like 1390.
    2- DB2 abends Capture with CODE: 004E REASON CODE: 00E7000C
    after Capture attempts to query SISIBM.SYSFIELDS using an
    invalid SQLDA.
    3- Capture may experience data loss if it is unable to allocate
       memory for a row
    

Problem conclusion

  • 1- The problem is fixed.
    2- Capture has been modified to query SYSIBM.SYSFIELDS using an
    invalid SQLDA.
    3- The problem is fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI59985

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-30

  • Closed date

    2016-04-25

  • Last modified date

    2016-06-02

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

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

    UI37304 UI37305 UI37306 UI37307

Modules/Macros

  •    ASNAAPP  ASNACMD  ASNACMP  ASNADMSP ASNAFET
    ASNAISO  ASNAPPLY ASNAWPN  ASNCAP   ASNCCMD  ASNMCMD  ASNMON
    ASNQACMD ASNQAPAG ASNQAPP  ASNQAROW ASNQBRWZ ASNQCAP  ASNQCCMD
    ASNQDEP  ASNQEXRP ASNQMFMT ASNQSPIL ASNQXFMT ASNRBASE ASNSQLCZ
    ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE ASN2SQLZ
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RA21 PSY UI37304

       UP16/05/05 P F605 «

  • RA24 PSY UI37305

       UP16/05/05 P F605 «

  • RA25 PSY UI37306

       UP16/05/05 P F605 «

  • RA26 PSY UI37307

       UP16/05/05 P F605 «

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

Document Information

Modified date:
02 June 2016