PI82074: DB2 ADMIN TOOL WITH APAR PI71905 ON DB2 V11CM OR DB2 V10 - INVALID OPERAND 'PERIODOVERRIDE' FOR KYWRD 'LOAD'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After applying APAR PI71905, when running on DB2 for z/OS V11CM
  or DB2 for z/OS V10, Load utility fall with:
  DSNU049I - INVALID OPERAND 'PERIODOVERRIDE' FOR KYWRD 'LOAD'
  
  msgDSNU049I PERIODOVERRIDE
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who alter a table which requires        *
  *                 an unload and load on a DB2 release          *
  *                 below DB2 11 New Function Mode               *
  *                 (NFM).                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: An OVERRIDE statement is generated      *
  *                      in the wrong position for the LOAD      *
  *                      statement. The LOAD failed with error   *
  *                      DSNU049I / msgDSNU049I.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When altering a table which requires an unload and load, DB2
  Admin Tool generated an OVERRIDE statement in the wrong
  position for the LOAD utility which is invalid on a DB2
  release below DB2 11 NFM. The LOAD fails with the following
  error DSNU049I / msgDSNU049I:
  
  DSNU049I - INVALID OPERAND 'PERIODOVERRIDE'
  FOR KEYWORD 'LOAD'
  

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:

  UI48015 UI48016

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI48015

     UP17/06/15 P F706

• RC10 PSY UI48016

     UP17/06/15 P F706

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.