PI50699: DB2 ADMIN TOOL REORG TABLESPACE RESULTS IN MISSING COPYDDN REORG OPTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When generating a REORG job with Util line commands OO or OC,
  DB2 Admin Tool does not generate the COPYDDN(SYSCOPY) parameter
  in the REORG statement. This happens when in the tablespace is
  a table with a LOB column.
  
  When the tablespace does not contain a table with a LOB column
  the problem is gone.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Util line commands OO or OC.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When generating a REORG job via panel   *
  *                      ADB2US 'Table Space Utilities' with     *
  *                      line commands  'OO - Online reorg' or   *
  *                      'OC - Reorg with Inline Copy' or via    *
  *                      panel ADB21S 'Table Spaces' with line   *
  *                      commands 'U.OC -  Reorg Utility,        *
  *                      Inline Copy' or 'U.OO - Reorg Online    *
  *                      Utility',  DB2 Admin Tool does not      *
  *                      generate the COPYDDN(SYSCOPY)           *
  *                      parameter in the REORG statement.       *
  *                      This happens when the tablespace        *
  *                      contains a table with a LOB column.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program misses logic to generate COPYDDN(SYSCOPY) for stand
  alone REORG utility when the table space contains LOB columns.
  

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:

  UI35237 UI35238 UI35239

Modules/Macros

•    ADBHUSO  ADB2USOO ADB2USOP ADB2USO1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI35237

     UP16/02/12 P F602

• RB10 PSY UI35238

     UP16/02/12 P F602

• RB20 PSY UI35239

     UP16/02/12 P F602

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.