PM61347: DROP / CREATE WITH HPU FORMAT INTERNAL FAILS RC08 MSGDSNU0498 INVALID OPERAND 'INTERNAL' FOR KEYWORD 'FORMAT' FFA20 PM69923

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS can experience LOAD
  failure when using HPU UNLOAD with FORMAT INTERNAL which also
  generates FORMAT DSNTIAUL in LOAD control statements. Users that
  cause DROP / CREATE scenarios via ALT or DB2 Object Compare Tool
  ( compid 5697g6400 ) are affected only when using HPU and
  FORMAT INTERNAL .
  .
  Error message appears similar to:
  .
  DSNU049I    065 08:45:11.92 DSNUGPRS - INVALID OPERAND
   'INTERNAL' FOR KEYWORD 'FORMAT'
  

Local fix

• remove FORMAT DSNTIAUL from the HPU control
  statements when FORMAT INTERNAL is used.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration or DB2       *
  *                 Object Comparison Tool for z/OS who use      *
  *                 DROP/CREATE table scenarios via the Alter    *
  *                 (ALT) or Compare function when using High    *
  *                 Performance Unload (HPU) with FORMAT         *
  *                 INTERNAL.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DB2 Administration or    *
  *                      DB2 Object Comparison Tool for z/OS to  *
  *                      change a column from NULLABLE to NOT    *
  *                      NULLABLE, or from NOT NULLABLE TO       *
  *                      NULLABLE, and the apply job uses HPU    *
  *                      UNLOAD with FORMAT INTERNAL, the APPLY  *
  *                      job will fail at the LOAD step because  *
  *                      the wrong load control statement is     *
  *                      generated:                              *
  *                                                              *
  *                      The load control statement appears      *
  *                      similar to:                             *
  *                                                              *
  *                      LOAD DATA                               *
  *                      FORMAT INTERNAL RESUME YES              *
  *                      INDDN SYSREC SORTKEYS  0                *
  *                      EBCDIC CCSID(0037)                      *
  *                      ENFORCE NO                              *
  *                      INTO TABLE ">schema<".">name<"          *
  *                                                              *
  *                      The error message issued by the LOAD    *
  *                      utility appears similar to:             *
  *                                                              *
  *                      DSNU070I  >time< DSNUGDFL -             *
  *                      KEYWORD OR OPERAND 'CCSID'              *
  *                      INVALID WITH 'FORMAT INTERNAL'          *
  *                      DSNU070I  >time< DSNUGDFL -             *
  *                      KEYWORD OR OPERAND 'EBCDIC'             *
  *                      INVALID WITH 'FORMAT INTERNAL'          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using DB2 Administration Tool or DB2 Object Comparison
  Tool for z/OS to change a column from NULLABLE to NOT NULLABLE,
  or from NOT NULLABLE TO NULLABLE, FORMAT INTERNAL should be
  turned off for HPU UNLOAD in the apply job because the table's
  definition has been changed which does not satisfy FORMAT
  INTERNAL.
  
  Additionally, when using HPU UNLOAD with FORMAT INTERNAL, the
  UNLOAD statement produced has the wrong syntax that requests
  LOADDDN SYSPUNCH in the DSNTIAUL format but OUTDDN SYSREC in
  the INTERNAL format which led to the failure of the LOAD
  utility because the keywords 'FORMAT INTERNAL' were
  incorrectly generated with 'EBCDIC' and 'CCSID' in the LOAD
  control statement.
  

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:

  UK81354

Modules/Macros

•    ADBTHPU  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81354

     UP12/08/30 P F208

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.