PI74811: ISSUES WHEN A SYSREC TEMPLATE SPECIFIES A RELATIVE GDG DATASET OR A DATASET ON TAPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a TEMPLATE statement like the one shown below is coded for
  a SYSREC dataset, the Loader ends up loading data from all
  generations of the GDG.  This happens anytime a relative
  generation is specified on the TEMPLATE.  The work around is to
  eliminate the TEMPLATE statement and instead specify the
  relative generation dataset on a DD statement in the loader JCL.
  Sample TEMPLATE statement that results in the processing error:
  TEMPLATE DNXC0SS3 DSN('DB2O.CDMS.RA500001.COPYMSTR.UNLD(+0)')
  DISP(OLD,KEEP,KEEP)
  This APAR also addresses the following issue:
  A load job will fail with dynamic allocation errors when the
  following conditions are met:
  1) The table is non-partitioned
  2) IDAA_ONLY is specified
  3) The SYSREC dataset is on tape
  4) A TEMPLATE statement is used to specify the SYSREC dataset
  5) ACCEL_LOAD_TASKS > 1 (either because it was explicitly set or
  is defaulting to a value in the options file).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
  *                 Loader for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a TEMPLATE statement like the one  *
  *                      shown below is coded for a SYSREC       *
  *                      dataset, the Loader ends up loading     *
  *                      data from all generations of the GDG.   *
  *                      This happens anytime a relative         *
  *                      generation is specified on the          *
  *                      TEMPLATE.  The work around is to        *
  *                      eliminate the TEMPLATE statement and    *
  *                      instead specify the relative            *
  *                      generation dataset on a DD statement    *
  *                      in the loader JCL.                      *
  *                      Sample TEMPLATE statement that results  *
  *                      in the processing error:                *
  *                      TEMPLATE DNXC0SS3 DSN('DB2O.CDMS        *
  *                      .RA500001.COPYMSTR.UNLD(+0)')           *
  *                      DISP(OLD,KEEP,KEEP)                     *
  *                      This APAR also addresses the following  *
  *                      issue:                                  *
  *                      A load job will fail with dynamic       *
  *                      allocation errors when the              *
  *                      following conditions are met:           *
  *                      1. The table is non-partitioned         *
  *                      2. IDAA_ONLY is specified               *
  *                      3. The SYSREC dataset is on tape        *
  *                      4. A TEMPLATE statement is used to      *
  *                      specify the SYSREC dataset              *
  *                      5. ACCEL_LOAD_TASKS > 1 (either         *
  *                      because it was explicitly set or        *
  *                      is defaulting to a value in the         *
  *                      options file).                          *
  ****************************************************************
  * 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:

  UI45762

Modules/Macros

•    HHLO210J HLOADDTB HLOMSGEN HLOPACEL HLOPAOBK
  HLOPCHCK HLOPCOPY HLOPDITB HLOPDOBJ HLOPEXEC HLOPFSPC HLOPHALO
  HLOPIPE  HLOPIPEA HLOPLIST HLOPLOAD HLOPMSGI HLOPOPTS HLOPQUIS
  HLOPREBU HLOPRECO HLOPREOR HLOPRUNS HLOPSTMT HLOPSTPR HLOPTMPL
  HLOPUNLD HLOPUTLM HLOPUTLU HLOPUTLX HLOUGDSN HLOUHAL1 HLOUHTMG
  HLOUMAIN HLOUSORT HLOUSTUB
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI45762

     UP17/03/31 P F703

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.