PK13580: THIS APAR WILL PROVIDE NEW FUNCTION SUPPORT FOR HPU IN NATIVE MODE TO PROCESS VARCHAR( ). PB 7518

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• THIS APAR WILL PROVIDE NEW FUNCTION SUPPORT FOR HPU IN NATIVE
  MODE TO PROCESS VARCHAR( ). PB 7518
  ADDITIONAL SYMPTOMS:
  1) Native support of numeric constants C'n' and of all in the
  convertion from a constant string to another format specified
  INTO clause of Fast Unload syntax. PB 7273 - MR062405470
     INZU021E UNSUPPORTED CONVERSION CONSTANT INTEGER TO DECIMAL
  2) New parmlib parameter will allow to change the half byte sign
     on DECIMAL PACKED and DECIMAL ZONED data, and date/time
     formats that use DECIMAL PACKED and DECIMAL ZONED.
     PB 7287 - MR0707055324
  3) FastUnload : support of comments: "*" in column 1 of Unload
     statement. PB 7460 - MR0804057429
  
  
  4) Error on COPYDDN CHECK with multiple DDNAME (in case of FIC
     per partition). PB 7575
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - THIS APAR WILL PROVIDE NEW FUNCTION S *
  *                      MODE TO PROCESS VARCHAR( ). PB 7518     *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1- Native support of numeric constants  *
  *                       C'n' and of all convertion from a      *
  *                       constant string to another format      *
  *                       specified in the INTO clause of Fast   *
  *                       Unload syntax. PB 7273 - MR062405470   *
  *                      2- New parmlib parameter will allow to  *
  *                       change the half byte sign on DECIMAL   *
  *                       PACKED and DECIMAL ZONED data, and     *
  *                       date/time formats that use DECIMAL     *
  *                       PACKED and DECIMAL ZONED.              *
  *                       PB 7287 - MR0707055324                 *
  *                      3- FastUnload : support of comments:    *
  *                       "*" in column 1 of Unload statement.   *
  *                       PB 7460 - MR0804057429                 *
  *                      4- Error on COPYDDN CHECK with multiple *
  *                       DDNAME (in case of FIC per partition). *
  *                       PB 7575                                *
  *                      5- When a nullable column is unloaded   *
  *                       into a non nullable field (using       *
  *                       FORMAT USER in HPU syntax or the INTO  *
  *                       clause in CA/Fastunload and BMC/Unload *
  *                       plus syntaxes), the NULL values are    *
  *                       replaced by binary zeroes. They should *
  *                       be replaced by the default value for   *
  *                       the column type. This only occurs when *
  *                       the SELECT is processed by DB2.        *
  *                       PB 7591                                *
  *                      6- When a FLOAT column is converted to  *
  *                       a DECIMAL value, the scale of the      *
  *                       decimal column was ignored. PB 5023    *
  *                      7- Unloading an INLINE FIC that         *
  *                       contains less than 6 pages (from 3 to  *
  *                       5 pages inclusive) with the INLINE or  *
  *                       CHECK option unloads no rows.          *
  *                       PB 7616                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  - An enhancement.
  Additional Items 1- thru 3- are also enhancements.
  4- Function _inzcontrolCheckCopyDdnDsname() was changed to
   correctly process the CHECK parameter in case of partition
   parallelism, and to reject usage of the CHECK parameter when
   generic ddnames are used.
  5- Function inzgcxtrGenerate() was changed to process correctly
   the conversion of null values into non null values.
  6- Module  udbcrfel was fixed to use the SCALE of the target
   decimal field.
  7- Module  udbutopt was changed to unload correctly inline fic.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  ž**** PE05/12/07 FIX IN ERROR. SEE APAR PK15319  FOR DESCRIPTION
  

APAR Information

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

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

  UK09166 UK09167

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK09166

     UP05/11/22 P F511

• R220 PSY UK09167

     UP05/11/22 P F511

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.