IBM Support

PQ99853: EDITING A TABLE CAN RESULT IN DATA CORRUPTION TO SPECIAL OR NON-DISPLAY CHARACTERS OF A VARCHAR COLUMN.

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When editing a table containing a VARCHAR column, data
corruption can occur when VARCHAR col contains special
or non-display characters.  Bytes containing these special
or non-display characters can be inadvertantly overlayed
with X'4B'.

Local fix

  •

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Table Editor.                   *
****************************************************************
* PROBLEM DESCRIPTION: When editing a table containing a       *
*                      VARCHAR column, data corruption can     *
*                      occur when VARCHAR col contains special *
*                      or non-display characters.  Bytes       *
*                      containing these special or non-display *
*                      characters can be inadvertantly         *
*                      overlayed with X'4B'.                   *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Code has been changed to correct this condition.

Problem conclusion

  • APPLY the PTF.

Temporary fix

  •

Comments

  •

APAR Information

  • APAR number

    PQ99853

  • Reported component name

    DB2 TABLE EDITO

  • Reported component ID

    5697G6500

  • Reported release

    130

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2005-01-21

  • Closed date

    2005-02-21

  • Last modified date

    2005-03-01

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

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

    UK00777

Modules/Macros

  •    ETI$FORM ETI$UPDT H25K130J

Fix information

  • Fixed component name

    DB2 TABLE EDITO

  • Fixed component ID

    5697G6500

Applicable component levels

  • R130 PSY UK00777

       UP05/02/28 P F502

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
30 March 2021

Page Feedback