DB2 创建表空间失败，谁能帮我解决解决啊，大神们快来啊！
2014-05-1916:25:07CREATEUSERTEMPORARYTABLESPACE"SUNCPS_USER_TMP"INDATABASEPARTITIONGR...
2014-05-19 16:25:07 CREATE USER TEMPORARY TABLESPACE "SUNCPS_USER_TMP" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING ('/home/suncps/SUNCPS_user_tem')
EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF
2014-05-19 16:25:07 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
2014-05-19 16:25:07 SQL1582N The PAGESIZE of the table space "SUNCPS_USER_TMP" does not match the PAGESIZE of the bufferpool "IBMDEFAULTBP" associated with the table space. SQLSTATE=428CB
哪个大神帮忙解决解决， 展开
EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF
2014-05-19 16:25:07 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
2014-05-19 16:25:07 SQL1582N The PAGESIZE of the table space "SUNCPS_USER_TMP" does not match the PAGESIZE of the bufferpool "IBMDEFAULTBP" associated with the table space. SQLSTATE=428CB
哪个大神帮忙解决解决， 展开
1个回答
展开全部
每一个表空间必须要有一个与之pagesize大小相同的bufferpool, 你这里定义的表空间死4K的, 但是我猜测你的IBMDEFAULTBP的pagesize不是4K的
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
