title: "A table space could not be found with a page size of at least "4096" that authorization ID "DB2INST1" is authorized to use." error in DB2
body: <p>I'm getting the following error message when trying to create temporary tables in DB2 (11.1) on Ubuntu 16.04:</p>
  
  <blockquote>
    <p>SQL Error [42727]: A table space could not be found with a page size of at least "4096" that authorization ID "DB2INST1" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=4.24.92</p>
  </blockquote>
  
  <p>This is the query I am trying to run (minimal example to demonstrate behaviour):</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE testTbl (col1 int NOT null)
  </code></pre>
  
  <p>I have tried creating an 8KB tablespace with an 8KB bufferpool and granting access for the db2inst1 user to it as described in this question: <a href="https://stackoverflow.com/questions/17418952/db2-getting-a-default-table-space-could-not-be-found-with-a-page-size-of-at-lea">DB2- Getting A default table space could not be found with a page size of at least &quot;8192&quot; that authorization ID &quot;***&quot; is authorized to use</a>, but this didn't seem to help.</p>
  
  <p>If anyone could give me any insight on why this is happening and how to resolve it would be much appreciated.</p>
  
  <p>Could this be a permissions based issue? The db2inst1 is the default user which was created with the installation so I would assume it has admin privileges over the database.</p>