IT15107: DB2CONVERT FAILS WITH SQL0802N WHEN TABLE HAS MORE THAN 2147483647 ROWS

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• db2convert utility fails with
  
    SQL0802N Arithmetic overflow or other arithmetic exception
  occurred.  SQLSTATE=2200
  
  when trying to convert a table that has more than 2147483647
  rows (the max limit of a signed 32-bit integer).
  

Local fix

• Customer can try to accomplish the same result using other
  tools/methods, for example
  -- manually create the column-organized table, do a LOAD FROM
  CURSOR, drop original table, rename column-organized table to
  original name
  -- use ADMIN_MOVE_TABLE manually
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * First fixed in Db2 11.1 fp5                                  *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 fp5
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP