PM72194: 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.
  
  Publication Closing Code: DEVCHNG
  For the documentation changes associated with this APAR,
  please refer to:
  ftp://public.dhe.ibm.com/software/websphere/awdtools/
      filemanager/fmv12apar.pdf
  
  The changes are to the following publications:
  
  PUB ID        PUB NAME
  ------------  ----------------------------------------
  
  SC19-3675-00  File Manager for z/OS V12R1 User's Guide
                and Reference for DB2 Data
  
  The latest published manuals can be found at:
  http://www.ibm.com/software/awdtools/filemanager/library/
         index.html.
  

Temporary fix

Comments

APAR Information

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

  PM69809

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

Modules/Macros

•    FMN2LVL
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W6800

Applicable component levels

• RC12 PSY UK83656

     UP12/11/24 P F211

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.