PH38761: ROW ORDER ERROR MESSAGE POINTS TO A WRONG ROW, AOT TABLE UPDATEDUSING LOCATION NOT CORRESPONDING TO 'DB2 SSID' SQL ERROR -4742

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If one subsystem is specified in the "DB2 SSID" field and
  different subsystem location is specified in the "Location"
  field, then saving the changes in the AOT table will result
  in sql error -4742.
  If table is sorted and updates are changing row order then
  error message about invalid value can point to a wrong row.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Table Editor for z/OS       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When several rows are updated and       *
  *                      updates are changing row order error    *
  *                      message can point to a wrong row        *
  *                      If the "Location" field is filled,      *
  *                      then when saving changes in the AOT     *
  *                      table, SQL error -4742 is returned.     *
  ****************************************************************
  If one subsystem is specified in the "DB2 SSID" field and
  another subsystem is specified in the "Location" field, then
  SQL error -4742 will be returned when saving the changes in
  the AOT table.
  If table is sorted and updates are changing row order then
  error message about invalid value can point to a wrong row.
  

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:

  UI76565

Modules/Macros

• ETI2CONN ETI2CSVE ETI2FEXP ETI2MAIN ETI2MEPL ETI2MSGS ETI2PCEP
  ETI2PDAP ETI2PEDT ETI2PFRM ETI2PHST ETI2PLEX ETI2PLOG ETI2PMAN
  ETI2PRDM ETI2PSAC ETI2PSEL ETI2PSQL ETI2PSUB ETI2PTLS ETI2PUST
  ETI61    ETIH611W ETIH612W
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI76565

     UP21/08/14 P F108

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.