title: How to create tablespace in DB2?
body: <p>I want to create tablespace in DB2 and my platform is AIX.</p>
  
  <p>I want to have that tablespace in a directory at my operating system. I have also created a bufferpool having the same pagesize of tablespace. But getting SQLCODE=-104.</p>
  
  <pre><code>CREATE BUFFERPOOL BPOOL  SIZE 2000 PAGESIZE 16K;
  
  CREATE TABLESPACE TS01 
  
  MANAGED BY DATABASE 
  USING ( '/dbdata/UMPSYS01' )  
  PAGESIZE 16K
  BUFFERPOOL BPOOL 
  </code></pre>
  
  <p>I have tried with <code>DEVICE</code> and <code>FILE</code> tokens giving the sizes too. But unable to run it.</p>
  
  <p>Following error I am getting: </p>
  
  <pre><code>18:13:38  [CREATE - 0 row(s), 0.000 secs]  [Error Code: -104, SQL State: 42601]  DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=USING ( '/dbdata/UMPSYS01' );ESPACE TS01 
  ;&lt;space&gt;, DRIVER=3.61.75
  </code></pre>