PK26814: PANEL ADB21CDU 'UPDATE RUNSTATS INFORMATION' GIVES SQL WARN(+100) AS WHERE CLAUSE FOR COLVALUE IS INCORRECT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool panel ADB21CDU 'Update Runstats
  Information' gives a message 'SQL warn(+100)' when attempting
  to update SYSIBM.SYSCOLDIST as the WHERE clause has the
  wrong value for the COLVALUE field.
  Additional keyword
  SQLCODE100
  

Local fix

• Use PROMPT function to capture the update SQL and option 2 on
  panel ADB2PSTM 'Statement Execution Prompt' to edit the SQL
  to correct COLVALUE clause.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who issue  *
  *                 Update Runstats command from panel ADB21CDI, *
  *                 may be affected.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Attempt  to update runstats information *
  *                      (UR command  on ADB21CDI)  resulted  in *
  *                      SQL warn(+100)                          *
  *                      .*                                      *
  *                      Issuing CDI command on ADB21T,  then UR *
  *                      command on ADB21CDI, followed by update *
  *                      of  COLVALUE  field, resulted in error. *
  *                      In  addition,  the  value  of  COLVALUE *
  *                      shown on ADB21CDU was incorrect, and it *
  *                      did  not  process  the  new  value  for *
  *                      update correctly.                       *
  *                      .* Note                                 *
  *                      The  reported problems have been fixed. *
  *                      In addition, a problem with the refresh *
  *                      of  the  Value  field on panel ADB21CDI *
  *                      after update has been fixed.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADB21C   ADB21CDI ADB21CDS ADB21CDU ADB21CPS
  ADB21T   ADB21TC  ADB21TPS ADB21XC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK18367

     UP06/10/05 P F610

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.