PM11310: INZU031E DUE TO DUPLICATE FORMAT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU issues message INZU031E DUPLICATE KEYWORD OR STATEMENT xxxxx
  but the process continues and ends with a return code less than
  8.  The correct and expected behavior is to stop HPU processing
  and issue RC8.  HPU takes only the first keyword or statement
  specification into account except when FORMAT USER is followed
  by another FORMAT option.  In this case the FORMAT USER is
  applied first and then the second FORMAT is applied to the
  output of the FORMAT USER.
  PB10573
  
  PROBLEM DESCRIPTION REWORDED:
  
     When an HPU statement contains an unexpected duplicate
     keyword, it issues message INZU031E DUPLICATE KEYWORD OR
     STATEMENT xxxxx but the process continues instead of
     stopping with RC8.
     In such a case HPU processes the incorrect statement
     as follows:
     - if FORMAT USER and another FORMAT statement are involved
       in the duplication, HPU applies the second format to the
       output of the USER format
     - in any other duplication situation,
       HPU ignores the second keyword
  
     So, HPU can not support the syntax with
       "FORMAT USER ... FORMAT DELIMITED".
     The fix for PM11310 makes HPU reject any unsupported
     keyword/statement duplication.
  
  --------------- BASIC HOW TO HANDLE AFTER PM11310 -------------
  
    After applying the PTF, some HPU statements that were
    formerly processed successfully may end with
    RC 8 and msgINZU031E because the SYSIN included a duplicated
    keyword or statement.
    - If the duplicated keyword or statement is not the
      FORMAT option, keep only the first occurrence of the
      keyword or statement.
    - If the FORMAT option is duplicated but the FORMAT USER
      is not specified first,
      then keep only the first FORMAT specification.
    - If the FORMAT option is duplicated and the first ocurrence
      is FORMAT USER, the unloaded data format is changed.
      Usually, it is possible to recover the previous behavior
      by replacing the FORMAT USER specification by an
      INTO clause performing the same data type conversion.
  ---------------------------------------------------------------
  .
  FOR EXAMPLE.
  Given the following invalid UNLOAD statements:
  
    UNLOAD                      TABLESPACE
      SELECT NAME,CREATOR,TYPE,DBNAME,TSNAME
      FROM SYSIBM.SYSTABLES
      WITH UR
      OUTDDN SYSRC
      LOADDDN SYSCNTL
      FORMAT USER ( COL  1 TYPE CHAR(20) LENGTH MAX JUST LEFT
                  , COL  2 TYPE CHAR(20) LENGTH MAX JUST LEFT
                  , COL  3 TYPE CHAR(05) LENGTH MAX JUST LEFT
                  , COL  4 TYPE CHAR(20) LENGTH MAX JUST LEFT
                  , COL  5 TYPE CHAR(20) LENGTH MAX JUST LEFT
                  )
      FORMAT DELIMITED SEP '|'
  
  They could be changed to the following:
  
    UNLOAD                      TABLESPACE
      SELECT NAME,CREATOR,TYPE,DBNAME,TSNAME
      INTO          COL_1 CHAR(20) LENGTH MAX JUST LEFT
                  , COL_2 CHAR(20) LENGTH MAX JUST LEFT
                  , COL_3 CHAR(05) LENGTH MAX JUST LEFT
                  , COL_4 CHAR(20) LENGTH MAX JUST LEFT
                  , COL_5 CHAR(20) LENGTH MAX JUST LEFT
      FROM SYSIBM.SYSTABLES
      WITH UR
      OUTDDN SYSRC
      FORMAT DELIMITED SEP '|'
      LOADDDN SYSCNTL
  
  PB10573
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 HPU may end normally (i.e. with     *
  *                      return code less than 8) despite the    *
  *                      forbidden duplication of a keyword in   *
  *                      SYSIN. The correct expected behavior    *
  *                      is to stop processing and issue a RC8.  *
  *                      Details: HPU issues the message         *
  *                      INZU031E DUPLICATE KEYWORD OR STATEMENT *
  *                      xxxxx but the process continues and     *
  *                      ends with a return code less than 8.    *
  *                      HPU takes only the first keyword or     *
  *                      statement specification into account    *
  *                      except for the following situation.     *
  *                      When FORMAT USER is followed by         *
  *                      another FORMAT option, the format USER  *
  *                      is applied first and then, the second   *
  *                      FORMAT is applied to the output of the  *
  *                      FORMAT USER.                            *
  *                      PB 10573                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzhyacc, inzpyacc, inzfyacc and inztask modules were fixed so
  that the local return code 8 is propragated to the caller.
  

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:

  UK59919 UK59920

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK59919

     UP10/08/31 P F008

• R320 PSY UK59920

     UP10/08/31 P F008

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.