PM39837: SQLCODEN190 ALTER TABLE ALTER COLUMN1 SET DATA TYPE SMALLINT ON ALT APPLY JOB.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT function APPLY jobs
  ends return code 8 / RC=8 with a message:
  ADB5044I *** INPUT STATEMENT:
     ALTER TABLE <schema>.<tablename>
       ALTER COLUMN1 SET DATA TYPE SMALLINT ;
  sqlerror on ALTER      command, EXECUTE    function
   DSNT408I SQLCODE = -190, ERROR:  THE ATTRIBUTES SPECIFIED FOR
  THE COLUMN
            COLUMN1 ARE NOT COMPATIBLE WITH THE EXISTING COLUMN
  DEFINITION
   DSNT418I SQLSTATE   = 42837 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXISB5 SQL PROCEDURE DETECTING ERROR
  when a DECIMAL column is changed to a SMALLINT column on panel
  ADB27C "ALTER table".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who update the DECIMAL column to a      *
  *                 different column type.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
  *                      generated the ALTER TABLE SET DATA TYPE *
  *                      statement when the table should be      *
  *                      DROPPED/RECREATED with the new column   *
  *                      type.                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool generated the ALTER TABLE SET
  DATA TYPE statement for column updates from DECIMAL to
  SMALLINT, INTEGER, and DECFLOAT when a DROP/CREATE TABLE
  statement should have been generated.
  

Problem conclusion

• The DB2 Object Comparison Tool will DROP/CREATE for the table,
  instead of ALTER'ing the table for the following column
  updates:
  
  DECIMAL(5, 0) to SMALLINT
  DECIMAL(10,0) to INTEGER
  DECIMAL(17, 0) to DECFLOAT(16)
  

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:

  UK68752

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK68752

     UP11/06/17 P F106

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.