PI39147: HPU FAST UNLOAD OUTPUT LRECL BIGGER THAN ACTUAL RECORD LENGTH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A HPU unload with the FAST UNLOAD syntax requesting an output in
  FORMAT VARIABLE generates an output data set with an irrelevant
  LRECL.
  
  This occurs if the target table has at least one nullable
  column. DB2 HPU counts each null indicator twice thus leading to
  an overestimated record length for the output data set.
  
  PB12771
  

Local fix

• Check if none of the programs using the output of the unload
  jobs affected by the issue do not rely on the unexpected LRECL
  of the data set containing the unloaded data.
  
  If so, consider changing the program before applying the fix.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of XXXXXXXX                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: A HPU unload with the FAST              *
  *                      UNLOAD syntax requesting                *
  *                      an output in                            *
  *                      FORMAT VARIABLE generates               *
  *                      an output data set with an              *
  *                      irrelevant                              *
  *                      LRECL.                                  *
  *                      his occurs if the target                *
  *                      table has at least one                  *
  *                      nullable                                *
  *                      column. DB2 HPU counts each             *
  *                      null indicator twice thus               *
  *                      leading to                              *
  *                      an overestimated record                 *
  *                      length for the output data set.         *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  .....
  

Problem conclusion

• Apply the PTF
  

Temporary fix

Comments

APAR Information

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

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

  UI27358

Modules/Macros

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI27358

     UP15/05/08 P F505

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.