PDF下建立表空间失败
1 第一步成功
db2 "create database partition group test on all dbpartitionnums"
DB20000I The SQL command completed successfully.
2 但是准备在这个database partition上建立表空间却失败
db2 "create tablespace test3 in database partition group test managed by database using (file '/db2/hdb/usr/test3' 100M)"
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0294N The container is already in use. SQLSTATE=42730
[db2inst1@f1 ~]$ ls -alt /db2/hdb/usr/test3
ls: cannot access /db2/hdb/usr/test3: No such file or directory
db2 "create database partition group test on all dbpartitionnums"
DB20000I The SQL command completed successfully.
2 但是准备在这个database partition上建立表空间却失败
db2 "create tablespace test3 in database partition group test managed by database using (file '/db2/hdb/usr/test3' 100M)"
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0294N The container is already in use. SQLSTATE=42730
[db2inst1@f1 ~]$ ls -alt /db2/hdb/usr/test3
ls: cannot access /db2/hdb/usr/test3: No such file or directory