Create statements are as follows:
The create database joney USING CODESET utf-8 TERRITORY US COLLATE USING UCA500R1_LEN_S2 PAGESIZE 32 K
Connect to joney
The create user temporary in tablespace session

An error is as follows:
Db2=& gt; The create user temporary in 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 The command was not processed because The following
Clause is not supported in the context where it is 2: "MANAGED BY SYSTEM".
SQLSTATE=42601,

DB2 version:
DB21085I This instance or install (the instance name, where applicable:
"Db2inst1") USES the "64" bits and the DB2 code release "SQL11013" with level
Identifier "0204010 f."
Informational tokens are "DB2 v11.1.3.3 s1803021700", ""," DYN1803021700AMD64, "
And Fix Pack "3".
The Product is installed at/home/db2inst1/sqllib.

CodePudding user response:

[JXGL @ localhost ~] $db2 create bufferpool bp16k size 1000 pagesize 16 k
DB20000I The SQL command completed successfully.
[JXGL @ localhost ~] $db2 create USER temporary in tablespace tempts16k pagesize 16 k bufferpool bp16k