IBM Support

PK33751: THE VALUE FOR HIGH2KEY AND LOW2KEY APPEARS IN UNICODE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The value for high2key and low2key sometimes appears in unicode
    when the values in db2 catalogtable are in EBCDIC.
    ADDITIONAL SYMPTOMS:
    Because APAR PK32601 was created for DB2 V9 toleration
    and compatability support before V9 was GA the problem
    description in PK32601 may not be viewable to all IBMLINK
    users so it is duplicated here:
    ERROR DESCRIPTION:
    Version 9 Toleration APAR
    Additional Symptoms:
    1. Change to panel ANLNEW2 to add more complete column
       information.
    2) ONCODE 1009 in EEE with invalid blksize on REPORT
       file.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: The value for high2key and low2key      *
    *                      sometimes appears in unicode when the   *
    *                      values in db2 catalogtable are in       *
    *                      EBCDIC.                                 *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK33751

  • Reported component name

    DB2 SQL PERF AN

  • Reported component ID

    5697F5701

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2006-10-27

  • Closed date

    2006-11-16

  • Last modified date

    2007-01-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK19750

Modules/Macros

  •    ANLHEX3  EEEJBIND EEEJPACK EEEMAIN  EEEPLAN
    EEEPLIN  EEESERV  EEESQ2M  EEETABS  EEEVER8  H1D0220J
    

Fix information

  • Fixed component name

    DB2 SQL PERF AN

  • Fixed component ID

    5697F5701

Applicable component levels

  • R220 PSY UK19750

       UP06/11/23 P F611

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]

Document Information

Modified date:
18 March 2021