PI79297: VARIOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR includes the following fixes:
  1. The following errors occur on a load when using a CCSID that
    uses a double byte character for double quotes:
    AQT10301I  An error occurred in the SYSPROC.DSNUTILU service
    of your database management system (DBMS).
      HLOU5724E The ACCEL_LOAD_TABLES stored procedure has failed.
  2. The following error occurs when the load statement is very
    large, for example, when many partitions are loaded in the
    same step:
      HLOP9901E Input buffer size is too small.
  .
  3. When using the backup function to copy a AOT table, column
     JOBTYPE in HLOUCOPY incorrectly contains a value of 'L'
     instead of 'B'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
  *                 Loader for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR includes the following fixes: *
  *                      1. The following errors occur on a load *
  *                       when using a CCSID that uses a double  *
  *                       byte character for double quotes:      *
  *                        AQT10301I  An error occurred in the   *
  *                         SYSPROC.DSNUTILU service of your     *
  *                         database management system (DBMS).   *
  *                        HLOU5724E The ACCEL_LOAD_TABLES       *
  *                         stored procedure has failed.         *
  *                      2. The following error occurs when the  *
  *                       load statement is very large, for      *
  *                       example, when many partitions are      *
  *                       loaded in the same step:               *
  *                          HLOP9901E Input buffer size is too  *
  *                           small.                             *
  *                      3. When using the backup function to    *
  *                       copy a AOT table, column JOBTYPE in    *
  *                       HLOUCOPY incorrectly contains a value  *
  *                       of 'L' instead of 'B'.                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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

•    HLOGDYNA
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI47120

     UP17/05/19 P F705

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.