PK64556: MESSAGE DSNU1141I DURING LOAD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SYSPUNCH generated by an HPU UNLOAD used as input to a DB2 LOAD
  gets message DSNU1141I.      PB 9274
  ADDITIONAL SYMPTOMS:
  1. HPU is not able to create a load card compatible with the
     IBM Load utility for tables having IDENTITY columns.
  The LOADDDN is incorrect when the unloaded table contains either
  a ROWID or a columns defined AS IDENTITYwith GENERATED ALWAYS.
  HPU doesn't respect the rules documented in the IBM Utility
  Guide and Reference. A dummy field  should be coded for the
  ROWID or IDENTITY columns, and the IGNOREFIELDS keyword should
  be also generated in the load sysin.
     PB 9276
  2) TABLE name missing in SYSPUNCH file LOAD statement like:
     INTO TABLE "????????.????????"
     when a correlation name is used in the HPU UNLOAD SELECT.
     PB9285
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 HIgh Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are for V220 and V310:    *
  *                      1. With FORMAT DELIMITED, the IBM LOAD  *
  *                      has some limitations that are not       *
  *                      respected by HPU. The LOADDDN           *
  *                      generated by HPU is sometimes not       *
  *                      accepted by the IBM load with a         *
  *                      message DSNU1141I   099 14:55:05.52     *
  *                      DSNURILD - INVALID DELIMITER CHARACTER  *
  *                      ',' (X'6B'). This only occurs when      *
  *                      dealing with MIXED or DBCS data.        *
  *                      PB 9274                                 *
  *                      2. The LOADDDN is incorrect when the    *
  *                      unloaded table contains either a ROWID  *
  *                      or a columns defined AS IDENTITYwith    *
  *                      GENERATED ALWAYS. HPU doesn't respect   *
  *                      the rules documented in the IBM         *
  *                      Utility Guide and Reference. A dummy    *
  *                      field  should be coded for the ROWID    *
  *                      or IDENTITY columns, and the            *
  *                      IGNOREFIELDS keyword should be also     *
  *                      generated in the load sysin. PB 9276    *
  *                      3. When the SELECT contains a single    *
  *                      table name with a correlation name, the *
  *                      following warning message is issued:    *
  *                      INZU211W LOAD STATEMENT WARNING :       *
  *                       UNABLE TO DETERMINE TABLE NAME FOR     *
  *                       SELECT STARTING AT POS(3, 4).          *
  *                       LOAD STATEMENT MUST BE MODIFIED.       *
  *                      and the LOADDDN contains                *
  *                      "????????.????????" instead of the      *
  *                      table name. PB9285                      *
  *                      4. After application of fix for         *
  *                      PK65272, msgINZU018E INVALID PARMLIB    *
  *                      PARAMETER VUU024/UNLZLRC  is issued if  *
  *                      UNLZLRC is missing from the INZUTIL     *
  *                      member (generated by INZT02). Although  *
  *                      this should not happen if INZT02 and    *
  *                      INZT02 are used, this lack was          *
  *                      formerly tolerated as this parameter    *
  *                      is optional. PB 9299                    *
  *                      5. A useless msgINZU195I INFORMATION :  *
  *                      NO ROW UNLOADED. RC FORCED TO 0 is      *
  *                      issued when an error free unload (i.e.  *
  *                      retrun code < 4) produces no output     *
  *                      data (no rows are actually selected)    *
  *                      if UNLZLRC is set to 0. PB 9300         *
  *                                                              *
  *                      The following is for V310:              *
  *                      6. An abend U1003 occurs when           *
  *                      unloading a partitioned tablespace      *
  *                      using partition parallelism and a       *
  *                      separate file per partition, with an    *
  *                      ORDER BY that does a SORT on non        *
  *                      selected columns. PB 9257               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules Inztoken, Inzmain, Inzplib and Inzrload were changed
  to process new parmlib variable VUU054/CTRLLIBM.
  2. Module Inzrload was changed to gnerate a load sysin accepted
  by the IBM load for columns defined AS IDENTITY with GENERATED
  ALWAYS and for ROWID columns.
  3. Module Inzrload and inzhyacc were changed to generate
  correctly the table name when using a correlation name when the
  select is on a single tble.
  4. Module Inzplib was changed to accept missing UNLZLRC
  parameter in INZUTIL member.
  5. Module inzmain was changed to avoid generating message
  INZU195I when it is useless.
  6. Module Inzpab was changed to change the sort settings when
  using a seperate file per partition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ž**** PE08/07/28 PTF IN ERROR. SEE APAR PK66467  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK37362 UK37363

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK37362

     UP08/07/26 P F807

• R310 PSY UK37363

     UP08/07/26 P F807

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.