PM33334: ALT NOVALUE CONDITION RAISED IN ADB27CMR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALT function ends with a:
  NOVALUE condition raised in ADB27CMR aaaaaaaa.
  - Line 278: Do while (index(text,'--') & rc = 0)
  
  when the "R" line command is used on panel ADB27CR "Alter
  Related" against a VIEW and then the ALTER command is issued on
  panel ADB27CA "Alter Tables".
  Panel ADB2ER "ISPF Dialog Error" panel is then displayed showing
  Function : SELECT CMD(%ADB27CMR ALTER OBJTABLE(aaaannn) )
  Retcode  : 20000
  Zerrmsg  :
  Zerrsm   :
  Zerrlm   : Database 2 Administration Tool
  5655-W34 Copyright IBM Corporation 1995, 2010.
  All rights reserved.  Licensed mater
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS Version 10.1 who use the 'R' line       *
  *                 command against a VIEW on panel ADB27CR      *
  *                 'Alter Related'.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS     *
  *                      Version 10.1, when the 'R' line         *
  *                      command is used on panel ADB27CR        *
  *                      'Alter Related' against a VIEW and then *
  *                      the ALTER command is issued on panel    *
  *                      ADB27CA 'Alter Tables', a NOVALUE       *
  *                      condition is raised in ADB27CMR at line *
  *                      278, a panel ADB2ER 'ISPF Dialog        *
  *                      Error' is then displayed showing return *
  *                      code 20000 from function:               *
  *                                                              *
  *                      SELECT CMD(%ADB27CMR ALTER              *
  *                      OBJTABLE(aann)).                        *
  *                                                              *
  *                      When using ALT to append a new          *
  *                      column onto the end of the table with   *
  *                      a null value or a specified default     *
  *                      value, the table will be altered via    *
  *                      the ALTER TABLE ADD COLUMN              *
  *                      statement.  This operation does not     *
  *                      cause that column to be included in     *
  *                      the existing SELECT * views, and the    *
  *                      views must be dropped and recreated     *
  *                      to include the new column. The          *
  *                      original purpose of 'R' line command    *
  *                      was to implement a DROP/RECREATE for    *
  *                      SELECT * views to include the new       *
  *                      appended column in the above            *
  *                      situation.                              *
  *                                                              *
  *                      DB2 Administration Tool for z/OS        *
  *                      Version 10.1 will drop and recreate     *
  *                      the SELECT * views automatically        *
  *                      to include the new appended column      *
  *                      with a null value or a specified        *
  *                      default value from the table. The       *
  *                      'R' line command is no longer needed.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS V10.1 will DROP and
  RECREATE the SELECT * views automatically to include the new
  appended column with a null value or a specified default value
  from the table. The 'R' line command is no longer needed.
  

Problem conclusion

• The 'R' line command is removed from panel ADB27CR 'Alter
  Related'.  The help panels ADBH7C and ADBH7CR are updated to
  display a new help panel ADBH7CR0 to clarify the operations
  performed for the related views.
  
  APAR PM33334 needs a change in the DB2 Administration Tool
  User's Guide for Version 10.1 only. Currently, the Admin Tool
  Version 10.1 will DROP and RECREATE the SELECT * views
  automatically to include the new appended column with a null
  value or a specified default value from the table if there is
  no alter operation on this view when using ALT. The 'R' line
  command on panel ADB27CR original purpose was to implement a
  DROP/RECREATE for SELECT * views to include the new appended
  column. The following two changes need to be applied to the DB2
  Administration Tool User's Guide for Version 10.1:
  
  Change 1:
  - Chapter 12. Changing DB2 objects
    - Changing tables
      - Altering or redefining a table with the ALT command
        - Examples of altering a table with the AL line command
          - Example: Changing a foreign key:
  
  Remove the line command 'R - Recreate view' on panel ADB27CR
  both in Figure 185. Alter Table (ADB21TAF) - Changing a foreign
  key and Figure 187. Alter Table (ADB21TAF).
  
  Change 2:
  - Chapter 12. Changing DB2 objects
    - Changing tables
      - How the DB2 Admin Alter ALT function works
        - Changing objects related to a table being changed
  
  Add the following note after Figure 188. Alter Related panel
  (ADB27CR) - Changing related objects:
  
  Note: If a new column is added to the end of the table with a
  null value or a specified default value, while a related view
  created with a SELECT * clause is not altered, the view will
  be dropped and recreated so that the new column can be
  included.
  

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

•    ADBH7C   ADBH7CR  ADBH7CR0 ADB27CR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK68761

     UP11/06/17 P F106

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.