PI94115: DB2 ADMIN TOOL - ALTER TABLE LEADS TO ERROR ADB7168E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Problem comes up while attempting to ALTER a Column to a new
  length. This new length would exceed the page size limit There
  comes up an 'ERROR.FILE', showing some debug information.
  
  After the ERROR.FILE is displayed, F3 returns to the ALT panel
  and on the bottom of the panel is displayed:
  
   |----------------------------------------------------------|
   | Analysis ended with return code = 8.  Use TSO ISRDDN to  |
   | check the file contents.  The files remain allocated and |
   | should be freed manually.                                |
   |----------------------------------------------------------|
  
  The DDname REPORT showed:
  
  Compare table source(IS6X.TBISHJ) and target(IS6X.TBISHJ)
    Column C2
      (A)Type changed from VARCHAR(4000) to VARCHAR(4050)
  ADB7168E The source table space can not contain the table record
           length. Specify a larger buffer pool to ensure that the
           page size is suitable for the table record length and
           contain the record.
    Tables have identical column lists
    Table will be altered
  
  ALT - Error(s) found. Please review output
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ALT Table function gets error message   *
  *                      ADB7168E when increasing column         *
  *                      length; expected display of panel       *
  *                      ADB27PGA did not occur.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a table column is changed such that the record length
  exceeds the pagesize for the tablespace, error ADB7168E is
  issued late in the ALT process. The error should be caught
  earlier in the process, with resulting display of panel
  ADB27PGA to provide a warning.
  

Problem conclusion

• The problem has been resolved.
  

Temporary fix

Comments

• ×**** PE18/08/09 FIX IN ERROR. SEE APAR PI99461  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI55491 UI55492

Modules/Macros

•    ADB2USO1 ADB27C   ADB27CA  ADB27CAA ADB27CX
  ADB27C0  ADB27DUP ADB27PC  ADB27PGA ADB27RPP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55491

     UP18/04/28 P F804

• RC10 PSY UI55492

     UP18/04/28 P F804

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.