PK70520: COLLECTION CURSOR_NAME AND CLIENT_ENDUSER FIELDS INCORRECTLY TRANSLATED IN OFFLOAD, CQM1153E RETURN CODE 08 REASON CODE 03

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 version dependent fields; collection, cursor_name, and
  client_enduser; may be incorrectly translated if the program
  name is N/A.
  
  Normally, the offload process bases translation settings on the
  version of the RDI. When a program name can not be collected,
  the RDI is not found and the program is set to 'N/A'. Under
  these conditions, the offload will assume the translation
  settings for the DB2 version from which the data was collected;
  UTF8 for V8 and above and EBCDIC for V7.
  
  For example, when the translation does not occur, the resulting
  output may show UTF8 collection names appearing in an EBCDIC
  table.
  
  
  ALSO, this APAR addresses message
     CQM1153E RETURN CODE 08 REASON CODE 03 WAS ENCOUNTERED
     DURING TRANSLATION SOURCE CCSID = nnnnn TARGET CCSID = 1208
  
  which may occur during the DB2 offload process.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 version dependent fields;       *
  *                      collection, cursor_name, and            *
  *                      client_enduser; may be incorrectly      *
  *                      translated if the program name is N/A.  *
  *                      Normally, the offload process bases     *
  *                      translation settings on the version of  *
  *                      the RDI. When a program name can not    *
  *                      be collected, the RDI is not found and  *
  *                      the program is set to 'N/A'. Under      *
  *                      these conditions, the offload will      *
  *                      assume the translation settings for     *
  *                      the DB2 version from which the data     *
  *                      was collected; UTF8 for V8 and above    *
  *                      and EBCDIC for V7. For example, when    *
  *                      the translation does not occur, the     *
  *                      resulting output  may show UTF8         *
  *                      collection names appearing in an        *
  *                      EBCDIC table.                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK40305 UK40306

Modules/Macros

•    CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK40305

     UP08/10/09 P F810

• R221 PSY UK40306

     UP08/10/09 P F810

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.