PH42556: MULTIPLE ISSUES GENERATED BY PANEL ADB21T LINE COMMAND 'I' TO INTERPRET SYSTABLE USAGE OF SYSACCELERATEDTABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues related to using the I line
  command on panel ADB21T:
  
  1) For tables that are accelerated in more than one accelerator,
  line command I on those tables in panel ADB21T ('Tables, Views,
  and Aliases') shows the information for only one of the
  accelerators on panel ADB21T1 ('Interpretation of an Object in
  SYSTABLES').
  
  2) Line command I issues a -551 error if a user does not
  have access to the SYSACCELERATEDTABLES table.
  
  
  Keyword:  SQLCODE551N
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Using the I (interpret) line command on      *
  *                 panel ADB21T can result in errors with       *
  *                 the output or command processing due to      *
  *                 accelerator details in the interpret         *
  *                 output.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using the I (interpret) line command on *
  *                      panel ADB21T can result in errors with  *
  *                      the output or command processing due to *
  *                      accelerator details in the interpret    *
  *                      output.                                 *
  ****************************************************************
  When you issue the I (interpret) line command on panel ADB21T,
  the accelerator details can be incorrect or can cause an error
  (SQL code -551.)
  
  Specifically, the issues are:
  1.  When a table has more than one accelerator, the I line
  command shows only one of the accelerators.
  2.  When the user that issues the I line command on panel ADB21T
  does not have the privilege to access the SYSACCELERATEDTABLES
  table, a -551 error is issued.
  
  Because the purpose of the I line command on panel ADB21T is to
  display the SYSTABLES information, the accelerator details are
  not needed and should be removed.  Use the DET line command to
  view the accelerator details.
  
  Keyword: SQLCODE551N
  

Problem conclusion

• The 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:

  UI79886

Modules/Macros

• ADB21T   ADB21TI1
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79886

     UP22/03/26 P F203

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.