How to create tablespace in DB2 v9.7?

person sticking a post it on a white board with the words how to written on it

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

You May Also Like

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.