PK41736: FF720 PANEL AUTO REFRESH FAILURE F/F FOR R710 PK27946 FFPK27946

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

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1.Users altering table columns via PANEL     *
  *                   (ADB27C).                                  *
  *                 2.Users altering stored procedures via       *
  *                   PANEL(ADB21O/ADB26COV).                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Autorefresh  is set to NO in  certain   *
  *                      situations  to avoid  the 'ALTER stmt   *
  *                      executed' message to flash(disappear)   *
  *                      due to the  subsequent refresh.  Upon   *
  *                      returning  to the previous panel, the   *
  *                      autorefresh value was not being reset   *
  *                      to YES, causing the residual value(s)   *
  *                      to remain on the previous panel.        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  ALC and Alter Stored  Procedure panel (ADB26COV) 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:

Modules/Macros

•    ADB21O   ADB26COV ADB27C
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK26740

     UP07/08/09 P F708

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.