请教：关于SQL0286N

mymm

能不能看一下你的建表语句和你的"list tablespaces show detail"输出！

mymm

原帖由 "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