PK16325: ADMIN TOOL ADB28T PANEL ADDRI AND MIGRI COMMAND GIVE DIFFERENT RESULT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For The Admin Tool Table Migration Panel ADB28T the ADDRI and
  MIGRI commands give different results.
  

Local fix

• Use additional ADDRI commands as needed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use the Migrate  *
  *                 function at the table level (e.g. issue MIG  *
  *                 command for one or more tables).             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The RIT  (show related  tables)  line   *
  *                      command on the panel ADB28T sometimes   *
  *                      returns the erroneous results that is   *
  *                      inconsistent with the number of table   *
  *                      relations stated on panel ADB28T.       *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The RIT  (show related tables)  line command  on panel ADB28T
  incorrectly returns the  related tables for all tables in the
  table  space of the selected table,  instead of just  for the
  selected table.  In addition, the SQL SELECT for the RIT line
  command contains  a condition clause that could result in 'no
  rows returned' even though there are related tables.
  

Problem conclusion

• The RIT line command on panel ADB28T has been fixed to
  only return the  related tables for the selected table
  (non-recursive), and the SQL SELECT statement has been
  fixed  to remove the unnecessary  condition that could
  cause erroneous results.
  

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:

  UK30223

Modules/Macros

•    ADBH8T   ADB28T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK30223

     UP07/10/25 P F710

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.