IBM Support

PH61577: KEY SEARCH IN ADABAS MU DE SUBTABLE RESULTS IN A L2 TABLESCAN

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • key search in ADABAS MU DE subtable results in a L2 Tablescan
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH61577                                 *
    *                      Poor performance on a key search in     *
    *                      sub table ADABAS L2 Table scan when     *
    *                      using MU descriptor                     *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH61577
    Poor performance on a key search in
    sub table ADABAS L2 Table scan when
    using MU descriptor
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH61577

  • Reported component name

    DATA VIRT MGR Z

  • Reported component ID

    5698DVM00

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-05-29

  • Closed date

    2024-07-25

  • Last modified date

    2024-08-01

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

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

Modules/Macros

  • AVZ$6EPE AVZCCM64 AVZCCMAL AVZCFR64 AVZCGTCM AVZCSQCM AVZCSQOP
    AVZCTSFR AVZCTSRD AVZOAUCK AVZODF9D AVZODF9N AVZODFAD AVZODFAN
    AVZODFBD AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOINSQ
    AVZOIO31 AVZOPMS  AVZOPPA  AVZPB    AVZSIN00 AVZSQ29D AVZSQ29N
    AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN AVZSQLCN
    AVZSQLDN
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UI97789

       UP24/07/26 P F407

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]

Document Information

Modified date:
01 August 2024