无法创建用户临时表空间

Joney Hsiao 2019-03-18 06:46:04
创建语句如下:
create database joney USING CODESET UTF-8 TERRITORY US COLLATE USING UCA500R1_LEN_S2 PAGESIZE 32 K
connect to joney
create user temporary tablespace session

报错如下:
db2 => create user temporary tablespace session
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0109N The statement or command was not processed because the following
clause is not supported in the context where it is used: "MANAGED BY SYSTEM".
SQLSTATE=42601

DB2 版本:
DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL11013" with level
identifier "0204010F".
Informational tokens are "DB2 v11.1.3.3", "s1803021700", "DYN1803021700AMD64",
and Fix Pack "3".
Product is installed at "/home/db2inst1/sqllib".
...全文
178 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
sunLengYue 2019-06-28
  • 打赏
  • 举报
回复
[jxgl@localhost ~]$ db2 create bufferpool bp16k size 1000 pagesize 16k
DB20000I The SQL command completed successfully.
[jxgl@localhost ~]$ db2 create USER temporary tablespace tempts16k pagesize 16k bufferpool bp16k

5,889

社区成员

发帖
与我相关
我的任务
社区描述
IBM DB2 是美国IBM公司开发的一套关系型数据库管理系统,它主要的运行环境为UNIX(包括IBM自家的AIX)、Linux、IBM i(旧称OS/400)、z/OS,以及Windows服务器版本
社区管理员
  • DB2
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧