SQL0286N A default table space could not be found

SQL0286N  A default table space could not be found with a page size of at
least "8192" that authorization ID "XXXX" is authorized to use. 
SQLSTATE=42727

 

原因是：页大小超过了4k，需要8k

    用管理员登陆[db2inst1]
    先创建8K 的bufferpool：
          create bufferpool pool8k size 100 pagesize 8k;

    然后在8K 的bufferpool 上创建8k 的TABLESPACE：
          CREATE TABLESPACE tbspace8k PAGESIZE 8 K  MANAGED BY DATABASE  USING ( FILE '/opt/IBM/data/tbspace8k' 5120 ) EXTENTSIZE 8 OVERHEAD 10.5 PREFETCHSIZE 8 TRANSFERRATE 0.14 BUFFERPOOL  pool8k;

    最后在8k 的TABLESPACE 上创建表：
         create table mytable (name varchar(32670)) in tbspace8k;

    在分配权限：

         grant use of tablespace tbspace8k to public