PK05985: ONLINE REORG WITH SHRLEVEL CHANGE ALLOWS IMPLICIT TABLESPACE WHICH IS NOT SEGMENTED TO BE CREATED FOR MAPPING TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool when using utility option ' OO ' or
  u.oo for ONLINE REORG of a tablespace and specifying SHRLEVEL
  CHANGE on panel ADB2USO , a mapping table and index are
  required.  Panel ADB2USO1 allows the mapping table owner,
  mapping table name and index name to be specified.
  Next, panel ADB2USOO provides the means to create a database,
  tablespace, table and index for mapping.  However,
  if Create ts = NO , the job created will fail with messages:
    DSNU371I  #DSN7- DSNURFIT - REORG MAPPING TABLE'S TABLE SPACE
                                MUST BE SEGMENTED
    DSNU012I    DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST
                           RETURN CODE=8
  .
  Implicit creation of the tablespace does not create a segmented
  tablespace which is required.
  .
  Additional symptoms: MSGDSNU371I  RC08  RC8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 the Online Reorg utility with SHRLEVEL       *
  *                 CHANGE, are affected.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A non-segmented table space  is created *
  *                      and used for the mapping table.         *
  *                      .*                                      *
  *                      DB2 Administration Tool allows implicit *
  *                      table space creation  for  the  mapping *
  *                      table, which results in a non-segmented *
  *                      table space. Mapping  table  requires a *
  *                      segmented table space.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Verification is added to require a table space name when Create
  Table is YES even if not creating a new table space. Lookup now
  only searches for segmented table spaces. If Create TS field is
  YES, Segsize field is required. If Create TS field is NO, it is
  assumed the TS name entered is segmented.
  

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:

Modules/Macros

•    ADBHUSOO ADB2USOO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK06373

     UP05/08/26 P F508

• R710 PSY UK06374

     UP05/08/26 P F508

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.