|
Problem IT26758
|
Status: Closed |
DB2 MIGHT TRAP WHEN CREATING A COLUMN ORIENTED TABLE ON LINUX PPC 64
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When running a create table statement like the following on
Linux PPC 64 big endien Db2 might trap:
db2 "create table t1 (c1 int, c2 int) organize by column"
It might as well as return the following error message:
SQL0670N The statement failed because the row size of the
resulting table
would have exceeded the row size limit. Row size limit: "1".
Table space name:
"IBMDB2SAMPLEREL". Resulting row size: "8". SQLSTATE=54010
Columnar tables, also known as BLU tables, are not supported on
Linux PPC 64 big endien but this is not checked appropriately. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 version 11.1 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.10.2018
15.07.2020
15.07.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
