PK51131: MSGIEC147I 613-44,IFG0196Q DURING UNLOAD WHEN PARALLELISM IS ACTIVE. PB 8971

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MSGIEC147I 613-44,IFG0196Q During Unload when:
  - unload of a partitioned tablespace (partition number = N)
  - output data set (OUTDDN) is allocated by using the TEMPLATE
    feature
  - PARALLELISM regarding LDS is set to a value lower than the
    partition number (e.g. PARALLELISM p specified in SYSIN where
    1 <= p < N)
  - only one output data set is requested the name_expression
    provided as operand of the DSN keyword contains neither &PART.
  Symptoms may also include rows missing from the output file.
  

Local fix

• Two circumventions are possible:
  1) Increase PARALLELISM
     Add PARALLELISM p with p greater than or equal to the
     partition number of the concerned tablespace. This must be
     balanced against increased memory use with higher degree of
     PARALLELSIM.
  2) Use several output data sets
     In the TEMPLATE DSN specification, modify the name_expression
     operand to use &PART. or &PA. variable. This must be
     balanced the need to make JCL changes in support of the
     added output DS's.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For 220 and 310:                        *
  *                      1. HPU 310: FORMAT DELIMITED : DELIM    *
  *                      not processed when INTO or REFORMAT is  *
  *                      also specified. Occurs also in HPU      *
  *                      220 and 310 for FORMAT CSV of Unload    *
  *                      plus syntax. In this case ENCLOSEDBY    *
  *                      is  not processed when INTO is also     *
  *                      specified. PB 8911                      *
  *                      2. An abend S0C4 may occur when         *
  *                      accessing a DB2 V8 or DB2 V9 table      *
  *                      with a column that has a fieldproc      *
  *                      when SQLACCESS is set to YES. PB 8983   *
  *                                                              *
  *                      For 220:                                *
  *                      3. HPU 220 only: In Fast Unload or      *
  *                      Unload Plus syntax, when a numeric      *
  *                      column is converted to INTEGER EXTERNAL *
  *                      with an INTO clause, a non initialized  *
  *                      area is used and this can lead to       *
  *                      various result, among others abend      *
  *                      S0C1, abend S0C7 or data incorrectly    *
  *                      sorted if a SORT is issued on the       *
  *                      column. PB 8953                         *
  *                      4. HPU 220 only. Several fixes have     *
  *                      been made for the FLOAT data when       *
  *                      converting to displayable format. The   *
  *                      length is the output data is now always *
  *                      23 bytes. This applies to:              *
  *                      - HPU syntax with FORMAT DELIMITED, or  *
  *                      Fast Unload syntax with format          *
  *                      COMMA-DELIMITED, ot Unload plus syntax  *
  *                      with FORMAT CSV. The output lenght of   *
  *                      a FLOAT column is now 23 bytes instead  *
  *                      of 21 bytes.                            *
  *                      - FastUnload syntax or Unload plus      *
  *                      syntax with FORMAT EXTERNAL or INTO     *
  *                      with FLOAT EXTERNAL. The output lenght  *
  *                      of a FLOAT column is now 23 bytes       *
  *                      instead of 21 or 24 bytes. PB 8983      *
  *                                                              *
  *                      For 310:                                *
  *                      5. HPU 310 only: Several                *
  *                      inconsistencies when using FORMAT       *
  *                      DELIMITED together with an INTO or      *
  *                      REFORMAT clause. The output data        *
  *                      should respect the specification of     *
  *                      FORMAT DELIMITED otherwise it will not  *
  *                      be usable.                              *
  *                      - When converting to a numeric or       *
  *                      Date/Time/Timestamp datatype without    *
  *                      specifying EXTERNAL, output data is in  *
  *                      internal format (non displayable)       *
  *                      while it should be in displayable       *
  *                      format, as defined by FORMAT DELIMITED. *
  *                      - When converting to a VARCHAR or       *
  *                      VARGRAPHIC data type, length bytes are  *
  *                      by default incorrectly added before     *
  *                      the char or graphic data.               *
  *                      - When unloading a date/time column,    *
  *                      the value of DTDELIM parmlib variable   *
  *                      should be used. PB 8920                 *
  *                      6. HPU 310 only: When SORT EXTERNAL is  *
  *                      used and the name of one of the         *
  *                      columns in the ORDER BY is an SQL       *
  *                      reserved keyword (for example ORDER),   *
  *                      no SORT is done. PB 8948                *
  *                      7. HPU 310 only: Missing data in the    *
  *                      output file in the following case: The  *
  *                      unloaded tablespace is partitioned, a   *
  *                      single output file for all partitions   *
  *                      is allocated using a TEMPLATE without   *
  *                      specifying the &PART variable, and      *
  *                      the parallelism degree used to unload   *
  *                      the tablespace is strictly lower than   *
  *                      the total number of partitions to       *
  *                      unload. PB 8971                         *
  *                      8. HPU 310 only: When warning message   *
  *                      INZU511W is issued, it should be        *
  *                      accompagned by a RC=4. In some case,    *
  *                      the return code issued was 0 instead    *
  *                      of 4. PB 8977                           *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inzctrlp was changed to process correctly the string
  delimiter when INTO is used.
  2. Module odb2x2 was changed to process correctly this case.
  3. Module inzcol was changed to use the correct length for
  INTEGER EXTERNAL.
  4. Module udbcrfel was changed to give consistent result when
  converting FLOAT data to displayable format.
  5. Module udbcrfel was changed to give consistent result when
  converting FLOAT data to displayable format.
  6. Module inzoyacc was changed to process correctly the column
  names that correspond to an SQL reserved keyword.
  7. Module inzrun was changed to open the ddname associated with
  the template at the global level when the same file is used for
  several partitions.
  8. Module inzpab was changed to issue a RC=4 when message
  INZU511W is issued.
  

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:

  UK29225 UK29226

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK29225

     UP07/09/20 P F709

• R310 PSY UK29226

     UP07/09/20 P F709

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.