PK27946: PANEL AUTO REFRESH FAILURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool the option to allow auto refresh
  fails to refresh panel contents.
  One example occurs in panel adb21t when ALC appends a new
  column, prompt screen shows column add was completed, but return
  to panel adb21t shows the original number of columns.
  .
  Similar refresh problem reported in SP Stored Procedure updates.
  .
  After ALC operation, return to Admin parms panel ADB2P2 shows
  auto refresh option has been reset to NO.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users altering table columns via PANEL(ADB27 *
  *                 Users altering stored procedures via         *
  *                 PANEL(ADB21O/ADB26COV)                       *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                 Users altering table columns via             *
  *                 PANEL(ADB27C).                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Autorefresh is set to NO in certain sit *
  *                      to avoid the 'ALTER stmt executed' mess *
  *                      flash (disappear) due to the subsequent *
  *                        Upon returning to the previous panel, *
  *                      autorefresh value was not being reset t *
  *                      causing the residual value(s) to remain *
  *                      previous panel.                         *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ALC and Alter Stored Procedure panel (ADB2COV)
   will no longer change the customer's
  autorefresh setting.  If the setting is YES,
   the 'ALTER stmt executed' message may appear
   to flash as a result of the refresh being
  performed.  Customers wishing to see the
  ALTER message should set their autorefresh
  setting to NO and issue the REFRESH command
  manually when underlying data on a table
  display panel may have changed.
  

Problem conclusion

• The problem has been fixed.
  

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:

  UK22766

Modules/Macros

•    ADB21O   ADB210   ADB26COV ADB27C
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK22766

     UP07/03/17 P F703

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.