December 5, 2012 by Tahir
How to create tablespace in DB2 v9.7?
I was trying to create tablespace in DB2 on AIX.
I wanted to have that tablespace in a directory at my operating system. I have also created a bufferpool having the same pagesize of tablespace (that is necessary). But was getting SQLCODE=-104.
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 ;<space>, DRIVER=3.61.75
I also tried with `FILE` tokens giving the sizes too. But was unable to run it. Thanks to Ian on SO for correcting my query. Following is the correct query to create a tablspace with a buffer pool attached to it.
CREATE TABLESPACE TS01 PAGESIZE 16K MANAGED BY DATABASE USING (FILE '/dbdata/UMPSYS01.dms' 100M) BUFFERPOOL BPOOL