PK62237: MQListener should not convert the message to the the queue manager CCSID during the retrieving by MQGET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MQlistener sets MQGMO_CONVERT option to the message option so
  the message is converted to the queue manager CCSID during the
  retrieving by MQGET.
  The message can be corrupted by this conversion.
  

Local fix

• No workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of MQlistener for DB2 V8          *
  *                  and DB2 9 for z/OS are affected.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:  MQlistener sets MQGMO_CONVERT option   *
  *                       to the message option; this causes the *
  *                       message to be converted to the queue   *
  *                       manager CCSID during processing by     *
  *                       the MQGET function.                    *
  *                       The message can be corrupted by the    *
  *                       conversion if some of the characters   *
  *                       cannot be converted to the queue       *
  *                       manager CCSID. For example:            *
  *                       If the message is an Unicode encoded   *
  *                       message then the message can be        *
  *                       corrupted by the conversion from       *
  *                       Unicode to EBCDIC                      *
  *                       (based on queue manager CCSID).        *
  *                       If the conversion fails, then          *
  *                       MQGET function returns a warning       *
  *                       return code causing the termination    *
  *                       of MQlistener.                         *
  ****************************************************************
  * RECOMMENDATION:  All users need to apply the fix to avoid    *
  *                  the wrong conversion of the MQ message.     *
  ****************************************************************
   While retrieving the message from the MQ queue, the character
   data of the message should not be converted to the queue
   manager's character set.
  

Problem conclusion

• To fix the problem, MQlistener does not set the MQGMO_CONVERT
  option to message option so that the MQGET function will not do
  the conversion of MQ message to the queue manager's CCSID
  during the message processing.
  MQlistener informs DB2 on the stored procedure CALL about the
  CCSID of the MQ message string passed, whatever it happens to
  be. This is done using a standard CCSID override in the SQLDA
  for the parameters of the stored procedure.
  

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:

  UK36416 UK36417

Modules/Macros

• DSN@MQCF DSN@MQRN DSNAMQLN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK36416

     UP08/05/28 P F805

• R910 PSY UK36417

     UP08/05/28 P F805

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.