PI58765: ALT NOVALUE CONDITION RAISED IN ADB27CMR SYS00072. - LINE 481:COMCHAR = INDEX(TEXT,'--')

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function will
  generate a message:
  ALT NOVALUE condition raised in ADB27CMR SYS00072.   - Line 481:
  comchar = index(text,'--')
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a table and adding        *
  *                      a foreign key on panel ADBP7AD '        *
  *                      ALTER Add Options', then altering       *
  *                      each foreign key to change the          *
  *                      constraint name, DB2 Admin fails        *
  *                      on a 'NOVALUE condition raised..'       *
  *                      error.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When altering a table and adding a foreign key on panel
  ADBP7AD 'ALTER Add Options', then altering each foreign
  key to change the constraint name, DB2 Admin fails with
  the following error:
  
  NOVALUE condition raised in
  ADB27CMR SYSnnnnn.
  - Line xxx: comchar = index(text,'--')
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI41998 UI41999

Modules/Macros

• ADBE7FK0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI41998

     UP16/11/01 P F610

• RB20 PSY UI41999

     UP16/11/01 P F610

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.