PM75333: FM/DB2 COPY UTILITY NOT UPDATING ROWS IN THE TARGET TABLE WHEN A DUPLICATE KEY EXISTS. TARGET TABLE IS A VIEW AND USING DB2 V10.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using FM/DB2 copy utility, target table is not updated when
  a duplicate key exists and the target table is a view.  DB2
  V10 is in use.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message FMNDB511 "Rollback completed"   *
  *                      attempting to copy to a view, DB2       *
  *                      version 10, with the "update duplicate  *
  *                      key" option selected.                   *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  File Manager DB2 component is not processing the view definition
  for the target DB2 object correctly.  This is related to the
  use of SYSIBM.SYSVIEWS.STATEMENT to store the create view DDL in
  DB2 V10 NFM, rather than in SYSIBM.SYSVIEWS.TEXT (before DB2 V10
  NFM).
  

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:

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

  PM83205

Modules/Macros

•    FMN2LVL
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W4700

Applicable component levels

• RB12 PSY UK91298

     UP13/02/06 P F302

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.