IBM Support

PK02184: DBR NOT WORKING IF PARTITION SELECTION EXIT DEFINED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a dbd has a PSE (Partition Selection Exit) dbr must invoke it
    to determine which partition to use
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IMS Database Repair Facility - Version 1.1.  *
    ****************************************************************
    * PROBLEM DESCRIPTION: If a HALDB has PSE defined,DBR does not *
    *                      use it to select the partition,thus it  *
    *                      can't correctly find the right segment  *
    *                      based on key.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DBR currently ignores the fact that a PSE may be applicable for
    a given HALDB. Then if you enter a key on panel fabzps1p, DBR
    chooses partition based on hikey valued defined for that
    partition...which is incorrect if a PSE is defined. The result
    may vary, but most likely you end up with fabz028 key not found.
    

Problem conclusion

  • Logic was fixed to take PSE into account. There are many ways to
    define a PSE for HALDB, but the definition ends up in the recon
    records, which DBR reads to determine if a HALDB has a PSE.
    Now, on panel fabzps1p, for HALDB DBD, you see a field
    'PSEName=' ...it will contain the PSE name, or be '**NULL**'. If
    the psename exists,then DBR will drive the PSE with the key
    entered on fabzps1p, and PSE will return the partition ID which
    will be used to find the segment with that key.
    New message.
    FABZ095I: Cannot specify DBD & Key when PSE Name is not **NULL**
    Explanation: If you are doing Key search,must clear the DBD fiel
    System action: processing continues
    Problem Determination: none
    Programmer Response: clear the DBD field, leave key in key field
    110Y
    FABZDATA
    FABZDBLS
    FABZDBMP
    FABZMAIN
    FABZOSMB
    FABZPROC
    FABZPRO2
    FABZPSEI
    FABZPS1P
    FABZPS1X
    FABZ09
    H22K110J
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK02184

  • Reported component name

    IMS DATABASE RE

  • Reported component ID

    5655E0300

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2005-03-08

  • Closed date

    2005-03-15

  • Last modified date

    2005-04-01

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

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

    UK01510

Modules/Macros

  • FABZDATA FABZDBLS FABZDBMP FABZMAIN FABZOSMB
    FABZPROC FABZPRO2 FABZPSEI FABZPS1P FABZPS1X FABZ09   H22K110J
    

Fix information

  • Fixed component name

    IMS DATABASE RE

  • Fixed component ID

    5655E0300

Applicable component levels

  • R110 PSY UK01510

       UP05/03/16 P F503

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.

[{"Line of Business":{"code":null,"label":null},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCX892","label":"IMS Database Repair Facility"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"110"}]

Document Information

Modified date:
14 December 2020