PH00220: ALT IX-CONTROLLED TABLESPACE PBR PARTITIONING COLUMNS KEY LIMITS ADB80673 ALTER INCONSISTENCY ADB8057I ALTER_ROW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues:
  1.  Using the ALT line command on a LARGE
  TABLESPACE (TYPE=L),  to change it
  from index-controlled to partitioned-by-range, forces the user
  to enter the partitioning columns and key limits, even though
  these are already available in the Db2 catalog.
  2.  The analyze job may produce the following error messages:
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  ADB8057I Object details at the time of error:
  Operation : 50
  Row type : TB
  Object qualifier: >qualifier<
  Object name : >name<
  Procedure : alter_row
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using the ALT line command on           *
  *                      panel ADB21S 'Table Spaces' to          *
  *                      alter an IX-controlled LARGE            *
  *                      TABLESPACE (TYPE=L)                     *
  *                      to PBR erroneously prompts the          *
  *                      user to enter unnecessary               *
  *                      information. The ANALYZE job            *
  *                      may also fail with errors.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR addresses two issues:
  
  1. Using the ALT line command on panel ADB21S 'Table Spaces'
  to alter IX-controlled LARGE TABLESPACE (TYPE=L) to PBR
  erroneously prompts the user to enter information on panel
  ADB21TAP 'Alter Table' and Limit key values on panel
  ADB21TAV 'Alter Partitioned Table'.
  
  2. The ANALYZE job may fail with the following errors:
  
  ADB8067E Alter inconsistency in the row type, length, or prefix.
  ADB8057I Object details at the time of error:
  Operation : 50
  Row type : TB
  Object qualifier: >qualifier<
  Object name : >table name<
  Procedure : alter_row
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

• ×**** PE18/11/05 PTF IN ERROR. SEE APAR PH04920  FOR DESCRIPTION
  

APAR Information

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

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

Modules/Macros

•    ADB21SAR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.