PK20426: HPU UNLOAD OUTPUT MAY BE MISSING SOME ROWS AFTER A SELECT CODED TO MATCH ON MULTIPLE KEYS MISSING ROWS HAVE KEYS END IN X'40'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• On a DB2 HPU Unload with a SELECT coded to match
  on multiple keys some rows may be missing from the
  output of the unload if the key ends with '40'. HPU
  mistakes the '40' for a hex blank. PB 7881.
  
  
  
  ADDITIONAL SYMPTOMS:
  1) HPU UNLOAD of a partitioned object using any FORMAT
     and where the OUTDDN DD card does not specify a RECFM or
     other DCB info can get different RECFMs. If Parallelism
     is set to 1 RECFM will be FB and if Parallelism is greater
     than 1 it will be VB. This only occurs when the object does
     NOT have any variable length columns. PB 7914
  2) A new sample will be added to the HPU sample library
     that contains an exec to allow HPU to be started
     interactively ( in ISPF ) without having to luanch
     it from the ADMIN tool or from Launchpad.
     The EXEC:
  /* REXX */
  ispexec 'LIBDEF ISPLLIB DATASET ID(''HINZ210.SINZLLIB'') STACK'
  ispexec 'SELECT CMD(EX ''HINZ210.SINZCLST(INZHPU)'' ''D LP'' )'
  .
      PB 7912
  3) Using FASTUNLOAD syntax with the " TRIM " option under
     DB2 HPU the option does not properly suppress blanks.
     PB 7916
  4) SQLCODE -330 if APPENSCH=UNICODE in DSNHDECP. PB 7913
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: On a DB2 HPU Unload with a SELECT coded *
  *                      to match on multiple keys some rows     *
  *                      may be missing from the output of the   *
  *                      unload if the key ends with '40'. HPU   *
  *                      mistakes the '40' for a hex blank.      *
  *                      PB 7881.                                *
  *                      1. HPU UNLOAD of a partitioned object   *
  *                      using any FORMAT and where the OUTDDN   *
  *                      DD card does not specify a RECFM or     *
  *                      other DCB info can get different        *
  *                      RECFMs. If Parallelism is set to 1      *
  *                      RECFM will be FB and if Parallelism is  *
  *                      greater than 1 it will be VB. This      *
  *                      only occurs when the object does        *
  *                      NOT have any variable length columns.   *
  *                      PB 7914.                                *
  *                      2. A new sample will be added to the    *
  *                      HPU sample library that contains an     *
  *                      exec to allow HPU to be started         *
  *                      interactively ( in ISPF ) without       *
  *                      having to launch it from the ADMIN      *
  *                      tool or from Launchpad.  The EXEC:      *
  *                      (* REXX *)                              *
  *                      ispexec 'LIBDEF ISPLLIB DATASET         *
  *                       ID(''HINZ210.SINZLLIB'') STACK'        *
  *                      ispexec 'SELECT CMD(EX                  *
  *                       ''HINZ210.SINZCLST(INZHPU)''           *
  *                       ''D LP'' )'                            *
  *                      PB 7912.                                *
  *                      3.  Using FASTUNLOAD syntax with the    *
  *                      " TRIM " option under DB2 HPU the       *
  *                      option does not properly suppress       *
  *                      blanks.                                 *
  *                      PB 7916.                                *
  *                      4. SQLCODE -330 if APPENSCH=UNICODE in  *
  *                      DSNHDECP.                               *
  *                      PB 7913.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module Inznode, function nznodeOptimizeIn() was fixed. In case
  of DATE/TIME/TIMESTAMPS, trailing blanks (x'40') are not removed
  from the values. The trailing blanks are only removed from the
  CHAR and GRAPHIC values.
  1. Modules INZBAB and INZRUN were fixed to follow the following
  rules:
  - If a FORMAT VARIABLE is requested, the default RECFM of the
   output file is always VB (as described in the manual).
  - When a single output file is used for several select
   statements that would all independantly require a RECFM=FB,
   the RECFM is set to VB, unless all LRECL corresponding to all
   SELECT statements are identical, in which case, the RECFM is
   FB.
  2. Module inzhpusk was changed to allow execution of HPU Ispf
  application outside of DB2 Admin.
  3. Module Inzctrlf was changed to process the TRIM option
  (FastUnload Syntax) in all formats. In addition, in HPU syntax,
  the LENGTH keyword is now accepted for FORMAT DSNTIAUL,
  DELIMITED, and VARIABLE, when specified in the OPTIONS block at
  the SELECT level.
  4. Module Inzsbind was changed to force the parameter
  ENCODING(EBCIC) in the BIND command of the HPU application plan.
  

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:

  UK13178 UK13179

Modules/Macros

•    INZHPUSK INZSBIND INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK13178

     UP06/04/05 P F604

• R220 PSY UK13179

     UP06/04/05 P F604

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.