PK31494: LOAD STATEMENTS GENERATED BY HPU UNLOAD ARE INCORRECT WHEN USINGOEM FASTUNLOAD SYNTAX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using FASTUNLOAD syntax the LOAD statements generated by
  an HPU UNLOAD can be incorrect. For example, a constant 'C'
  should generate a VARCHAR(1) while constant C'C' should generate
  a CHAR(1). The problem is that 'C' generates CHAR(1). PB 8415
  Additional Symptoms:
  1. MsgINZU168E for column defined DEC(6,6) with default 0
     PB 8439
  2. Messages IKJnnnn don't appear in case of dynamic allocation
     error causing abend U1004.
     PB 8293
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - When using FASTUNLOAD syntax the LOAD *
  *                      statements generated by an HPU UNLOAD   *
  *                      can be incorrect. For example, a        *
  *                      constant 'C' should generate a          *
  *                      VARCHAR(1) while constant C'C' should   *
  *                      generate a CHAR(1). The problem is that *
  *                      'C' generates CHAR(1). PB 8415          *
  *                      Additional Symptoms:                    *
  *                      1. MsgINZU168E for column defined       *
  *                      DEC(6,6) with default 0. PB 8439        *
  *                      2. Messages IKJnnnn don't appear in     *
  *                      case of dynamic allocation error        *
  *                      causing abend U1004. PB 8293            *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  - Module inzctrl was changed to generate a correct VARCHAR
  description on the LOAD sysin in the above descibed case.
  1. Module infcnv00 was changed to accept a default value of 0
  for a decimal(n,n) column.
  2. Not a bug.
  

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:

  UK18907 UK18908

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK18907

     UP06/10/26 P F610

• R220 PSY UK18908

     UP06/10/26 P F610

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.