PI06539: ALTERING LOB TS GENERATES MSG ADB5184E DSNU049I REORG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Altering a LOB Tablespace specifying Reorg options generates msg
  DSNU049I INVALID OPERAND 'NO' FOR KEYWORD 'REPORT'
    ADBT015I  Failure attempting to execute   ADB2UTIL  with parm
    ADB5184E The run is ending due to an error with a non-SQL
             command.
  when Reorg options STATISTICS has been previously set.
  

Local fix

• Panel ADB2USO change option STATISTICS YES to NO for the Reorg
  options
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who specify the STATISTICS options      *
  *                 for REORG utilities during the ALT           *
  *                 function's change process.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when altering a LOB table space to      *
  *                      trigger a REORG and specifying the      *
  *                      STATISTICS options like REPORT NO,      *
  *                      these options will be generated in      *
  *                      the REORG statements which causes       *
  *                      REORG to fail with the following        *
  *                      error message:                          *
  *                                                              *
  *                      DSNU049I INVALID OPERAND 'NO'           *
  *                      FOR KEYWORD 'REPORT'                    *
  *                      ADBT015I Failure attempting to          *
  *                      execute ADB2UTIL with parm              *
  *                      ADB5184E The run is ending due          *
  *                      to an error with a non-SQL              *
  *                      command.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when altering a LOB table
  space to trigger a REORG and specifying the STATISTICS options
  like REPORT NO, these options will be generated in the REORG
  statements which causes REORG to fail with the following error
  message:
  
  DSNU049I INVALID OPERAND 'NO' FOR KEYWORD 'REPORT'
  ADBT015I Failure attempting to execute ADB2UTIL with parm
  ADB5184E The run is ending due to an error with a non-SQL
  command.
  

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:

  UI13423

Modules/Macros

• ADBGAJOB ADB2USO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI13423

     UP13/12/13 P F312

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.