IBM Support

PI60116: DB AUTHORIZATION NOT REQUESTED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The HSSR Engine of HP Unload does not request DB authorization
    to DBRC erroneously under the following conditions:
     - Non-HALDB
     - MDA members for DBDS in IMSDALIB DD
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of IMS High Performance Unload for *
    *                 z/OS Version 1 Release 2 (FMID=H1IN120)      *
    ****************************************************************
    * PROBLEM DESCRIPTION: The HSSR Engine of HP Unload does not   *
    *                      issue the IMS DBRC authorization        *
    *                      request for non-HALDB erroneously.      *
    ****************************************************************
    * RECOMMENDATION: Apply the maintenance for this APAR.         *
    ****************************************************************
    The HSSR Engine of HP Unload does not issue the IMS DBRC
    authorization request erroneously under all the following
    conditions;
    -  DBRC=Y
    -  non-HALDB is registered in the RECON data sets
    -  The library containing the DFSMDA members for dynamic
       allocation of database data sets specified on IMSDALIB DD.
    - If DLI or DBB region, the number of DBPCBs is one.
    

Problem conclusion

  • After applying this APAR, the IMS DBRC authorization for a
    non-HALDB access will be requested newly under the following
    conditions:
    - DBRC=Y
    - non-HALDB is registered in the RECON data sets
    - The library containing the DFSMDA members for dynamic
      allocation of database data sets specified on IMSDALIB DD.
    - The number of DBPCBs is one in DLI or DBB region
    
    ATTENTION:
    When IMS DBRC denies the request, the HSSR Engine issues
    ABENDU4013 after the DFS047A message:
     DFS047A   UNABLE TO OBTAIN AUTHORIZATION FOR DATA BASE name
    For the reason and action, refer to the IMS message and codes.
    
    If two or more DBPCBs are defined in PSB for DLI or DBB
    authorization is not requested:
     FABH0670W DB-ACCESS NOT AUTHORIZED BY DBRC: DB=dbdname
    The jobstep return code is zero.
    
    ========================
    = DOCUMENTATION CHANGE =
    ========================
    The IBM IMS High Performance Unload for z/OS User's Guide
    Version 1 Release 2 Suffix 8 (SC27-0936-08) should be changed
    as follows:
    
    ---------------------------------------------------------------
    > Unloading IMS databases
    >>  Introduction to the unload utilities
    >>> Restrictions for IMS High Performance Unload
    
    The following restrictions apply to all HSSR application
     programs including the FABHURG1 utility and the FABHFSU
     utility:
     - Logical DBD is not supported.
     - A sensitive virtual logical child (LCHILD) is not supported.
     - Field sensitivity for an HSSR PCB is not supported.
    |- For the restrictions of the DBRC authorization for the
    |  database access, see "Support of database level sharing".
    :
    ---------------------------------------------------------------
    > Application programming interface for using HSSR Engine
    >> Consideration for database sharing
    
    Support of database level sharing
    
     IMS High Performance Unload provides the same support for
     database level sharing as IMS. This support requires that DBRC
     be installed and active, and that the database be registered
     in the DBRC RECON data sets.
    
     Application program running in DLI or DBB region
    :
    |Restriction: If two or more DBPCBs are defined in the PSB
    |and the library containing the DFSMDA members for dynamic
    |allocation of the database data sets is specified on the
    |IMSDALIB DD statement, DBRC authorization for the database
    |access is not requested. The library must be concatenated
    |to STEPLIB DD.
    ---------------------------------------------------------------
    > Troubleshooting
     >> Messages and codes
     >>> Messages
     >>>> FABH messages
    
    |FABH0670W DB-ACCESS NOT AUTHORIZED BY DBRC: DB=dbdname
    |
    |Explanation: The DBRC authorization for the database access
    |is not requested, because two or more DBPCBs are defined in
    |the PSB and the library containing the DFSMDA members
    |for dynamic allocation of the database data sets are specified
    |on the IMSDALIB DD statement.
    |System action: HSSR Engine continues processing without
    |obtaining DBRC authorization.
    |User response: Specify the library containing the DFSMDA
    |members on the STEPLIB DD statement.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI60116

  • Reported component name

    IMS HIGHPERF UN

  • Reported component ID

    5655E0600

  • Reported release

    120

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-01

  • Closed date

    2016-04-28

  • Last modified date

    2016-05-04

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

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

    UI37408

Modules/Macros

  •    FABH010A FABH010B FABH0102 FABH0103 FABH0104
    FABH0108 FABH0109 FABH040
    

Publications Referenced
SC27093608    

Fix information

  • Fixed component name

    IMS HIGHPERF UN

  • Fixed component ID

    5655E0600

Applicable component levels

  • R120 PSY UI37408

       UP16/04/30 P F604 Ž

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":"LOB10"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSCX89K","label":"IMS Tools"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.2.0"}]

Document Information

Modified date:
14 December 2020