PH20106: VARIOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following issues are resolved with this APAR:
  1. The BIGINT column is being populated with zeroes and not the
  value from the external, delimited file. This issue affects
  loader job using IDAA_ONLY or IDAA_DUAL.
  2. On a LOAD REPLACE job with HLODUMMY DD and if SYSIN does not
  include IDAA_ONLY or IDAA_DUAL statements, the job will fail
  with message
  " 'REPLACE' REQUIRES KEYWORD 'PART' ".
  3. On a RESTART of LOAD utility if the IBM Db2 Analytics
  Accelerator Loader job is run with DB2_SORT NO, the load job may
  run with DB2_SORT flag set as YES instead of using the 'DB2_SORT
  NO' from the job.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Issue on a BIGINT column.            *
  *                      2. LOAD REPLACE with a HLODUMMY DD and  *
  *                      SYSIN does not include IDAA_ONLY or     *
  *                      IDAA_DUAL may fail                      *
  *                      3. On a RESTART of Load utility job     *
  *                      with DB2_SORT NO may change this        *
  *                      flag to a YES                           *
  ****************************************************************
  1. The BIGINT column is being populated with zeroes and not the
  value from the external, delimited file. This issue affects
  loader job using IDAA_ONLY or IDAA_DUAL.
  2. On a LOAD REPLACE job with HLODUMMY DD and if SYSIN does not
  include IDAA_ONLY or IDAA_DUAL statements, the job will fail
  with message
  " 'REPLACE' REQUIRES KEYWORD 'PART' ".
  3. On a RESTART of LOAD utility if the IBM Db2 Analytics
  Accelerator Loader job is run with DB2_SORT NO, the load
  job may run with DB2_SORT flag set as YES instead of using
  the 'DB2_SORT NO' from the job.
  

Problem conclusion

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:

  UI68049

Modules/Macros

• HLOPLOAD HLOPSTMT HLOSINIT HLOUCE15 HLOUMAIN
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI68049

     UP20/03/05 P F003

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.