IBM Support

PH08648: UPDATE ONLY THOSE CELLS WHOSE VALUES HAVE CHANGED 19/02/15 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Now, Db2 UPDATE statements include only the cells that have
    changed values. With this (enhancement), when a user saves
    changes to a table, the Db2 UPDATE statement created by
    Db2 Table editor includes only the cells that the user updated,
    improving performance and speed.
    
    This fix includes the missing HOLD DB2 and DOC
    information that should have been in UI61218.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM Db2 Table Editor z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Now, Db2 UPDATE statements include      *
    *                      only the cells that have changed        *
    *                      values. With this (enhancement), when   *
    *                      a user saves changes to a table, the    *
    *                      Db2 UPDATE statement created by         *
    *                      Db2 Table editor includes only the      *
    *                      cells that the user updated,            *
    *                      improving performance and speed.        *
    *                                                              *
    *                      This fix includes the missing HOLD      *
    *                      DB2BIND and DOC information that should *
    *                      have been part of UI61218.              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH08648

  • Reported component name

    DB2 TABLE EDITO

  • Reported component ID

    5697G6500

  • Reported release

    150

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-15

  • Closed date

    2019-02-17

  • Last modified date

    2019-03-01

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

    PH06309

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

    UI61347

Modules/Macros

  •    ETIH606E ETI2CONN ETI2CSVE ETI2DB2  ETI2FEXP
    ETI2MAIN ETI2MEPL ETI2MSGS ETI2PCEP ETI2PDAP ETI2PEDT ETI2PFRM
    ETI2PHST ETI2PLEX ETI2PLOG ETI2PMAN ETI2PRDM ETI2PSAC ETI2PSEL
    ETI2PSQL ETI2PSUB ETI2PTLS ETI2PUST ETI60
    

Fix information

  • Fixed component name

    DB2 TABLE EDITO

  • Fixed component ID

    5697G6500

Applicable component levels

  • R150 PSY UI61347

       UP19/03/01 P F902 Ø

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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQU2","label":"Db2 Table Editor"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.5.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 March 2019