PI56162: INVALID LOAD STATEMENT IN HPU V4.3 WHEN USING LOADOPT WITH PARTITION OR TABLE LEVEL OPTIONS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The LOAD generated by HPU 4.3 is invalid. When trying to run the
  LOAD it will result in an RC08 with an error message similar to
  the following one " --INVALID OPERAND 'INDDNXXXX' FOR KEYWORD
  'INTO'."
  
  All the options which do not have a specific control set will be
  concatenated without a space within LOADOPT.
  
  For example:
  
  LOADOPT (SORTKEYS 2847480000 LOG NO ENFORCE NO NOCOPYPEND
  , REPLACE INDDN LOCAL FOO, BAR1 BAR2 BAR3)
  
  will generate:
  
  LOAD DATA
  
  SORTKEYS 2847480000 LOG NO ENFORCE NO NOCOPYPEND
  EBCDIC CCSID(0037)
  
  INTO TABLE DSN81010.EMP
  PART (1)
  REPLACE INDDNLOCALFOO
  BAR1BAR2BAR3
  
  PB44196
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 4.3 only : This is a software       *
  *                      regression introduced in version HPU    *
  *                      4.3 and is a side effect of the newly   *
  *                      supported option to reload table        *
  *                      LOADOPT( options_ts, options_part,      *
  *                      options_tb).                            *
  *                      The LOAD generated by HPU 4.3 is        *
  *                      invalid. When trying to run the LOAD    *
  *                      it will result in an RC08 with an       *
  *                      error message similar to the following  *
  *                      one " --INVALID OPERAND 'INDDNXXXX'     *
  *                      FOR KEYWORD 'INTO'."                    *
  *                      All the options which do not have a     *
  *                      specific control set will be            *
  *                      concatenated without a space within     *
  *                      LOADOPT.                                *
  *                      For example:                            *
  *                      LOADOPT (SORTKEYS 2847480000 LOG NO     *
  *                       ENFORCE NO NOCOPYPEND                  *
  *                      , REPLACE INDDN LOCAL FOO, BAR1 BAR2    *
  *                       BAR3)                                  *
  *                      will generate:                          *
  *                      LOAD DATA                               *
  *                      SORTKEYS 2847480000 LOG NO ENFORCE NO   *
  *                       NOCOPYPEND                             *
  *                       EBCDIC CCSID(0037)                     *
  *                      INTO TABLE DSN81010.EMP                 *
  *                       PART (1)                               *
  *                       REPLACE INDDNLOCALFOO                  *
  *                       BAR1BAR2BAR3                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload  moduile was changed.
  

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

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI35746

     UP16/03/05 P F603

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.