PH56776: Q capture terminated with ASN0678E though TERM=N

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Capture program gets SIGSEGV or terminates with ASN0678E
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Any client using TERM=N with asnqcap or   *
  *                 asnqapp                                      *
  *                 2- All SQL Apply users                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- The Capture program gets SIGSEGV or  *
  *                      terminates with ASN0678E                *
  *                      2- SQL Apply TRUNCATE failed SQLCODE    *
  *                      -428                                    *
  ****************************************************************
  1- With TERM=N, depending on the time where Db2 or MQ down is
  detected, the program threads may not be terminated gracefully
  leading to threads being killed and un-initialized memory
  accessed.
  2- Currently, when performing a fullrefresh, the APPLY program
  will execute the TRUNCATE command
  

Problem conclusion

• 1- MQ and Db2 being stopped or quiesced is detected, the
  threads terminate gracefully, and the program waits for them to
  restart instead of coming down.
  2- Apply should retry the TRUNCATE operation with a COMMIT
  before DELETE. If Apply still fails -428, then Apply should
  retry using DELETE.
  ASNCLP was not updated.
  Function Level: 1140.103
  

Temporary fix

Comments

APAR Information

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

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

  UI94083 UI94084 UI94085 UI94086

Modules/Macros

• ASN2BASE ASN2DB2Q ASN2DBCN ASN2SQLZ ASN2ZOSC ASNAAPP  ASNACMD
  ASNADMSP ASNAPPLY ASNCAP   ASNCATM  ASNCCMD  ASNCCPWK ASNCDINS
  ASNDB2SQ ASNDBCON ASNMCMD  ASNMON   ASNPRUNE ASNQACMD ASNQAHKT
  ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBRWZ ASNQCAP  ASNQCCMD
  ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT ASNQP2PA ASNQP2PI ASNQSPIL
  ASNQSQLZ ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF ASNTDSP  ASNTRC
  ASNUOW   ASNZOSCN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI94083

     UP23/10/21 P F310

• RB34 PSY UI94084

     UP23/10/24 P F310

• RB35 PSY UI94085

     UP23/10/24 P F310

• RB36 PSY UI94086

     UP23/10/21 P F310

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.