IBM Support

PI90985: HPU TO BE ABLE TO PUT THE NULL INDICATOR GROUPED AT THE BEGINNING OF THE RECORD

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • In the CA OUTPUT FORMAT VARIABLE, all the null indicators (one
    byte for each nullable
    column to tell if the column contains a NULL value or not) are
    located all together at the
    beginning of the record, before all the columns.
    
    This is something that we cannot do in the HPU syntax, simply
    because the only possibility is to say that the null indicator
    is either just before or just after the column itself.
    This is possible with CA compatibility syntax but not with HPU
    "native" syntax.
    
    RFE70048  PB46928 RTC44162
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: In the CA OUTPUT FORMAT VARIABLE, all   *
    *                      the null indicators (one byte for each  *
    *                      nullable column to tell if the column   *
    *                      contains a NULL value or not) are       *
    *                      located all together at the beginning   *
    *                      of the record, before all the columns.  *
    *                      This is something that we cannot do in  *
    *                      the HPU syntax, simply because the      *
    *                      only possibility is to say that the     *
    *                      null indicator is either just before    *
    *                      or just after the column itself. This   *
    *                      is possible with CA compatibility       *
    *                      syntax but not with HPU "native"        *
    *                      syntax.                                 *
    *                      pb46928                                 *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    N/A (Enhancement)
    

Problem conclusion

Temporary fix

Comments

  • APPLY the PTF.
    

APAR Information

  • APAR number

    PI90985

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    430

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-01

  • Closed date

    2017-12-29

  • Last modified date

    2018-02-01

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

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

    PI90986 UI52952

Modules/Macros

  •    INZ$$PRM INZTVAR  INZUTILK INZUTILX
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R430 PSY UI52952

       UP18/01/06 P F801

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":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021