PK06380: TWO PROBLEMS FROM ALC OF GENERATED ALWAYS COLUMN USING PANEL ADB26CTQ AND VALUES FOR PROMPT FIELD ' CACHE '

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration tool there are two problems encountered
  trying to use ALC ( Alter Column ) command to alter column
  definition to GENERATED ALWAYS .
  .
  First problem from panel adb26ctq where ENTER causes error
  message:    Value out of range
  when default value for CACHE is left unchanged as 0 ( zero ).
  .
  Second problem is also from panel adb26ctq and occurs when
  changing the zero to NOCACHE builds an SQL ALTER statement
  that contains ' SET CACHE NOCACHE ' which produces:
    sqlcode104 ( -104 ) with error reports similar to:
  .
  Rollback done
     SQLCODE : -104                         DSNTIAR CODE :  0
  
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "CACHE".
           SOME SYMBOLS THAT MIGHT BE LEGAL ARE: CYCLE,
           NOCYCLE, ORDER, NOCACHE, NOORDER, NOMINVALUE,
           NOMAXVALUE
  .
  Additional symptoms: msgdsnt408i i up ADB26CTU ADB27C
  

Local fix

• Use prompt on feature, and edit SQL ALTER statement phrase
    SET CACHE NOCACHE
  to:
    SET NOCACHE
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,  who       *
  *                 use ALC line command from panel ADB21T,      *
  *                 are affected.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQL CODE -104 was  encountered  when *
  *                      attempting  to alter an identity column *
  *                      to NO CACHE.                            *
  *                      .*                                      *
  *                      When trying to use ALC command to alter *
  *                      column definition to GENERATED ALWAYS , *
  *                      two problems were encountered:          *
  *                      .* From panel ADB26CTQ, an ENTER caused *
  *                      error message "Value out of range" when *
  *                      default value for CACHE was  left  as 0 *
  *                      ( unchanged as zero ).                  *
  *                      .* From panel ADB26CTQ,  when  changing *
  *                      the 0 to NOCACHE to build  a  SQL ALTER *
  *                      statement  that   contains  ' SET CACHE *
  *                      NOCACHE ', an SQL CODE -104 occurred.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The keyword SET was omitted from the ALTER TABLE ...
  SET NO CACHE clause. 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:

  UK09640

Modules/Macros

•    ADB26CTQ ADB27C   ADB27DUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK09640

     UP05/12/14 P F512

• R710 PSY UK09641

     UP05/12/06 P F512

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.