zyjibmcn · September 30, 2017 00:03 · bl4ckck · Nov 27, 2019
diff --git a/db2-temporary-tablespace b/db2-temporary-tablespace
 最近从生产库dump一个几十万的表，import到本地库时，排序查询会报以下错误：
 A temporary table could not be created because there is no available system temporary table space that has a compatible page size.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.63.123

 解决办法：
 db2 "create bufferpool ibmdefault8k IMMEDIATE  SIZE 5000 PAGESIZE 16K"
 db2 "CREATE TEMPORARY  TABLESPACE mytmptbs PAGESIZE 16K MANAGED BY SYSTEM USING ('/home/db2inst1/tmp_tbs1') EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT16K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF"
	最近从生产库dump一个几十万的表，import到本地库时，排序查询会报以下错误：
	A temporary table could not be created because there is no available system temporary table space that has a compatible page size.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.63.123

	解决办法：
	db2 "create bufferpool ibmdefault8k IMMEDIATE SIZE 5000 PAGESIZE 16K"
	db2 "CREATE TEMPORARY TABLESPACE mytmptbs PAGESIZE 16K MANAGED BY SYSTEM USING ('/home/db2inst1/tmp_tbs1') EXTENTSIZE 32 PREFETCHSIZE 16 BUFFERPOOL IBMDEFAULT16K OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY OFF"