DB2创建空间的情况

centos后台操作
su root
su - db2inst1
bash
db2 list db directory
db2 create db wzl3

db2 connect to ca6314w user db2inst1 using db2inst1
db2 connect to km6314w user db2inst1 using db2inst1
db2stop force
db2 connect to wzl4 user db2inst1 using db2inst1
db2 -tvf creatDB2.sql

 

数据库名：格式问题：
lgqcs
名称长度有限制；
db2 connect to ************ user db2inst1 using db2inst1

 

注意：

CREATE REGULAR TABLESPACE NETPASS_53_DATA IN NODEGROUP IBMDEFAULTGROUP PAGESIZE 16384 MANAGED BY DATABASE USING (FILE 'NETPASS_53_DATA'12800) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL BUFFPOOL16 OVERHEAD 24.10000 TRANSFERRATE 0.900000;

CREATE REGULAR TABLESPACE NETPASS_53_IDX IN NODEGROUP IBMDEFAULTGROUP PAGESIZE 16384 MANAGED BY DATABASE USING (FILE 'NETPASS_53_IDX'6400) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL BUFFPOOL16 OVERHEAD 24.100000 TRANSFERRATE 0.900000;

CREATE TEMPORARY TABLESPACE TMPSPACE IN NODEGROUP IBMTEMPGROUP PAGESIZE 16384 MANAGED BY DATABASE USING (FILE 'NETPASS_53_TMP'6400) EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL BUFFPOOL16 OVERHEAD 24.100000 TRANSFERRATE 0.900000;

ALTER TABLESPACE SYSCATSPACE PREFETCHSIZE 16 OVERHEAD 24.100000 TRANSFERRATE 0.900000;
ALTER TABLESPACE TEMPSPACE1 PREFETCHSIZE 16 OVERHEAD 24.100000 TRANSFERRATE 0.900000;
ALTER TABLESPACE USERSPACE1 PREFETCHSIZE 16 OVERHEAD 24.100000 TRANSFERRATE 0.900000;