PM63521: WHEN USING FM/DB2 TO VIEW LARGE TABLES, AND 'ALL" IS ENTERED IN ROW COUNT, DB2 GLOBAL TEMPORARY TABLESPACE FILLS UP.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When viewing a very large table using FM/DB2, and 'ALL' is
  specified in the row count field, the DB2 Global temporary
  tablespace fills up.  This can cause severe impact on critical
  DB2 regions.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of File Manager DB2 component.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 issues SQLCODE-904 errors on the    *
  *                      temporary database when a File Manager  *
  *                      DB2 user edits a DB2 object with row    *
  *                      count = 0.                              *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The File Manager DB2 editor can operate in two modes, normal and
  large.  Large mode is selected by specifying row count = 0 on
  the editor function entry panel.  Large mode processing uses a
  DB2 scrollable cursor to provide access to all rows of the
  result table, while minimizing the memory requirement in the
  user's TSO address space.  DB2 might build a copy of the result
  table in the DB2 temporary database when a scrollable cursor is
  used - this can lead to SQLCODE-904 errors (unavailable
  resource) when processing large DB2 objects, or when the space
  available in the DB2 temporary database is constrained.
  

Problem conclusion

Temporary fix

Comments

• Enhancement APAR.  File Manager DB2 component has been changed
  to allow the product installer to disable large object support
  for the File Manager DB2 editor.  A new FMN2SSDM macro parameter
  EDIT_MAX_ROWS can be specified.  The default is 0, meaning that
  large object support is available, this preserves the existing
  product behaviour.  Specifying EDIT_MAX_ROWS=n, n>0 has two
  effects:
  1.  Large object support is disabled.  When a File Manager DB2
      editor user specifies row count = 0, they instead get a
      normal editor session with at most n rows loaded.
  2.  n sets an absolute limit on the number of rows that may be
      loaded for any File Manager DB2 editor user.  If a user
      sets row count = m, m>n they instead get a normal session
      with at most n rows.
  Note that the new parameter is specified as an FMN2SSDM macro
  parameter, therefore editor large object support can be
  disabled/enabled for each DB2 system defined in the FMN2POPT
  module.
  The FMN2POPT module is affected by this APAR, however the
  module only needs to be modified/re-created when the new
  EDIT_MAX_ROWS parameter is specified with a non-zero value.
  
  Publication Closing Code: DEVCHNG
  For the documentation changes associated with this APAR,
  please refer to:
  ftp://ftp.software.ibm.com/software/websphere/awdtools/
      filemanager/fmv11apar.pdf
  
  The changes are to the following publications:
  
  PUB ID        PUB NAME
  ------------  ----------------------------------------
  
  SC19-3133-03  File Manager for z/OS Customization Guide
                Version 11 Release 1
  
  The latest published manuals can be found at:
  http://www.ibm.com/software/awdtools/filemanager/library/
         index.html.
  

APAR Information

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

  PM52873

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

Modules/Macros

• FMN2LVL  FMN2LVLJ FMN2LVLK
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W4700

Applicable component levels

• RB1B PSY UK81289

     UP12/08/28 P F208

• RB12 PSY UK81290

     UP12/08/28 P F208

• RB13 PSY UK81291

     UP12/08/28 P F208

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.