IBM Support

PI94822: LOCKING REPORT LEVEL(SUSPENSION) ENDING WITH RC=8 AND FPEU0020E,FPEC4002E, FPEC0910E ERROR MESSAGES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer running LOCKING REPORT LEVEL(SUSPENSION) receives:
    .
    FPEU0020E  UNABLE TO ALLOCATE VIRTUAL STORAGE. GETMAIN RETURN
    CODE: 4, STORAGE REQUESTED: 5836800, SUBPOOL: 0, LOCATION: ANY
    FPEC4002E  LOCKING FAILED DURING THE RECORD PROCESSING PHASE
    FPEC0910E  NO REPORTS HAVE BEEN PRODUCED DUE TO PREVIOUS ERRORS
    FPEC0999I  EXECUTION COMPLETE. RETURN CODE 8
    .
    KEYWORDS:  locking suspension FPEU0020E FPEC4002E FPEC0910E
               batch report IFCID 21
    

Local fix

  • Add EXCLUDE (IFCID(21)) to the SYSIN GLOBAL clause to avoid
    memory depletion.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2   *
    *                 PM users of component                        *
    *                    -  Batch Reporting                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: Batch LOCKING REPORT job ended with the *
    *                      RC=8 and messages FPEU0020E, FPEC4002E, *
    *                      FPEC0910E, indicating that a storage    *
    *                      shortage occurred.                      *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    Batch LOCKING code may fail to accommodate a large burst of row
    locking requests in IFCID 21. This failure may happen even when
    LEVEL(DETAIL) is not requested.
    

Problem conclusion

  • The code was changed to keep only the most recent 20K row
    locking requests in memory if LEVEL(DETAIL) is requested. If
    LEVEL(DETAIL) is not requested for any LOCKING REPORT or TRACE
    then LOCKING code will not accumulate row locking requests at
    all. This change may result in improved performance for LOCKING
    REPORTs and TRACEs that do not specify LEVEL(DETAIL).
    
    Search Keywords:
    BATCH LOCKING REPORT TRACE MSGFPEU0020E MSGFPEC4002E
    MSGFPEC0910E RC8 RC08
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI94822

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-07

  • Closed date

    2018-06-01

  • Last modified date

    2018-07-02

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

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

    UI56230 UI56231 UI56232

Modules/Macros

  •    DGOLADLK DGOLAEOF DGOLAOTH DGOLAREQ DGOLARES
    DGOLASUM DGOLASUS DGOLATIM DGOLCREC DGOLDIST DGOLFILE DGOLIREC
    DGOLREDC DGOLREXT DGOLTRAC DGOLZREC
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R520 PSY UI56230

       UP18/06/02 P F806

  • R530 PSY UI56231

       UP18/06/02 P F806

  • R540 PSY UI56232

       UP18/06/02 P F806

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 July 2018