IBM Support

PM07702: ON PANEL FMN2PEO7 THE SETTINGS FOR THE TWO OPTIONS ARE SWAPPED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On panel FMN2PEO7 the settings for the following two options are
    swapped:
     1.  Edit locking option (locking)
     2.  Keep locks option
    Thus if the user specifies '2' for "Keep locks option" the
    effect is actually to lock the table in share mode.
    The recommended settings for minimal locking are as follows:
    1. Read-only access          OFF
    2. Commit after data fetch   ON
    3. Concurrency               No with clause (1)
    4. Locking                   None (1)
    5. Keep locks option         Use/keep share locks (1)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: FM/DB2 is not adding the "WITH UR"      *
    *                      clause to the SELECT statement used     *
    *                      to access DB2 data for browse and view  *
    *                      only, even though the appropriate       *
    *                      editor option is set for uncommitted    *
    *                      read.                                   *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    File Manager DB2 is ignoring the 'WITH UR' option in browse and
    view modes.
    

Problem conclusion

  • File Manager DB2 component has been updated to correct the
    problem.  The APAR also introduces a small enhancement allowing
    explicit table locking in an FM/DB2 editor session to be
    disabled for all users.  The enhancement is implemented by the
    addition of a new parameter (TABLE_LOCKING) to the FMN2SSDM
    macro.  The default for this new option is TABLE_LOCKING=YES.
    Should a user require that explicit table locking be disabled
    for a particular DB2 system, the FMN2POPT module would need to
    be modified by the addition of TABLE_LOCKING=NO
    to selected FMN2SSDM macro
    specifications, followed by re-application of the appropriate
    usermod.
    Publication Closing Code: DEVCHNG
    For the documentation changes associated with this APAR,
    please refer to:
    ftp://ftp.software.ibm.com/software/websphere/awdtools/
        filemanager/fmv9apar.pdf
    
    The changes are to the following publications:
    
    PUB ID        PUB NAME
    ------------  ----------------------------------------
    
    SC19-2856-00  File Manager for z/OS V10R1 Customization
                  Guide
    
    The latest published manuals can be found at:
    http://www.ibm.com/software/awdtools/filemanager/library/
           index.html.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM07702

  • Reported component name

    FILE MANAGER ZO

  • Reported component ID

    5655V5200

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-02-17

  • Closed date

    2010-07-29

  • Last modified date

    2010-09-01

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

    PK95961

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

Modules/Macros

  • FMN2LVL
    

Publications Referenced
SC19285600    

Fix information

  • Fixed component name

    FILE MANAGER ZO

  • Fixed component ID

    5655V5200

Applicable component levels

  • RA12 PSY UK59244

       UP10/08/04 P F008

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:
01 September 2010