Hi all,

My problem is, when I tried to compile 60 tables, I ended up not compiling 4 tables. Following error was thrown,

Error Description : [IBM][CLI Driver][DB2/NT] SQL0286N A default table space could not be found with a page size of at least "8192" that authorization ID "ADMINISTRATOR" is authorized to use. SQLSTATE=42727.

I want to increase the table space of a database. How can I do this?.

As a update of my previous post, I use System Managed Storage for this tablespace.

Thanks,
Kamesh

Kamesh,
Your problem is that you need to create another tablespace with an 8K pagesize. See thr CREATE TABLESPACE command.

Andy