IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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/fmv10apar.pdf
    
    The changes are to the following publications:
    
    PUB ID        PUB NAME
    ------------  ----------------------------------------
    
    SC19-2856-00  File Manager for z/OS Customization Guide
                  Version 10 Release 1
    
    The latest published manuals can be found at:
    http://www.ibm.com/software/awdtools/filemanager/library/
           index.html.
    

APAR Information

  • APAR number

    PM52873

  • Reported component name

    FILE MANAGER ZO

  • Reported component ID

    5655V5200

  • Reported release

    A12

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-11-23

  • Closed date

    2012-02-22

  • Last modified date

    2012-04-30

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

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

    UK76451 UK76452 UK76453 UK76454 PM63521

Modules/Macros

  • FMNASMX  FMNAUDCH FMNAUDDS FMNCBIN  FMNCBLX
    FMNCPCK  FMNDB14  FMNDB88  FMNDYNTP FMNEDIT  FMNEDIT1 FMNEDIT3
    FMNEDIT4 FMNEDIT6 FMNED0DY FMNED0SE FMNED1EX FMNED4CE FMNED4D
    FMNED4EX FMNED4F  FMNED4IN FMNED4LB FMNED4TM FMNESRTM FMNFILTR
    FMNISPF  FMNLKTAB FMNLOCAL FMNLOG2  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 FMN2DBC  FMN2DBI  FMN2DBJ  FMN2DBO  FMN2DBOL FMN2DBP
    FMN2DBV  FMN2DBX  FMN2DBY  FMN2DCIO FMN2DCMD FMN2DCRE FMN2DIUS
    FMN2D2C  FMN2D2E  FMN2D2EC FMN2D2EE FMN2D2EG FMN2D2EI FMN2D2EL
    FMN2D2ES FMN2D2G  FMN2D2SP FMN2EDSP FMN2EDT1 FMN2EOBN FMN2ERR
    FMN2ETRC FMN2EXSY FMN2FBP1 FMN2FDCN FMN2FERW FMN2FMT  FMN2FSQC
    FMN2FTJV FMN2FTPC FMN2F433 FMN2F442 FMN2GISQ 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 FMN2PD2E FMN2PFMS FMN2POPT FMN2PRVP FMN2RALI
    FMN2RESI 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 FMN2SXPM FMN2SXPX FMN2TTBL FMN2UBLD
    

Publications Referenced
SC19285600    

Fix information

  • Fixed component name

    FILE MANAGER ZO

  • Fixed component ID

    5655V5200

Applicable component levels

  • RA1B PSY UK76452

       UP12/02/26 P F202

  • RA10 PSY UK76451

       UP12/02/26 P F202

  • RA12 PSY UK76453

       UP12/02/26 P F202

  • RA13 PSY UK76454

       UP12/02/26 P F202

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
30 April 2012