PK98118: INTERNAL DEFECT FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Fixes for internal defects
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. When IFERROR is incorrectly used to  *
  *                      convert a character constant into a     *
  *                      valid numeric constant in an INTO       *
  *                      clause or a FORMAT USER, an error       *
  *                      message INZU010I ITEM STARTING AT (0,0) *
  *                      ENDING AT (0,0) is issued. This message *
  *                      is not intended to be issued in this    *
  *                      case.                                   *
  *                      PB 10149                                *
  *                      2. Error message INZU514E ERROR :       *
  *                      'IF_ERROR VALUE' CANNOT BE SPECIFIED    *
  *                      FOR THE COLUMN C12, INCOMPATIBLE DATA   *
  *                      TYPE should contain IFERROR instead of  *
  *                      IF_ERROR.                               *
  *                      PB 10151                                *
  *                      3. CHAR(NULLIF(Col1,col2)) may abend    *
  *                      with S0C4 if Col1 is a DECFLOAT         *
  *                      columns and NULLIF scalar function.     *
  *                      PB 10240                                *
  *                      4. When unloading a VARBINARY column,   *
  *                      the LOADDDN file, if requested, is      *
  *                      incorrect. The columns that are after   *
  *                      the varbinary column have an incorrect  *
  *                      position.                               *
  *                      PB 10261                                *
  *                      5. When unloading from an image copy    *
  *                      with DDLDDN, an error message INZI503E  *
  *                      is issued when some constant values in  *
  *                      the partitioning key definition are     *
  *                      specified as DECIMAL or BIGINT          *
  *                      constants.                              *
  *                      PB 10267                                *
  *                      6. Unload Plus syntax:                  *
  *                      When FORMAT DSNTIAUL is specified in    *
  *                      the sysin, the output data is format    *
  *                      in FORMAT STANDARD instead of FORMAT    *
  *                      DSNTIAUL. The main difference between   *
  *                      FORMAT STANDARD and FORMAT DSNTIAUL is  *
  *                      that the variable length character      *
  *                      strings (VARCHAR or VARGRAPHIC) are     *
  *                      padded to their mawimum length with     *
  *                      binary zeroes in FORMAT DSNTIAUL while  *
  *                      these columns are written on their      *
  *                      actual length in FORMAT STANDARD. In    *
  *                      addition the RECFM of FORMAT DSNTIAUL   *
  *                      is always FB while the RECFM of FORMAT  *
  *                      STANDARD is VB when variable length     *
  *                      columns are selected. The values for    *
  *                      the null indicator are also different.  *
  *                      PB 10268                                *
  *                      7. Parmlib parameter VUM029/DFSIGDCB    *
  *                      is not used when Unload Plus syntax is  *
  *                      used. This APAR enhances the syntax of  *
  *                      parmlib parameter VUM029/DFSIGDCB, and  *
  *                      allows to specify a value for each      *
  *                      syntax.                                 *
  *                      PB 10269                                *
  *                      8. The ISPF interface does not allow    *
  *                      generating a FORMAT EXTERNAL.           *
  *                      PB 10271                                *
  *                      9. Parmlib variables ULPOS and ULNULL   *
  *                      are incorrectly taken into account for  *
  *                      BMC syntax in case of FORMAT DSNTIAUL   *
  *                      and FORMAT EXTERNAL when they are       *
  *                      specified by format.                    *
  *                      Example: ULPOS = D(BEFORE),E(BEFORE)    *
  *                      ULNULL = D(FF00),E(6F00)                *
  *                      They should only be used in case of     *
  *                      HPU syntax, not when using the BMC      *
  *                      syntax.                                 *
  *                      PB 10274                                *
  *                      10. An abend U1132-0B may occur when    *
  *                      the following conditions are all true:  *
  *                      - A SELECT containing a LOB column is   *
  *                       processed natively by HPU              *
  *                      - The page size of the LOB Table Space  *
  *                       is strictly greater than 4Kb.          *
  *                      - DB2 installation parameter DSVCI=YES, *
  *                       so the CI size of the LDS of the LOB   *
  *                       Table Space is identical to the page   *
  *                       size.                                  *
  *                      - One of the LOB in the LOB table       *
  *                       space is greater than 64Kb             *
  *                      PB 10275                                *
  *                      11. When a DECFLOAT is unloaded in      *
  *                      FORMAT EXTERNAL, the LOADDDN file       *
  *                      contains INTEGER EXTERNAL instead of    *
  *                      DEFCLOAT EXTERNAL.                      *
  *                      PB 10279                                *
  *                      12. Support of DECFLOAT data type in    *
  *                      all HPU format. Before this APAR, it    *
  *                      is only supported in FORMAT EXTERNAL    *
  *                      and FORMAT DELIMITED.                   *
  *                      PB 10280                                *
  *                      13. When a DECFLOAT column contains     *
  *                       infinity, -NaN, or  SnaN, the unload   *
  *                      in FORMAT EXTERNAL or FORMAT DELIMITED  *
  *                      unload respectively Infinity, NaN and   *
  *                      SNan (minus sign is missing).           *
  *                      PB 10281                                *
  *                      14. An abend SC03 may occur when        *
  *                      unloading natively a LOB, when the      *
  *                      length of the LOB is an exact multiple  *
  *                      of the LRECL of the output PDS file.    *
  *                      PB 10284                                *
  *                      15. HIPER: When an UNLOAD command       *
  *                      contains some SELECT processed natively *
  *                      and at the same time some SELECT        *
  *                      processed by DB2, the SELECT processed  *
  *                      by DB2 are not processed and the        *
  *                      output files remain empty. The HPU      *
  *                      steps returns no error message and the  *
  *                      return code is equal to 0.              *
  *                      PB 10307                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inznode was changed not to issue the unwanted error
  message.
  2. Module inzmsgs was changed to correct the message.
  3. Module inznode was fixed to avoid internal conversion when
  dealing with DECFLOAT columns and NULLIF scalar function.
  4. Module inzrload was changed to generate the correct position
  in the descibed case.
  5. Module oddlx2y was changed to accept DECIMAL or BIGINT
  constants in the DDLDDN input file for partition definition.
  6. Module inzpyacc, inzctrlh, inzctrlp were changed to process
  correctly the FORMAT DSNTIAUL when using the BMC Unload Plus
  syntax.
  7. Not a bug.
  8. Not a bug.
  9. Module inzctrlp was changed to ignore the setting of ULPOS
  and ULNULL when using the BMC UNLOAD PLUS syntax.
  10. Module udblobr was changed to process correctly the LOB in
  the described case.
  11. Module inzrload was fixed to generate the correct data type
  in the field description for DECFLOAT columns.
  12. Not a bug.
  13. Module udbcvdfl was fixed to generate the correct values
  for DECFLOAT special values in external format.
  14. Module udbspwlf was changed to process correctly the write
  to the output file when the residual length of previous write
  is null.
  15. Modules inzrunh and inztask were changed to fix this error.
  

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:

  UK51516

Modules/Macros

•    INZB101E INZB101I INZHB1E0 INZHB1I0 INZRSAVE
  INZSSEL2 INZUTILK INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK51516

     UP09/11/05 P F911

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.