PK10351: ONCODE310 ABEND0C8 RC8 IN ADB27AC DOING ALC THAT DELETES LAST COLUMN AND SWAPS TWO OTHER COLUMN POSITIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool an abend0c8 rc8 in adb27ac can
  occur during processing of an ALC operation that includes a
  delete of the last column, and also swaps the positions of
  two other columns within a table. Error messages appear like:
  .
  
  IBM0482S ONCODE=310 The FIXEDOVERFLOW condition was raised.
     From compile unit ADB27AC at entry point CONVERT_DDL at
     statement 3503 entry offset +000125DE at...
  .
  Additional symptoms: fixed overflow 310 0c8 rc08 msgibm0482s
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 ALC, may be affected.                        *
  *                 .* Note: fixing parts of this APAR are in    *
  *                 PK07878. Both  APARs  will be in the same    *
  *                 PTF.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: An  ABEND0C8  RC8  in ADB27AC can occur *
  *                      during  processing  of an ALC operation *
  *                      that  includes  a  delete  of  the last *
  *                      column, and also swaps the positions of *
  *                      two other columns within a table.       *
  *                      .*                                      *
  *                      Column types of timestamp, with default *
  *                      value, appear to  be  directly  related *
  *                      with the failures.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADB26CRT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK07267

     UP05/09/17 P F509

• R710 PSY UK07268

     UP05/09/17 P F509

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.