PK11943: HPU NOT RECOGNIZING UNLOADPLUS RECORD FIELD SYNTAX AS PART OF THE UNLOADPLUS SELECT BLOCK.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Attempting to execute a HPU job utilizing UnloadPlus syntax.
  According to Appendix C HPU should recognize the UnloadPlus
  syntax as part of the UnloadPlus select block. PB 7502
  ADDITIONAL SYMPTOMS:
  1) When a GRAPHIC columns is specified in argument of
  functions LTRIM, RTRIM, and STRIP, the length of the
     result is truncated.
     DELIMITEDGRAPHEXT(NO) default set. PB 7487
  2) ABEND0C4 during HPU batch UNLOAD may occur when running
     DB2 V8 and a SORT call is triggered by the SELECT, as by
     ORDER CLUSTER or ORDER BY. PB 5707
  3) INCORRECT OUTPUT of a UNICODE table unloaded by HPU
     and reloaded using HPU generated LOAD statement. HPU
     built the LOAD, but did not include the MIXED keyword
     for the UNICODE table. PB 7498
  
  
  
  4) MSGINZU021E UNSUPPORTED CONVERSION DATE TO CHAR
     INZU038E UNSUPPORTED TYPE CONVERSION FOR COLUMN 'n'
     when using FORMAT USER and TYPE CHAR(10).
     PB 7516
  5) New parmlib parameter to force usage of partition parallelism
     when unloading in a single output file. To satisfy Marketing
     Requirement MR051705548. PB 7225
  6) All rows may not be unloaded on HPU Batch UNLOAD when ALL
     of the following are true:
    - The UNLOAD statement contains several SELECT statements
      against the same TableSpace.
    - Parallelism is requested, either via the PARALLELISM
      keyword specified in the UNLOAD SYSIN or some SELECT
      statements request each partition be unloaded to its
      own output data set.
    - At least one of the SELECT statements requires the data
      of several partitions be unloaded into a single output
      dataset. PB 6932
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Attempting to execute a HPU job         *
  *                      utilizing UnloadPlus syntax. According  *
  *                      to Appendix C HPU should recognize the  *
  *                      UnloadPlus syntax as part of the        *
  *                      UnloadPlus select block. PB 7502        *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1. When a GRAPHIC columns is specified  *
  *                       in argument of functions LTRIM,        *
  *                       RTRIM, and STRIP, the length of the    *
  *                       result is truncated. PB 7487           *
  *                      2. ABEND0C4 during HPU batch UNLOAD     *
  *                       may occur when running DB2 V8 and a    *
  *                       SORT call is triggered by the SELECT,  *
  *                       as by ORDER CLUSTER or ORDER BY.       *
  *                       PB 5707                                *
  *                      3. INCORRECT OUTPUT of a UNICODE table  *
  *                       unloaded by HPU and reloaded using     *
  *                       HPU generated LOAD statement. HPU      *
  *                       built the LOAD, but did not include    *
  *                       the MIXED keyword for the UNICODE      *
  *                       table. PB 7498                         *
  *                      4. MSGINZU021E UNSUPPORTED CONVERSION   *
  *                       DATE TO CHAR INZU038E UNSUPPORTED      *
  *                       TYPE CONVERSION FOR COLUMN 'n' when    *
  *                       using FORMAT USER and TYPE CHAR(10).   *
  *                       PB 7516                                *
  *                      5. New parmlib parameter to force       *
  *                       usage of partition parallelism when    *
  *                       unloading in a single output file. To  *
  *                       satisfy Marketing Requirement          *
  *                       MR051705548. PB 7225                   *
  *                      6. All rows may not be unloaded on HPU  *
  *                       Batch UNLOAD when ALL of the           *
  *                       following are true:                    *
  *                       - The UNLOAD statement contains        *
  *                       several SELECT statements against      *
  *                       the same TableSpace.                   *
  *                       - Parallelism is requested, either     *
  *                       via the PARALLELISM keyword specified  *
  *                       in the UNLOAD SYSIN or some SELECT     *
  *                       statements request each partition be   *
  *                       unloaded to its own output data set.   *
  *                       - At least one of the SELECT           *
  *                       statements requires the data of        *
  *                       several partitions be unloaded into a  *
  *                       single output dataset. PB 6932         *
  *                      7. Potential loop when unloading a      *
  *                       table that has just been               *
  *                       dropped/created and when the           *
  *                       tablespace name is not specified in    *
  *                       the UNLOAD command. Problem only       *
  *                       occurs when using SQLACCES=NO in       *
  *                       parmlib, and when QUIESCECAT NO is     *
  *                       used.                                  *
  *                       HPU may loop issuing                   *
  *                       allocation/deallocation messages on    *
  *                       the DB2 catalog datasets:              *
  *                       IEF237I 270A ALLOCATED TO INZIX01      *
  *                       IEF237I 270A ALLOCATED TO INZTS01      *
  *                       IGD104I DSNV710.DSNDBD.DSNDB06....     *
  *                      ...DSNDSX01.I0001.A001   RETAINED,      *
  *                      DDNAME=INZIX01                          *
  *                       IGD104I DSNV710.DSNDBD.DSNDB06....     *
  *                      ...SYSDBASE.I0001.A001   RETAINED,      *
  *                      DDNAME=INZTS01                          *
  *                       PB6271                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Modules  inzpyacc, inzrload, inzctrlp, inztoken were changed
  to recognize and process correctly this option.
  Addition Fixes:
  1. Module Inznode was changed to set the output data type to
   VARGRAPHIC instead of VARCHAR for the RTRIM,  LTRIM and STRIP
   functions used on GRAPHIC or VARGRAPHIC data.
  2. Module INZUTL1 was changed to call DSNUTLB using JSTCB=YES
   on the ATTACH macro.
  3. Module Inzrload was changed to generate correct load options
   for UNICODE data.
  4. Modules inzctrlp and inzpyacc were changed to support
   conversion between date/time data and CHAR in the INTO clause.
  5. Requirement MR051705548.
  6. Module Inzbab was changed to determine when parallelism is
   used and when multiple unload task will write into the same
   file. In this case the output file is opened at the global
   level.
  7. Module inzctrl was changed to automatically switch to
   SQLACCES YES if the direct acces to the DB2 catalog does not
   return the correct table description.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK08288 UK08289

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK08288

     UP05/11/02 P F511

• R220 PSY UK08289

     UP05/11/02 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.