PM13753: S0C4 WITH LISTDEF AND INCORRECT LOAD STMT SPECIFYING DELIMTED FORMAT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. The load statement generated by HPU is incorrect where the
  DELIMITED format is requested and:
     - If the decimal separator specified in the FORMAT DELIMITED
       specification is not identical to the sub-system setting,
       the LOAD DECPTD specification is incorrect resulting in
       records containing decimal or float fields to be discarded.
     - If the table space containing the table to be unloaded is
       partitioned and the DB2 HPU settings specify
       ULOPTNS(LOADINDDN(YES)), the FORMAT option is missing thus
       leading the LOAD to stop reporting the command is invalid.
       PB10648
  2.  An S0C4 ABEND may occur where the unload statement refers
      to a LISTDEF name (i.e. FROM LIST(listdef_name) is coded)
      to unallocated data sets. In such a case, DB2 HPU should end
      with return code 8 and should issue error message INZC003
      PB10649
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Load.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. The load statement generated by HPU  *
  *                      HPU is incorrect where the              *
  *                      DELIMITED FORMAT is                     *
  *                      requested and additional conditions     *
  *                      are fulfilled. The errors and the       *
  *                      related exact situations where they     *
  *                      occur are as described hereafter. If    *
  *                      the decimal separator specified in the  *
  *                      FORMAT DELIMITED specification is not   *
  *                      identical to the sub-system setting,    *
  *                      the LOAD DECPTD specification is        *
  *                      incorrect thus leading to records       *
  *                      containing decimal or float fields to   *
  *                      be discarded.                           *
  *                      - If the table space containing the     *
  *                      table to be unloaded is partitioned     *
  *                      and the DB2 HPU settings specify        *
  *                      ULOPTNS(LOADINDDN(YES)), the FORMAT     *
  *                      option is missing thus leading the      *
  *                      LOAD to stop reporting the command is   *
  *                      invalid.                                *
  *                      PM 10648                                *
  *                      2. An S0C4 ABEND may occur where the    *
  *                      unload statement refers to a LISTDEF    *
  *                      name (i.e. FROM LIST(listdef_name) is   *
  *                      coded) and to unallocated data sets.    *
  *                      In such a case, DB2 HPU should end with *
  *                      return code 8 and should issue the      *
  *                      error message INZC003.                  *
  *                      PM 10649                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. The inzrload module was changed to correctly handle the
  situation.
  2. The inzrload module was changed to correctly handle the
  situation.
  

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

• R310 PSY UK58095

     UP10/06/24 P F006

• R320 PSY UK58096

     UP10/06/24 P F006

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.