DB2 错误解决方案:SQLCODE=-1585, SQLSTATE=54048
<p>DB2 错误解决方案:A system temporary table space with sufficient page size does not exist.. SQLCODE=-1585, </p>
<pre><code class="language-sql">CREATE BUFFERPOOL BP8K pagesize 8K;
CREATE SYSTEM TEMPORARY TABLESPACE STB_8 PAGESIZE 8K BUFFERPOOL BP8K;
CREATE BUFFERPOOL BP16K pagesize 16K;
CREATE SYSTEM TEMPORARY TABLESPACE STB_16 PAGESIZE 16K BUFFERPOOL BP16K;
CREATE BUFFERPOOL BP32K pagesize 32K;
CREATE SYSTEM TEMPORARY TABLESPACE STB_32 PAGESIZE 32K BUFFERPOOL BP32K;</code></pre>
<p>参考文章
<a href="https://stackoverflow.com/questions/25639962/sufficient-page-size-does-not-exist-db2-insert/36203894#36203894">https://stackoverflow.com/questions/25639962/sufficient-page-size-does-not-exist-db2-insert/36203894#36203894</a></p>