db2数据库的临时表空间不够

 1. 创建pagesize 16k的bufferpool，自己去调大小 
 # db2 create bufferpool bp16k  size 1000 pagesize 16k
 ​
 2. 创建temp space，automatic storage
 # db2 create system temporary tablespace tempts16k pagesize 16k bufferpool bp16k

iplat的db2要求

 mkdir /data/db2/iplat
 chown db2inst1:db2inst1  /data/db2/iplat
 su db2inst1  
 create db iplat on /data/db2/iplat  using codeset utf-8 territory CN
 ​
 db2 connect to iplat
 create schema iplat
 create schema iplatdb
 ​
 表空间和缓冲池
 db2 create bufferpool buf_iplat all nodes size -1 pagesize 32k
 db2 create bufferpool buf_iplatdb all nodes size -1 pagesize 32k
 ​
 db2 "create large tablespace DS_IPLAT01 pagesize 32k  bufferpool buf_iplat"
 db2 "create large tablespace IS_IPLAT01 pagesize 32k  bufferpool buf_iplat"
 ​
 db2 "create large tablespace DS_IPLATDB01 pagesize 32k  bufferpool buf_iplatdb"
 db2 "create large tablespace IS_IPLATDB01 pagesize 32k  bufferpool buf_iplatdb"