PI12254: Receive message 'Commit issued (Errors)', when SAVE command is entered after insert/delete of duplicate key row using FM/DB2.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a SAVE command is entered, after inserting a duplicate key
  row and then subsequently deleting it, message 'Commit issued
  (Errors)' is incorrectly received from FM/DB2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the File Manager DB2 component       *
  *                      editor, message 'Commit issued          *
  *                      (Errors)' is issued after an explicit   *
  *                      SAVE when no rows are marked in error.  *
  *                      The failing scenario is described       *
  *                      below:                                  *
  *                      1.  Edit a DB2 table with a unique      *
  *                      index.                                  *
  *                      2.  Repeat any existing row twice.      *
  *                      3.  Change one of the new rows so that  *
  *                      the unique index key value is unique.   *
  *                      4.  Press PF3, message 'Commit issued   *
  *                      (Errors)' is issued, the other new row  *
  *                      is marked in error.                     *
  *                      5.  Delete the row marked in error.     *
  *                      6.  Issue an explicit SAVE command.     *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  

Problem conclusion

• File Manager DB2 component has been updated to correct the
  problem.
  

Temporary fix

Comments

APAR Information

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

  PI10900

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

Modules/Macros

• FMN2LVL
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655Q1200

Applicable component levels

• RD12 PSY UI17000

     UP14/04/19 P F404

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.