PI53345: KEYWORD LOAD IS MISSING IN THE CNC FILE GENERATED BY ADB27AC WHE N RELOADING DATA FROM UNLOAD USING HPU 4.3.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RUN WSL FAILS WITH RC=8 DUE TO MISSING KEYWORD 'LOAD':
  
  TEMPLATE U0000001
   DSN('hlq.ssid.>name<.ULD.T0002')
   DISP(OLD,KEEP,KEEP)
   ...
   DATA INDDN U0000001
   >MISSING KEYWORD LOAD<
  ...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use High Performance            *
  *                 Unload (HPU), Version 4.3 to perform         *
  *                 an UNLOAD when running the Work              *
  *                 Statement List (WSL).                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using HPU, Version                 *
  *                      4.3 to perform an UNLOAD when           *
  *                      running the WSL, the convert            *
  *                      program ADB27AC generated               *
  *                      an invalid LOAD control statement       *
  *                      with missing keywords like              *
  *                      'LOAD' and 'LOG' in the CNC             *
  *                      file which leads to a Return            *
  *                      Code 8 / RC=8 error:                    *
  *                                                              *
  *                      DSNU005I...DSNUGPRS -                   *
  *                      TEMPLATE U0000001                       *
  *                      DSNU005I...DSNUGPRS -                   *
  *                      DSN('>unload template name<')           *
  *                      DSNU005I...DSNUGPRS -                   *
  *                      DISP(OLD,KEEP,KEEP)                     *
  *                      DSNU005I...DSNUGPRS -                   *
  *                      DATA INDDN U0000001                     *
  *                      DSNU049I...DSNUGPRS -                   *
  *                      INVALID OPERAND 'DATA'                  *
  *                      FOR KEYWORD 'TEMPLATE'                  *
  *                      ...                                     *
  *                      DSNU012I...DSNUGBAC -                   *
  *                      UTILITY EXECUTION                       *
  *                      TERMINATED, HIGHEST                     *
  *                      RETURN CODE=8                           *
  *                                                              *
  *                      For example:                            *
  *                      TEMPLATE U0000001                       *
  *                        DSN('hlq.ssid.>name<.ULD.T0002')      *
  *                        DISP(OLD,KEEP,KEEP)                   *
  *                        ...                                   *
  *                      DATA INDDN U0000001                     *
  *                      ==>>>>Missing keyword LOAD              *
  *                      ...                                     *
  *                      NO  ==>>>>Missing keyword LOG.          *
  *                      ENFORCE NO                              *
  *                      EBCDIC CCSID(0037)                      *
  *                                                              *
  *                      should be:                              *
  *                                                              *
  *                      TEMPLATE U0000001                       *
  *                        DSN('hlq.ssid.>name<.ULD.T0002')      *
  *                        DISP(OLD,KEEP,KEEP)                   *
  *                        ...                                   *
  *                      LOAD DATA INDDN U0000001                *
  *                      ...                                     *
  *                      LOG NO                                  *
  *                      ENFORCE NO                              *
  *                      EBCDIC CCSID(0037)                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using HPU, Version 4.3 to perform an UNLOAD when
  running the WSL, the convert program ADB27AC generated
  an invalid LOAD control statement with missing keywords like
  'LOAD' in the CNC file which leads to a Return Code 8 / RC=8
  error.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI34032 UI34033 UI34034

Modules/Macros

•    ADB2LCC  ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI34032

     UP15/12/30 P F512

• RB10 PSY UI34033

     UP15/12/30 P F512

• RB20 PSY UI34034

     UP15/12/30 P F512

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.