PK95007: HPU UNLOAD PLUS FORMAT DSNTIAUL VARCHAR COLUMN GENERATES VB SYSREC DATASET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using HPU UNLOAD Plus syntax, specifying FORMAT DSNTIAUL,
  and Unloading a Table with a VARCHAR column, the Unload dataset
  is allocatd with RECFM VB instead of FB .
  Additional Symptoms:
  1)  When used in BMC Unload Plus syntax, the FORMAT DSNTIAUL
      is incorrectly processed as FORMAT STANDARD.  PB 10268
  2)  The VUM029/DFSIGDCB variable is ignored when using BMC
      Unload Plus syntax. It is only processed when using HPU
      or CA Fast Unload syntax.  PB 10269
  

Local fix

• circumvention: code FIXEDVARCHAR YES to the Unload statement
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. An I/O error can occur when          *
  *                      accessing to a PDS file that has        *
  *                      previously been used by HPU to write    *
  *                      LOB using LOB File Reference. This      *
  *                      occurs when the length of the LOB is    *
  *                      greater than the LRECL of the PDS.      *
  *                      PB 10112                                *
  *                      2. An abend SC03 may occur when         *
  *                      unloading natively a LOB, when the      *
  *                      length of the LOB is an exact           *
  *                      multiple of the LRECL of the output     *
  *                      PDS file.                               *
  *                      PB 10284                                *
  *                      3. Wrong behavior when the decimal      *
  *                      point is set as "comma" in the DB2      *
  *                      configuration:                          *
  *                      - In FastUnload syntax, in              *
  *                       OUTPUT-FORMAT COMMA-DELIMITED, the     *
  *                       decimal and floating point values      *
  *                       are generated with period instead of   *
  *                       a comma as the decimal point.          *
  *                      - In Unload Plus syntax, the decimal    *
  *                       and floating point values in external  *
  *                       format are generated with period       *
  *                       instead of a comma as the decimal      *
  *                       point.                                 *
  *                      PB 6798                                 *
  *                      4. In FastUnload syntax, an error       *
  *                      message  INZU038E UNSUPPORTED TYPE      *
  *                      CONVERSION FOR COLUMN n, is issued      *
  *                      when reformating an empty character     *
  *                      constant in to a character column       *
  *                      defined as NOT NULL. The expected       *
  *                      behavior is either to produce a         *
  *                      varchar of length 0 or a blank char.    *
  *                      PB 10191                                *
  *                      5. Unload Plus syntax:                  *
  *                      When FORMAT DSNTIAUL is specified in    *
  *                      the sysin, the output data is format    *
  *                      in FORMAT STANDARD instead of FORMAT    *
  *                      DSNTIAUL.                               *
  *                      The main difference between FORMAT      *
  *                      STANDARD and FORMAT DSNTIAUL is that    *
  *                      the variable length character strings   *
  *                      (VARCHAR or VARGRAPHIC) are padded to   *
  *                      their mawimum length with binary        *
  *                      zeroes in FORMAT DSNTIAUL while these   *
  *                      columns are written on their actual     *
  *                      length in FORMAT STANDARD. In addition  *
  *                      the RECFM of FORMAT DSNTIAUL is always  *
  *                      FB while the RECFM of FORMAT STANDARD   *
  *                      is VB when variable length columns are  *
  *                      selected. The values for the null       *
  *                      indicator are also different.           *
  *                      PB 10268                                *
  *                      6. Parmlib parameter VUM029/DFSIGDCB    *
  *                      is not used when Unload Plus syntax is  *
  *                      used. This APAR enhances the syntax of  *
  *                      parmlib parameter VUM029/DFSIGDCB, and  *
  *                      allows to specify a value for each      *
  *                      syntax.                                 *
  *                      PB 10269                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module udbspwfl was changed to write correctly members when
  the length of the LOB is greater than the LRECL of the PDS.
  2. Module udbspwlf was changed to process correctly the write
  to the output file when the residual length of previous write
  is null.
  3. Module inzctrlf and inzctrlp were changed to process
  correctly the decimal point from the DSNHDECP module.
  4. Module inzctrlh was changed to accept the descriibed case.
  5. Module inzpyacc, inzctrlh, inzctrlp were changed to process
  correctly the FORMAT DSNTIAUL when using the BMC Unload Plus
  syntax.
  6. Not a bug.
  

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:

Modules/Macros

•    INZADBSK INZIVPSK INZRSAVE INZRSKEL INZSIVP
  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK50086

     UP09/10/05 P F910

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.