DB2 - Problem description
Problem IT15107 | Status: Closed |
DB2CONVERT FAILS WITH SQL0802N WHEN TABLE HAS MORE THAN 2147483647 ROWS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem 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). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * First fixed in Db2 11.1 fp5 * **************************************************************** | |
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 | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.05.2016 13.11.2019 13.11.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |