PK05349: WHEN MIGRATING A DATABASE AND AFTER ISSUING MIGRI COMMAND, PANEL ADB28S COULD DISPLAY DUPLICATE TABLESPACE ENTRY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool request to migrate a database and add
  all RI related tablespaces via the MIGRI primary command on
  panel ADB28S may return panel ADB28S with multiple lines for
  the same tablespace.  Migrate job is generated correctly.
  .
  Additional symptoms: MIG line command produces duplicate
  lines in panel adb28s where one line shows column CLUSTERT
  ( CLUSTERTYPE ) Y and the other line shows a blank .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool R510,       *
  *                 who use the GRANT command on sequences,      *
  *                 or who use the Migrate function, may be      *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: .* Duplicate unique entries on panel    *
  *                      ADB28S are displayed. The extra entries *
  *                      are excess and should not be displayed. *
  *                      .* SQLCODE -20142 is received when      *
  *                      attempting to GRANT on a list of I-type *
  *                      sequences.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fixes.
  .* Duplicate unique entries on panel ADB28S has been removed.
  .* A error message has been added to indicate the GRANT primary
  command is invalid for a list of I-type sequences.
  

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

•    ADB2GQ   ADB21Q   ADB27SP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK06373

     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.