PK22603: PANEL ADB26CTQ 'SEQUENCE OPTIONS' CACHE VALUE INCORRECT AS NO CA CHE IS DISPLAYED AS 0 AND CAUSES MSG 'VALUE OUT OF RANGE'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool AL SEQUENCE panel ADB26CTQ issues
  an error message "Value out of range" for a SEQUENCE defined
  with CACHE NO CACHE as the CACHE fied is displayed as zero.
  

Local fix

• Change the CACHE value from 0 to NOCACHE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Administration Tool, who      *
  *                 use the ALTER command on sequences, may      *
  *                 be affected.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The AL SEQUENCE panel ADB26CTQ issues   *
  *                      an error message "Value out of range"   *
  *                      for  a SEQUENCE defined with CACHE NO   *
  *                      CACHE  as the CACHE fied is displayed   *
  *                      as zero.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Panel ADB26CTQ displays CACHE value as 0 instead of NO CACHE,
  resulting in a "Value out of range" error message.
  

Problem conclusion

• CACHE value is stored as 0 in SYSSEQUENCES (catalog), but
  the SQL keyword used for ALTER or CREATE SEQUENCE is NO
  CACHE. A "0" is displayed on the panel in this case, which
  is invalid. NO CACHE should be externalized on the panel.
  In addition, a problem exists where the SQL generated in
  the panel for the NO CACHE case has an extraneous keyword
  ("CACHE NOCACHE" is generated, which is invalid).
  .*
  ADB26CTQ is changed to convert 0 to NOCACHE before display.
  ADB21QI1 is also changed to display NO CACHE instead of 0.
  Also, the extraneous CACHE keyword in the NO CACHE case is
  no longer generated.
  

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:

  UK16507

Modules/Macros

•    ADB21QI1 ADB26CTQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK16507

     UP06/07/27 P F607

• R710 PSY UK16508

     UP06/07/27 P F607

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.