Question about tablespaces

[glhernandez]

I always get an error of this when I'm trying to create a table with 79 columns and almost all of it has datatypes of VARCHAR.

This is the error
" A table space could not be found with a page size of at least "8192" that authorization ID "JUSTIN" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=4.13.111 "

What should I do? I didn't get of this error when I created a table that is composed of 40 to 45 columns

By the way I'm using IBM Data Studio ( DB2 10.1 ) so you may teach my in GUI form or in hard code.


Best Regards,

G.L Hernandez

[Anas Mosaad]

You need to create a new tablespace with at least 8K pagesize. It's not totally related to the number of columns. It's related to the calculated row size. There's a handy procedure created by Serge that you can use to calculate the row size. You can find the procedure here https://www.ibm.com/developerworks/m...ize?lang=en_us