PH67089: Capture comes down when performing alter table drop column for LOB column

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Capture comes down when performing alter table drop column for
  LOB column
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Any client using TERM=N for any program   *
  *                 (asnmon, asnqapp, asnqcap, etc)              *
  *                 2- All customers replicating tables with     *
  *                 LOB columns.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- The program SIGSEGV or terminates    *
  *                      with ASN0678E                           *
  *                      2- If there is LOB column in a table,   *
  *                      db2 automatically creates a hidden      *
  *                      ROWID column if none already exist.     *
  *                      When the last LOB column is dropped     *
  *                      from the table, Db2 automatically       *
  *                      drops the ROWID column if it was        *
  *                      created for the LOB.                    *
  ****************************************************************
  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- Q Capture replicates drop column by processing the log
  records for changes to SYSIBM.SYSTABLES. For drop column it
  checks the number of columns in SYSIBM.SYSTABLES before and
  after the drop column, expecting the number of columns to
  decrease by 1.  But, when a LOB column and the associated ROWID
  column are dropped the before and after counts differ by 2
  causing Capture to come down with rc 6005.
  

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- When the last LOB column is dropped, Q Capture will
  correctly replicate the DROP COLUMN.
  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:

  UO03907 UO03908 UO03909 UO03910

Modules/Macros

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

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UO03907

     UP25/07/10 P F507

• RB34 PSY UO03908

     UP25/07/11 P F507

• RB35 PSY UO03909

     UP25/07/10 P F507

• RB36 PSY UO03910

     UP25/07/10 P F507

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.