PM10412: ALC PANEL ADB27C NEW DEFAULT INDICATOR S DDL DOES NOT HAVE WITH DEFAULT CURRENT SQLID PANEL AND ADB26CTU DEFAULT VALUE TOO LONG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC command does not
  honor the 'S' CURRENT SQLID New default indicator set on
  panel ADB27C 'ALTER Table' so the generated DDL shows
  'NOT NULL WITH DEFAULT'
  and not the expected:
  'NOT NULL WITH DEFAULT CURRENT SQLID'
  In addition, if the U / Update line command is used against the
  column panel ADB26CTU while the field 'Def. value' shows the
  expected 'CURRENT SQLID' string if the user presses ENTER the
  message 'Default value too long' is displayed.
  

Local fix

• Use the PROMPT function and edit the generated DDL to include
  the missing syntax.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Alter Column (ALC)          *
  *                 command to insert a column with              *
  *                 default indicator 'S' in panel ADB27C        *
  *                 "ALTER Table", or who update the             *
  *                 column with default indicator 'S' on         *
  *                 panel ADB26CTU "ALTER Table".                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for         *
  *                      z/OS ALC function does not              *
  *                      honor the new default value 'S'         *
  *                      (CURRENT SQLID) when set                *
  *                      on panel ADB27C. The generated          *
  *                      DDL shows 'NOT NULL WITH                *
  *                      DEFAULT' and not the expected           *
  *                      'NOT NULL WITH DEFAULT                  *
  *                      CURRENT SQLID'. In addition, if         *
  *                      the U (Update) line command is          *
  *                      used against the column, the field      *
  *                      'Def. value' in panel ADB26CTU          *
  *                      shows the expected 'CURRENT             *
  *                      SQLID' string. If the user hits the     *
  *                      ENTER key, the message 'Default         *
  *                      value too long' is displayed.           *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When the ALC command to insert a new column with
  default indicator 'S' is used, invalid DDL 'NOT NULL
  WITH DEFAULT' is generated instead of 'NOT NULL
  WITH DEFAULT CURRENT SQLID'. Also, an update
  of a column with default indicator 'S' on panel ADB26CTU
  results in the message, 'Default value too long', when
  the field 'Def. value' is set to 'CURRENT SQLID'.
  

Problem conclusion

• DB2 Administration Tool for z/OS now generates valid
  DDL statement 'NOT NULL WITH DEFAULT CURRENT
  SQLID' or 'NOT NULL WITH DEFAULT USER'.
  Panel ADB26CTU was modified to accept value
  'CURRENT SQLID' , 'USER' or 'SESSION_USER'.
  

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:

  UK60825

Modules/Macros

•    ADB26CTU ADB27DUP ADB51
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK60825

     UP10/09/30 P F009

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.