IBM Support

PI38262: HPU BEHAVES AS IF ULUNIEXP WAS SET TO 100

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If An unload that involves a CCSID conversion from a
    non-UTF8 CCSID to a UTF8 CCSID and does not specify
    UNICODE_EXPANSION_RATIO produces unexpectedly long records.
    
    This occurs if the genuine INZUTIL member from the parmlib has
    been unduly altered after the regular setting through Tools
    Customizer either of the following ways:
    
    - the value in ULUNIEXP = value has been removed
      (i.e. replaced by blanks)
    - the line with  ULUNIEXP = has been removed
    - an asterisk has been placed in the first column of
      the line with ULUNIEXP = value
    
    In such a case, DB2 HPU behaves as if ULUNIEXP was set to 100.
    where the default value 1 should be used.
    Although this situation is a misuse case, the expected default
    value (i,.e,. 1) should be taken into account.
    
    PB12704
    

Local fix

  • Refresh the INZUTIL member by submitting the INZTVAR
    installation job generated from Tools Customizer to restore the
    intended setting for VUU068/ULUNIEXP.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of XXXXXXXXXX                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: An unload that involves a CCSID         *
    *                      ersion from a                           *
    *                      -UTF8 CCSID to a UTF8 CCSID and         *
    *                      not specify                             *
    *                      CODE_EXPANSION_RATIO produces           *
    *                      pectedly long records.                  *
    *                      This occurs if the genuine INZUTIL      *
    *                      member from the parmlib has             *
    *                       been unduly altered after the          *
    *                      regular setting through Tools           *
    *                       Customizer either of the following     *
    *                      ways:                                   *
    *                                                              *
    *                       - the value in ULUNIEXP = value        *
    *                      has been removed                        *
    *                         (i.e. replaced by blanks)            *
    *                       - the line with  ULUNIEXP = has        *
    *                      been removed                            *
    *                       - an asterisk has been placed          *
    *                      in the first column of                  *
    *                         the line with ULUNIEXP = value       *
    *                                                              *
    *                       In such a case, DB2 HPU behaves        *
    *                      as if ULUNIEXP was set to 100.          *
    *                       where the default value 1              *
    *                      should be used.                         *
    *                       Although this situation is a           *
    *                      misuse case, the expected default       *
    *                       value (i,.e,. 1) should be             *
    *                      taken into account.                     *
    *                       PB12704                                *
    *                      LOCAL FIX:                              *
    *                      Refresh the INZUTIL member by           *
    *                      submitting the INZTVAR                  *
    *                      installation job generated from         *
    *                      Tools Customizer to restore the         *
    *                      intended setting for                    *
    *                      VUU068/ULUNIEXP.                        *
    *                                                              *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF                                *
    ****************************************************************
    

Problem conclusion

  • ASPPLY the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI38262

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    420

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-01

  • Closed date

    2015-04-23

  • Last modified date

    2015-05-04

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

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

Modules/Macros

  •    INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R420 PSY UI27012

       UP15/05/01 P F504

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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021