IBM Support

PI82575: DB2 12 FOR Z/OS NEW FUNCTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DB2 12 for z/OS NEW FUNCTION
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 v12 users who wants to use zHyperLink feature for Read   *
    * I/Os                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * New zHyperLink feature provides synchronous I/O access to    *
    * IBM DS8880 System Storage with z14.                          *
    * Db2 support for zHyperlink will exploit this feature to      *
    * improve I/O latency of Db2 applications.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Db2 Buffer Manager random read I/Os will use the new zHyperlink
    feature to perform synchronous read operations when hardware and
    software support for zHyperlink feature is available and
    enabled.
    A new zParm - zHYPERLINK is available to enable this support in
    Db2. By default zHYPERLINK disabled. Users can set zHYPERLINK to
    ENABLE or DATABASE, to perform synchronous data base read I/Os.
    

Problem conclusion

  • This APAR provides Db2 support for zHyperlink for synchronous
    database read I/Os.
    This feature is supported in Db2 for all page sizes however, for
    objects with 32K page size DFSMS APAR OA53889 is also required.
    If OA53889 is not applied, read I/O for 32 K CIs would not be
    able to use zHyperlink function.
    
    PTF for PI82575 can be applied without any dependency, however
    to use the zHyperlink feature, there are other hardware and
    software requirements:
    
    Hardware and firmware
    - IBM z14 with zHyperLink feature enabled
    - IBM DS8880 System storage
    
    Software:
    z/OS and DFSMS APARs to support zHyperlink
    Additional Keywords:
    E3906/K HYPERL/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI82575

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-05

  • Closed date

    2018-01-04

  • Last modified date

    2018-01-04

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

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

    UI50509

Modules/Macros

  • DSNTXAZP DSNTIVIE DSNB1OST DSNBDMPS DSNWZIFC DSNDQWPZ DSNWDFBM
    DSNTIVIA DSNTIWMD DSNTIPA3 DSNDSPRM DSNTIVMD DSNTIWIA DSNTIWIE
    DSNB1RRL DSNWDFTS DSNB1OPP DSNTINST DSNTIDXA DSNTIJUZ DSNTIWIN
    DSNTIDXB DSNB5RDP DSNTINMF DSNDQW00 DSNWDFSH DSNTIVMN DSN6SPRM
    DSNTIWMN DSNB5PCI DSN1PRNT DSN@XAZP DSNTIVIN DSNTIWMS DSNTIVMS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 January 2018