PH24115: CM BATCH UTIL_REORG_STATISTICS_USE_PROFILE = 'Y' INVALID OPERANDTABLE KEYWORD REORG ADBT015I FAILURE EXECUTING ADB2UTIL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If CM Batch parm UTIL_REORG_STATISTICS_USE_PROFILE is set to
  'Y', an invalid REORG statement, without the STATISTICS
  parameter, may be generated.  The run job may then result in
  the following error:
  
  INVALID OPERAND 'TABLE' FOR KEYWORD 'REORG'
  
  ADBT015I Failure attempting to execute ADB2UTIL with parm
  ssid,worklist number
  
  Keyword:  msgadbt015i
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS that use Change Management (CM) batch   *
  *                 jobs.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the CM batch parameter             *
  *                      UTIL_REORG_STATISTICS_USE_PROFILE       *
  *                      is set to 'Y',  the REORG utility fails *
  *                      with message DSNU049I.                  *
  ****************************************************************
  If UTIL_REORG_STATISTICS_USE_PROFILE = 'Y',
  Db2 Admin Tool generates an invalid REORG statement.
  The statement includes the USE PROFILE
  and TABLE(ALL) options but not the STATISTICS option.
  Because USE PROFILE and TABLE(ALL) are valid only if STATISTICS
  is also specified, the execution of the change fails with the
  following message:
  
  DSNU049I 162 14:52:49.34 DSNUGPRS -
  
  INVALID OPERAND 'TABLE' FOR KEYWORD
  'REORG'  due to missing STATISTICS
  keyword.
  
  The REORG can be executed successfully by adding the
  STATISTICS option.
  

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:

  UI70492

Modules/Macros

• ADBCCM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70492

     UP20/07/14 P F007

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.