- 论坛徽章:
- 0
|
请教:关于SQL0286N
原帖由 "oprs"]字段太多,超出了默认页大小4k的限制,[/color 发表:
你可以新建个页大小为8k的userspace2表空间,将这个表建立在userspace2上
create table (.......) in userspace2
偶测试了一下,这个提示好像是sql0670,不过这个解决方法应该是正确的!
SQL0670N The row length of the table exceeded a limit of
"<length>;" bytes. (Table space
"<tablespace-name>;".)
Explanation: The row length of a table in the database manager
cannot exceed:
o 4005 bytes in a table space with a 4K page size
o 8101 bytes in a table space with an 8K page size
o 16293 bytes in a table space with an 16K page size
o 32677 bytes in a table space with an 32K page size
The length is calculated by adding the internal lengths of the
columns. Details of internal column lengths can be found under
CREATE TABLE in the SQL Reference.
One of the following conditions can occur:
o The row length for the table defined in the CREATE TABLE or
ALTER TABLE statement exceeds the limit for the page size of
the table space. The regular table space name
"<tablespace-name>;" identifies the table space from
which the page size was used to determine the limit on the
row length.
o The row length for the table defined in the DECLARE GLOBAL
TEMPORARY TABLE statement exceeds the limit for the page size
of the table space. The user temporary table space name
"<tablespace-name>;" identifies the table space from
which the page size was used to determine the limit on the
row length.
The statement cannot be processed.
User Response: Depending on the cause, do one of the following.
o In the case of CREATE TABLE, ALTER TABLE, or DECLARE GLOBAL
TEMPORARY TABLE, specify a table space with a larger pagesize,
if possible.
o Otherwise, reduce the row length by eliminating one or more
columns or reducing the lengths of one or more columns.
sqlcode: -670
sqlstate: 54010 |
|