PM69809: SQLCODE-514 OR -518 IN AN FM/DB2 EDITOR SESSION WITH ROW COUNT = ALL, AFTER ISSUING AN EXPORT EDITOR PRIMARY COMMAND.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE-514 or -518 in an FM/DB2 editor session with row count
  = ALL, after issuing an EXPORT editor primary command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE-518 and SQLCODE-514 in an       *
  *                      FM/DB2 editor session, with the         *
  *                      following conditions:                   *
  *                      1.  The editor row count value is set   *
  *                          to ALL (also 0, *).                 *
  *                      2.  The EXPORT editor primary command   *
  *                          is issued.                          *
  *                      3.  A large scroll command is issued,   *
  *                          eg to the top or bottom of the      *
  *                          result table.                       *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The EXPORT process issues a DB2 COMMIT, which closes the
  scrollable cursor used by the FM/DB2 editor in "large" mode.
  After the export is complete subsequent attempts to scroll
  result in the SQLCODE-518 and SQLCODE-514 errors.
  

Problem conclusion

• File Manager DB2 component has been changed to correct the
  problem.  This APAR resolves internally-reported problem
  PFM06034.
  

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:

  PM72194 106PC1Ÿ UK90048 UK90049 UK90050 UK90051

Modules/Macros

• FMNASMX  FMNAUDCH FMNAUDDS FMNCBIN  FMNCBLX
  FMNCPCK  FMNDB48  FMNDB89  FMNDYNTP FMNEDIT  FMNEDIT1 FMNEDIT3
  FMNEDIT4 FMNEDIT6 FMNED0DY FMNED0SE FMNED1EX FMNED4CE FMNED4D
  FMNED4EX FMNED4F  FMNED4IN FMNED4LB FMNED4TM FMNESRTM FMNFILTR
  FMNISPF  FMNLKTAB FMNLOCAL FMNLOG2  FMNMAIN  FMNPLIX  FMNPPCLA
  FMNPPMN  FMNPPNAV FMNPPTOK FMNRDCCO FMNRDFFD FMNRDFNM FMNRDFSG
  FMNRDFTB FMNRDMSC FMNRDR   FMNRDRAR FMNRDRCV FMNRDR2  FMNRDUFD
  FMNRDUHX FMNRDUSG FMNRDUTB FMNRDUZD FMNRDU2V FMNRDXML FMNRD2IN
  FMNRMBAE FMNRMINI FMNRMPOP FMNRMR   FMNRMRED FMNRMR2  FMNRMUPD
  FMNSCREX FMNSCRFD FMNTPBFM FMNTPDFD FMNTPEFL FMNTPEFM FMNTPEVL
  FMNTRTMP FMN0LVL  FMN0SAF  FMN2ABUF FMN2ABXT FMN2ACNM FMN2AJSQ
  FMN2ASQD FMN2ATXT FMN2AUDI FMN2A2IO FMN2BCNL FMN2BCTQ FMN2BDBQ
  FMN2BNCL FMN2BONM FMN2BUCL FMN2BUTQ FMN2CATQ FMN2CD2V FMN2CGM2
  FMN2CHKI FMN2CKCN FMN2CNVR FMN2CSQI FMN2CTMP FMN2CTM1 FMN2CTM2
  FMN2CTQ2 FMN2C2IO FMN2DATA FMN2DBC  FMN2DBI  FMN2DBJ  FMN2DBO
  FMN2DBOL FMN2DBP  FMN2DBV  FMN2DBX  FMN2DBY  FMN2DCIO FMN2DCMD
  FMN2DCRE FMN2DIUS FMN2D2C  FMN2D2E  FMN2D2EC FMN2D2EE FMN2D2EG
  FMN2D2EI FMN2D2EL FMN2D2ES FMN2D2G  FMN2D2IO FMN2D2I7 FMN2D2I8
  FMN2D2SP FMN2EDSP FMN2EDT1 FMN2EOBN FMN2ERR  FMN2ETRC FMN2EXSY
  FMN2FDCN FMN2FMT  FMN2FSQC FMN2FTJV FMN2FTPC FMN2GISQ FMN2GSC0
  FMN2GSC8 FMN2GSC9 FMN2GVW0 FMN2GVW8 FMN2GVW9 FMN2GV20 FMN2GV28
  FMN2GV29 FMN2HLI  FMN2IDTB FMN2INTE FMN2INTJ FMN2INTP FMN2IPSU
  FMN2ISPF FMN2ISQ  FMN2ISQG FMN2ISQI FMN2ISQS FMN2ITSV FMN2IVSU
  FMN2LIBS FMN2LOCL FMN2LVL  FMN2LVLJ FMN2LVLK FMN2MAIN FMN2MENU
  FMN2MISC FMN2MJPN FMN2MKOR FMN2MXXX FMN2OPTL FMN2PDP  FMN2PFMS
  FMN2POLT FMN2POPT FMN2PRVP FMN2RALI FMN2RMDT FMN2RMQ  FMN2RMR
  FMN2RMR2 FMN2RMUT FMN2SAGF FMN2SAPR FMN2SBPR FMN2SCON FMN2SCST
  FMN2SEDX FMN2SELS FMN2SENX FMN2SERR FMN2SHSQ FMN2SIDM FMN2SNTX
  FMN2SNXP FMN2SQLC FMN2SQSU FMN2SQS2 FMN2SQTB FMN2SSDM FMN2SSID
  FMN2SSQL FMN2SSSU FMN2STG  FMN2STRP FMN2STUT FMN2SXPM FMN2SXPX
  FMN2TTBL FMN2UBLD
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W4700

Applicable component levels

• RB1B PSY UK90049

     UP12/12/08 P F212

• RB10 PSY UK90048

     UP12/12/08 P F212

• RB12 PSY UK90050

     UP12/12/08 P F212

• RB13 PSY UK90051

     UP12/12/08 P F212

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.