title: sufficient page size does not exist - DB2 insert
body: <p>I am having a DB2 query(simple insert statement) which is trying to insert some 27 columns. Out of those columns 1 is <strong><em>Clob</em></strong> and the issue is there. For my <strong><em>Clob</em></strong> column, sometimes the value might even contain <strong><em>28K</em></strong> characters. And in such extreme cases, I am getting the below error,</p>
  
  <pre><code> A system temporary table space with sufficient page size does not exist .. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.64.82
  </code></pre>
  
  <p>As I googled and gone through some pages, there is an entity called <em>System Temporary Table Space</em> which will be used by the DB when executing the query.(I am not sure, but few pages says that it will be used only for sorting and joining, but i don't have either in my query).</p>
  
  <p>After going through few suggestions I created a <strong><em>System Temporary Table Space</em></strong> with the page size of 32K, using the below query,</p>
  
  <pre><code>CREATE SYSTEM TEMPORARY TABLESPACE STB PAGESIZE 32K MANAGED BY SYSTEM USING ( 'C:\DB2\NODE0005') BUFFERPOOL BP32K
  </code></pre>
  
  <p>Still my issue continues. What would be the proper way to have my query executed. I am trying to understand the importance of <strong><em>System Temporary Table Space</em></strong>, <strong><em>Page Size</em></strong>,etc.. But any help that could fix this issue for now would be greatly appreciated.</p>