IBM Support

PH07326: Q CAPTURE DOES NOT RECOGNIZE COLUMNS THAT HAVE FIELD PROCEDURES AFTER IT PROCESSES A CAPSTART SIGNAL.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • Q Capture should check if the any source table columns have
    field procedures when it processes a CAPSTART signal. Q Capture
    checks if the source tables have any field procedures at start
    or reinit time and keeps this information in memory. If a
    subscription for a source table with a field procedure is
    activated, it is handled as a table without field procedures
    until Q Capture is recycled or a REINIT is issued. This causes
    incorrect data to be replicated or published.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- Q Apply                                   *
    *                 2- All Q Capture customers                   *
    *                 3- All Q Capture customers                   *
    *                 4- All Q Capture customers                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- In multi-uni configuration,          *
    *                      dropping multiple columns followed by   *
    *                      reorg of table may cause ASN7512E       *
    *                      error in apply at same node when the    *
    *                      drop column gets replicated round trip  *
    *                      back from other node.                   *
    *                      2- Q Capture REINIT of an active        *
    *                      subscription issues ASN7341W and does   *
    *                      not send a schema message to Q Apply.   *
    *                      3- Q Capture should check if the any    *
    *                      source table columns have field         *
    *                      procedures when it processes a          *
    *                      CAPSTART signal. Q Capture checks if    *
    *                      the source tables have any field        *
    *                      procedures at start or reinit time and  *
    *                      keeps this information in memory. If a  *
    *                      subscription for a source table with a  *
    *                      field procedure is activated, it is     *
    *                      handled as a table without field        *
    *                      procedures until Q Capture is recycled  *
    *                      or a REINIT is issued. This causes      *
    *                      incorrect data to be replicated or      *
    *                      published.                              *
    *                      4- Q Capture issues ASN7138W each time  *
    *                      it initializes a delimited              *
    *                      subscription that has a                 *
    *                      IBMQREP_SENDQUEUES message_codepage     *
    *                      that is not 1208.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- Q Apply in a multi-uni configuration may not handle round
    trip replication of multiple ALTER TABLE DROP COLUMN ddls
    resulting in ASN7512E error reported with Reason Code 4 or 6.
    2- Q Capture REINIT should issue ASN7341W if the subscription
    STATE is 'L' and the subscription HAS_LOADPHASE is 'E'.
    3- Q Capture should check if the any source table columns have
    field procedures when it processes a CAPSTART signal.
    4- Q Capture should not issue ASN7138W.
    

Problem conclusion

Temporary fix

Comments

  • 1- Q Apply will tolerate missing target columns while
    processing SCHEMA messages sent during replication of multiple
    ALTER TABLE DROP COLUMN ddl operation and avoid failing the
    subscription with ASN7512E.
    2- Q Capture REINIT will issue ASN7341W only if the
    subscription STATE is 'L' and the subscription HAS_LOADPHASE is
    'E'.
    3- Q Capture will check if the any source table columns have
    field procedures when it processes a CAPSTART signal.
    4- Q Capture REINIT will not issue ASN7138W.
    ASNCLP was not updated.
    

APAR Information

  • APAR number

    PH07326

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    A21

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-15

  • Closed date

    2019-02-14

  • Last modified date

    2019-03-01

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

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

    UI61303 UI61304 UI61305 UI61306

Modules/Macros

  •    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
    ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQASUB ASNQCAP  ASNQCCMD
    ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF
    ASNTDSP  ASNTRC   ASN2BASE ASN2SQLZ
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RA21 PSY UI61303

       UP19/02/26 P F902

  • RA24 PSY UI61304

       UP19/02/26 P F902

  • RA25 PSY UI61305

       UP19/02/26 P F902

  • RA26 PSY UI61306

       UP19/02/26 P F902

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:
01 March 2019