PK69808: THE COLLECTION, CURSOR_NAME, AND CLIENT_ENDUSER FIELDS MAY BE INCORRECTLY TRANSLATED IN THE DB2 OFFLOAD.

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.
  

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:

  UK40301

Modules/Macros

•    CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK40301

     UP08/10/08 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.