PM82521: SEE AN INCREASE IN THE NUMBER OF UNCOMMITTED UR INCIDENTS BEING GENERATED IN FM/DB2 V12.1 VS. V11.1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Client sees an increase in the number of  Uncommitted UR
  incidents being generated by queries being run when viewing DB2
  table data using File Manager V12.1
  

Local fix

• 1. This issue can be avoided by turning off the 'Read-only
     access' option on the last editor options panel (7/7).
  
  2. Even with the change that will be made in the APAR, DSNU035I
     messages may be issued for a customer using FM/DB2 edit
     (not view or browse) in 'Large table' mode (row count = 0,
     ALL, *).
  
     These messages will not be issued unless the user has the
     'Read-only access' option selected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 issues DSNR035I messages under some *
  *                      circumstances, caused by File Manager   *
  *                      DB2 component editor sessions.          *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Certain combinations of File Manager editor options can result
  in fetches against DB2 data using "uncommitted read", without
  a COMMIT after the initial data fetch.  This can lead to DB2
  issuing DSNR035I messages after a DB2-installation-dependent
  delay.
  

Problem conclusion

• The File Manager DB2 component editor has been changed to:
  1. For browse and view, always issue a COMMIT after the initial
  data fetch, regardless of the editor's operating mode ("normal"
  or "large").
  2. For edit sessions in "large" mode, issue a COMMIT after the
  initial data fetch when the "Commit after data fetch" is
  selected.
  3. Display a warning panel for any edit session where the editor
  options include "Uncommitted read" and no "Commit after data
  fetch".
  

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:

  PM82770 UK94271 UK94282 UK94284 UK94290 UK94350

Modules/Macros

• FMNAUDCH FMNCLPB  FMNCLPBE FMNDISK2 FMNDSE   FMNDVB   FMNEDCHK
  FMNEDCP  FMNEDCRS FMNEDCU  FMNEDF01 FMNEDIPP FMNEDIRE FMNEDIT
  FMNEDIT1 FMNEDIT2 FMNEDIT3 FMNEDIT4 FMNEDIT5 FMNEDIT6 FMNEDIT7
  FMNEDIUP FMNEDIXM FMNEDIXP FMNEDM01 FMNEDPA  FMNEDPRF FMNEDRF2
  FMNED0DY FMNED0SE FMNED008 FMNED1EX FMNED4BN FMNED4C  FMNED4CE
  FMNED4CR FMNED4D  FMNED4EX FMNED4F  FMNED4GT FMNED4IN FMNED4L
  FMNED4LB FMNED4LE FMNED4M  FMNED4OV FMNED4PT FMNED4R  FMNED4RF
  FMNED4RI FMNED4SV FMNED4TM FMNED4VW FMNED4XL FMNED5FL FMNEGXML
  FMNERSTA FMNESRTM FMNESRTQ FMNE35   FMNFCH   FMNFILTR FMNMAIN
  FMNMQQE  FMNMQQV  FMNMSEL  FMNPPNAV FMNPPPRZ FMNQE    FMNRMANY
  FMNRMDAT FMNRMINI FMNRMR   FMNRMRED FMNRMUPD FMNTPEFL FMNVE
  FMN0LVL  FMN1ECMD FMN1EDIF FMN1EGHL FMN1ETOS FMN1FIND FMN1ISRT
  FMN1LVL  FMN1RALL FMN1RASG FMN1RMDT FMN1SSTA FMN2DBX  FMN2D2E
  FMN2D2EC FMN2D2EE FMN2D2EG FMN2D2EI FMN2D2EL FMN2D2ES FMN2EDT1
  FMN2IPSU FMN2ISQ  FMN2ISQG FMN2ISQI FMN2ISQS FMN2ITSV FMN2LVL
  FMN2LVLJ FMN2LVLK FMN2PUCR FMN2RD63 FMN2RD64 FMN2RD65 FMN2RMDT
  FMN2RMR
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W4700

Applicable component levels

• RB1B PSY UK94282

     UP13/05/22 P F305

• RB10 PSY UK94271

     UP13/05/22 P F305

• RB12 PSY UK94284

     UP13/05/22 P F305

• RB13 PSY UK94290

     UP13/05/22 P F305

• RB14 PSY UK94350

     UP13/05/22 P F305

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.