无法创建用户临时表空间
创建语句如下:
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".