When creating a table with 20K size in a database having 4K size pages, get the following error.

db2 "create table t(name varchar(20480))"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0286N A default table space could not be found with a page size of at
least "32768" that authorization ID "DB2INST1" is authorized to use.
SQLSTATE=42727
Can I create a 32k page size tablespace and a corresponding buffer pool for this requirement? Does this have any impact on the performance of the database? What are the pros & cons of having different page size (4K, 8k, 32K) table spaces in a single database?

TIA.

DB2 cannot divide records between pages, thus if you
mant to create a varchar that big, you will have to create
a tablespace with a pagesize larger than the maximum recordsize
and put the table there.

With characters that long, you migth want to look into the
CLOB or long varchar data types.

HTH