PI85378: INCOMPLETE DATASET NAME IN THE GENERATED LOAD CONTROL CARDS WHENTEMPLATE AND GDG ARE USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incomplete dataset name in the generated load control cards when
  TEMPLATE and GDG are used.
  
  (HPU 4.3 and HPU 5.1) The LOAD statement generated by DB2 HPU
  specifies a TEMPLATE specifying GDG name as the argument of the
  DSN option while the GDS name is expected. This occurs whenever
  the unload specifies a TEMPLATE with a DSN option specifying a
  GDG request the LOAD statement be generated (LOADDDN option) and
  the LOADINDDN YES is specified (LOADINDDN YES option) or applies
  (LOADINDDN(YES) specified by VUU030/ULOPTNS).
  
  PB50039
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD statement generated by DB2     *
  *                      HPU specifies a TEMPLATE specifying     *
  *                      GDG name as the argument of the DSN     *
  *                      option while the GDS name is expected.  *
  *                      This occurs whenever the unload         *
  *                      specifies a TEMPLATE with a DSN option  *
  *                      specifying a GDG request the LOAD       *
  *                      statement be generated (LOADDDN option) *
  *                      and the LOADINDDN YES is specified      *
  *                      (LOADINDDN YES option) or applies       *
  *                      (LOADINDDN(YES) specified by            *
  *                      VUU030/ULOPTNS).                        *
  *                      For example, the following unload :     *
  *                      TEMPLATE                                *
  *                      UNLDDSN DSN ('ME.TEMP.&SSID..&DB..&TS.  *
  *                      (+1)')                                  *
  *                      UNIT WORK DISP (NEW,CATLG,CATLG)        *
  *                      SPACE TRK                               *
  *                      MODELDCB ME.MODEL                       *
  *                      GLOBAL OPTIONS                          *
  *                      LOADINDDN YES                           *
  *                      ;                                       *
  *                      UNLOAD                                  *
  *                      TABLESPACE                              *
  *                      SELECT * FROM SYSIBM.SYSCOPY            *
  *                      OUTDDN UNLDDSN                          *
  *                      LOADDDN LOADCARD                        *
  *                      produces a LOAD statement starting      *
  *                      with                                    *
  *                      TEMPLATE U0000001                       *
  *                      DSN('ME.TEMP.DZBA.DSNDB06.SYSTSCPY')    *
  *                      DISP(OLD,KEEP,KEEP)                     *
  *                      LOAD DATA INDDN U0000001                *
  *                      instead of the expected                 *
  *                      TEMPLATE U0000001                       *
  *                      DSN('ME.TEMP.DZBA.DSNDB06.SYSTSCPY.G00  *
  *                      02V00')                                 *
  *                      DISP(OLD,KEEP,KEEP)                     *
  *                      LOAD DATA INDDN U0000001                *
  *                      pb50039                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The otmplate module was changed.
  

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:

  PI86715 UI50433

Modules/Macros

•    INZ$$PRM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI50433

     UP17/09/27 P F709

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.