PK56657: Q CAPTURE CONVERTS CHARACTER DATA INCORRECTLY WHEN PUBLISHING DELIMITED MSGS USING DIFFERENT CCSID'S.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Q Capture converts character data incorrectly when it publishes
  delimited messages if its plan is bound specifying an encoding
  CCSID that is different from its application codepage (CCSID
  1047).  Q Capture converts delimited message character data it
  generates from its DB2 plan encoding CCSID to the codepage
  specified in the IBMQREP_SENDQUEUES MESSAGE_CODEPAGE column for
  the destination send queue.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Q Capture, SQL Capture                    *
  *                 2- Q Capture or SQL Capture on DB2 V9 NFM    *
  *                 3- SQL Capture and Q Capture                 *
  *                 4- z/OS customers using Q Capture to         *
  *                 publish delimited messages.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- In DB2 V9 NFM, if the user performs  *
  *                      multiple alter add columns to the same  *
  *                      table in the same transaction, capture  *
  *                      has an error.                           *
  *                      2- Subscription or registration will    *
  *                      not start due to ASN7167.               *
  *                      3- Internal notification message type   *
  *                      TRANS_QUEUE_TERM_MSG was unrecognized   *
  *                      4-  Q Capture converts character data   *
  *                      incorrectly when it publishes           *
  *                      delimited messages if its plan is       *
  *                      bound specifying an encoding CCSID      *
  *                      that is different from its application  *
  *                      codepage (CCSID 1047).                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Capture will try to insert into it's version table for each
  alter.  However, DB2 only generates one new version per
  transaction, not per alter.
  2- Capture incorrectly checks to see if a table has been
  altered or reorged and may produce false positives.
  3- Capture should recognize TRANS_QUEUE_TERM_MSG instead of
  putting out an error message
  4-  Q Capture converts delimited message character data it
  generates from its DB2 plan encoding CCSID to the codepage
  specified in the IBMQREP_SENDQUEUES MESSAGE_CODEPAGE column for
  the destination send queue.
  

Problem conclusion

• 1- Capture will handle the alter add columns and versioning
  correctly.
  2- Capture will activate subscriptions/registrations on tables
  that have not been altered or have been reorged.
  3- Capture now recognizes TRANS_QUEUE_TERM_MSG
  4- Modify Q Capture to convert delimited message character data
  it generates from its application codepage (CCSID 1047) to the
  codepage specified in the IBMQREP_SENDQUEUES MESSAGE_CODEPAGE
  column for the destination send queue.  Modify Q Capture to
  convert delimited message character data it gets from DB2 from
  the DB2 plan encoding CCSID to the codepage specified in the
  IBMQREP_SENDQUEUES MESSAGE_CODEPAGE column for the destination
  send queue.
  

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:

  UK31595 UK31596 UK31597 UK31598

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNMCMD  ASNMIG8  ASNMON   ASNPLXFY ASNQACMD ASNQAPP  ASNQCAP
  ASNQCCMD ASNQDEP  ASNQMFMT ASNQSQL  ASNQSUB  ASNQSUBM ASNQWK
  ASNQXFMT ASNRBASE ASNREG   ASNSQLCF ASNSQLCZ ASNTDIFF ASNTRC
  ASNTREP
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY UK31595

     UP07/12/05 P F712

• R911 PSY UK31596

     UP07/12/05 P F712

• R912 PSY UK31597

     UP07/12/05 P F712

• R913 PSY UK31598

     UP07/12/05 P F712

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.