PM48436: ADB27SP, LINE 80: ADB27PAR = DUP0001 /* PARTITIONS */ * ADB2U, L INE 1435: SPC = MAX(SPC,ADB27HUR) /* USE GREATER OF RETCODE 40

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS issues a message:
  Function : ADB27SP, LINE 80: adb27par = dup0001 /* partitions */
  Retcode  : 0
  Function : ADB2U, LINE 1435: spc = max(spc,adb27hur) /* use
  greater of 27 sp val or stospace val */
  Retcode  : 40
  when customers use the U.OO line command after using the ALT
  function online to alter the length of a column.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Reorg Online Utility        *
  *                 'U.OO' line command after using the          *
  *                 Alter Table (ALT) online function.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      issues error messages:                  *
  *                                                              *
  *                      Function : ADB27SP, LINE 80:            *
  *                                 adb27par = dup0001           *
  *                      Retcode  : 0                            *
  *                                                              *
  *                      Function : ADB2U, LINE 1435:            *
  *                                 spc = max(spc,adb27hur)      *
  *                      Retcode  : 40                           *
  *                                                              *
  *                      when using the 'U.OO' line command      *
  *                      after using the ALT online function     *
  *                      to execute an alter statement in the    *
  *                      foreground.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS ALT online function
  wrongly set a variable to blank, and while running utilities
  encounters an error by attempting to use this blank variable.
  

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:

  UK75068

Modules/Macros

•    ADBGAJOB ADB2U
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK75068

     UP11/12/24 P F112

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.