IBM Support

PH02537: ADD QAPPLY DELETE_ARCHIVE PARAMETER FOR OVERRIDING THE DEFAULT FOR THE DB2 SYSIBMADM.MOVE_TO_ARCHIVE BUILT-IN GLOBAL VARIABLE.

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 Apply gets SQLCODE -803 when it replicates a DELETE operation
    from an archive-enabled table if it also replicates the
    associated archive table and the default for the Db2
    SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable is 'E' or
    'Y'.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1- All Q Capture customers who publish       *
    *                 messages encoded using MESSAGE_FORMAT 'E'.   *
    *                 2- All Q Capture customers who use the       *
    *                 Replication NMI Server.                      *
    *                 3- All Q Apply customers                     *
    *                 4- All Q Capture customers who publish XML   *
    *                 messages.                                    *
    *                 5- All Q Capture customers using             *
    *                 bidirectional subscriptions, Db2 data        *
    *                 sharing, and capture_load = R.               *
    *                 6- All Q Capture customers who publish XML   *
    *                 messages.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1- Q Capture hangs in GETMAIN after it  *
    *                      overlays the first byte of a heap free  *
    *                      element.                                *
    *                      2- The Q Capture NMI server sends       *
    *                      active workload metrics messages to     *
    *                      NMI clients.  The Q Capture NMI server  *
    *                      receives a SIGPIPE signal if it sends   *
    *                      a message to an NMI client after the    *
    *                      NMI client terminates.                  *
    *                      3- Q Apply gets SQLCODE -803 when it    *
    *                      replicates a DELETE operation from an   *
    *                      archive-enabled table if it also        *
    *                      replicates the associated archive       *
    *                      table and the default for the Db2       *
    *                      SYSIBMADM.MOVE_TO_ARCHIVE built-in      *
    *                      global variable is 'E' or 'Y'.          *
    *                      4- Q Capture XML format messages        *
    *                      display invalid FLOAT data type values  *
    *                      if the FLOAT data type value is zero.   *
    *                      5- Q Capture loops when it restarts a   *
    *                      bidirectional subscription after it     *
    *                      detects a Db2 LOAD operation for the    *
    *                      source table if it uses Db2 data        *
    *                      sharing.                                *
    *                      6- The Q Capture XML format message     *
    *                      cmitTime attribute value does not       *
    *                      display microseconds if the value for   *
    *                      microseconds is zero.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1- The Q Capture MESSAGE_FORMAT 'E' buffer overlays the next
    heap element if Q Capture writes an intent_seq column at the
    end of the buffer.
    2- The Q Capture NMI server should handle SIGPIPE signals.
    3- Q Apply should be able to set the Db2
    SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable to 'N'.
    4- The Q Capture XML format message should display zero for a
    FLOAT data type values if the FLOAT data type value is zero.
    5- Q Capture loops validating the bidirectional subscription.
    6- The Q Capture XML format message cmitTime attribute value
    should display microseconds if the value for microseconds is
    zero.
    

Problem conclusion

Temporary fix

Comments

  • 1- Q Capture has been changed to fix this problem.
    2- The Q Capture NMI server has been changed to handle SIGPIPE
    signals.
    3- Q Apply has been changed to accept the ARCHIVE_DELETE
    start-up parameter.  Q Apply will set the
    SYSIBMADM.MOVE_TO_ARCHIVE Db2 global variable to 'N' if the
    ARCHIVE_DELETE parameter is 'N'.
    4- Q Capture has been changed to fix this problem.
    5- Q Capture has been changed to fix this problem.  Q Capture
    has also been changed to accept the NOWAIT_INTLOAD start-up
    parameter.  The NOWAIT_INTLOAD start-up parameter tells the Q
    Capture program in a Db2 data sharing environment whether to
    start an internal load of the target table immediately, even if
    a long-running transaction that is holding the min_inflight has
    not been committed.  This parameter is valid only if the Q
    subscription is defined with an internal load (IBMQREP_SUBS
    HAS_LOADPHASE='I').
    6- Q Capture has been changed to fix this problem.
    ASNCLP was not updated.
    

APAR Information

  • APAR number

    PH02537

  • Reported component name

    WS REPLICATION

  • Reported component ID

    5655L8800

  • Reported release

    B33

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-06

  • Closed date

    2018-11-29

  • Last modified date

    2019-01-24

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

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

    UI60003 UI60004 UI60005 UI60006

Modules/Macros

  •    ASNAAPP  ASNACMD  ASNACMP  ASNADMSP ASNAFET
    ASNAISO  ASNAMAN  ASNAPP   ASNAPPLY ASNAPRS  ASNAWPN  ASNBNDDR
    ASNBNDSR ASNBPXB  ASNCAP   ASNCATM  ASNCCDA  ASNCCDD  ASNCCMD
    ASNCCPWK ASNCDA   ASNCDD   ASNCDINS ASNCLP   ASNCLPAP ASNCLPB
    ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPCT ASNCLPEV ASNCLPMS ASNCLPQA
    ASNCLPRM ASNCMPLD ASNCSCZ  ASNCTLZD ASNDADK  ASNDBCON ASNDB2CN
    ASNDB2SQ ASNDEDE  ASNDONE  ASNENUP  ASNENUS  ASNESES  ASNFIFI
    ASNFRFR  ASNITIT  ASNJAJP  ASNKOKR  ASNLOAD  ASNMCMD  ASNMDATA
    ASNMON   ASNMONIT ASNMPROC ASNMUPDT ASNNONO  ASNPLPL  ASNPRUNE
    ASNPTBR  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB
    ASNQBNDE ASNQBNDL ASNQBNDR ASNQBNDT ASNQBRWZ ASNQCAP  ASNQCCDA
    ASNQCCDD ASNQCCMD ASNQCTLZ ASNQDEFQ ASNQDEP  ASNQEXRP ASNQFALL
    ASNQJ001 ASNQJ002 ASNQLODZ ASNQMFMT ASNQMSTP ASNQNMIH ASNQPROF
    ASNQP2PA ASNQP2PI ASNQSPC  ASNQSPIL ASNQSPS  ASNQSQLZ ASNQXFMT
    ASNQ1021 ASNQ1140 ASNRBASE ASNRURU  ASNSFALL ASNSQLCZ ASNSVSE
    ASNS1021 ASNTDIFF ASNTDSP  ASNTDSQL ASNTRC   ASNUOW   ASNVCD
    ASNVMON  ASNVREOR ASNVSQL  ASNV1021 ASNV1140 ASNZHCN  ASNZHTW
    ASNZOSCN ASN2BASE ASN2DBCN ASN2DB2C ASN2DB2Q ASN2SQLZ ASN2ZOSC
    

Fix information

  • Fixed component name

    WS REPLICATION

  • Fixed component ID

    5655L8800

Applicable component levels

  • RB33 PSY UI60003

       UP18/12/10 P F812

  • RB34 PSY UI60004

       UP18/12/10 P F812

  • RB35 PSY UI60005

       UP18/12/10 P F812

  • RB36 PSY UI60006

       UP18/12/10 P F812

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

Document Information

Modified date:
24 January 2019