PK82262: ALC INSERT COLUMN PANEL ADB27C DOES NOT PROMPT FOR DEFAULT VALUE WHEN DEFAULT Y SPECIFIED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool panel adb21t using Alter Table
  Columns, ALC line command displays panel adb21tc where INSERT
  column, I line command, is used to display panel adb27c. Panel
  adb27c does not prompt for default value when DEFAULT Y is
  is specified.
  .
  Customer was expecting DEFAULT value prompt panel, adb27ctu ,
  whenever DEFAULT Y is specified, and does not want to enter 'U'
  line command in order to specify an explicit DEFAULT value of
  NULL on panel adb27ctu.
  .
  Inconsistent results:
  Specifying NULL Y and DEFAULT N omits the adb27ctu prompt panel
  for DEFAULT value, resulting in SQL ALTER TABLE statement with
  neither 'NOT NULL' nor DEFAULT clause. When both clauses are
  omitted, DB2 interprets the SQL ALTER TABLE as having an
  implicit definition of DEFAULT NULL. This implicit definition
  is inconsistent with panel input of DEFAULT N, and is not
  explained in help text.
  .
  Specifying NULL Y and DEFAULT Y results in SQL ALTER TABLE
  statement which omits 'NOT NULL' clause, but includes explicit
  DEFAULT clause with no value specified. This results in system
  default value of B (blank) for CHAR datatype. Customer would
  like to be able to specify NULL for DEFAULT value explicitly
  from panel adb27c, or automatically receive DEFAULT prompt
  panel, adb27ctu, whenever DEFAULT Y is specified in panel
  adb27c.
  

Local fix

• Use line command 'U' to update inserted column
  definition, and explicitly specify NULL default value.
  .
  Then use CONTINUE command to build JOB/WSL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who use     *
  *                 ALC to insert columns.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Default column (column heading "D") *
  *                      on panel ADB27C allows one to specify   *
  *                      the value of "Y".                       *
  *                                                              *
  *                      This  caused  the column to be defined  *
  *                      as  WITH  DEFAULT,  when  it should be  *
  *                      defined as WITH DEFAULT NULL. A column  *
  *                      defined  as WITH  DEFAULT  results  in  *
  *                      the Default column  being  set to  "B"  *
  *                      in  the  DB2 catalog,  which conflicts  *
  *                      with the original specification of "Y". *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The use of the Default column on panel ADB27C
  is misleading, and can lead to a column being
  inserted with an undesired default setting.
  

Problem conclusion

• Specifying a value of  "Y"  in the default  column on ADB27C
  should be the equivalent of specifying  "WITH DEFAULT NULL",
  and the value of "Y" in the SYSIBM.SYSCOLUMNS.DEFAULT column
  for the column in question.  The product will omit the "WITH
  DEFAULT NULL"  clause as it is functionally equivalent to do
  so.
  

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

•    ADBH     ADBH7C   ADBH7PTR ADB26CTU ADB27C
  ADB27CA  ADB27CPV ADB27CX  ADB27C0  ADB27PAR ADB27PTR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK49451

     UP09/08/27 P F908

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.