PM97460: ALT TS WITH REORG UTILITY OPTIONS STATISTICS(YES) HAS ERROR EVEN IF NOT A LOB TS OR TABLE HAS LOB COL: MULTIPLE REORG STMTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Reorg a list using Command OO, generated unexpected multiple
  Reorg statements; and ALT TS with reorg utility options
  STATISTICS(YES) has an error even if it is not a LOB TS or
  its table has LOB column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are fixed:                *
  *                                                              *
  *                      1. When panel ADB25LE 'Utility LISTDEF' *
  *                      displays multiple list-options and the  *
  *                      'UT - Utility generation' line command  *
  *                      is issued once, the job that is built   *
  *                      has multiple steps.                     *
  *                                                              *
  *                      2. When issuing the 'UTIL - Utility     *
  *                      Selections' line command on panel       *
  *                      ADB21S 'Table Spaces' against a         *
  *                      table space with LOBs, a REORG is       *
  *                      selected and STATISTICS=YES is          *
  *                      specified on panel ADB2USO 'Specify     *
  *                      Utility Options - REORG', the DB2       *
  *                      Admin Tool will correctly display       *
  *                      message ADB722E / msgadb722e:           *
  *                                                              *
  *                      ADB722E Option STATISTICS is not        *
  *                              allowed with LOBs.              *
  *                                                              *
  *                      Subsequently, if the user returns       *
  *                      to panel ADB21S and issues the          *
  *                      'ALT - Redefine a table space' line     *
  *                      command for an object without LOBs,     *
  *                      proceeding to panel ADBPALT 'Build      *
  *                      Analyze and Apply Job', entering        *
  *                      option 'UO - Customize utility          *
  *                      options', entering Option 'O - REORG',  *
  *                      and setting STATISTICS=YES, the DB2     *
  *                      Admin Tool will incorrectly display     *
  *                      message ADB722E / msgadb722e:           *
  *                                                              *
  *                      ADB722E Option STATISTICS is not        *
  *                              allowed with LOBs.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following are fixed:
  
  1.  Program does not isolate the selected list-option so all of
  the list-options are processed.
  
  2. Program variable is not reset after its last use.
  

Problem conclusion

• Problems have 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:

  UK98478

Modules/Macros

• ADB2U    ADB2US   ADB25LE
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK98478

     UP13/10/22 P F310

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.