SQL0286N A table space could not be found with a page size of at least 32768

Question:  I got this error on  MYDB on MYSERVER: 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 table space could not be found with a page size of at least "32768" that authorization ID "DB2USER" is authorized to use. SQLSTATE=42727

Answer:   You must be attempting to execute a CREATE TABLE statement where the requirement is for a pagesize greater that the tablespace pagesizes available.   You could verify this by connecting to the database and running the LIST TABLESPACES SHOW DETAIL command.

If you  need  to create a table with larger sized records  , such as the 32K tablespace recommended in your error message, you'll have to create some extra database objects.

1) Create a 32k bufferpool

2) Create a 32k pagesize  regular tablespace

3) Create a temp tablespace using the 32k pagesize

This is a sample script to complete these 3 steps. Customise according to your environment

CREATE BUFFERPOOL  MYDB_32K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 32K;
CREATE LARGE TABLESPACE MYDB_32K PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 32 PREFETCHSIZE 32  BUFFERPOOL  MYDB_32K;
CREATE SYSTEM TEMPORARY TABLESPACE  MYDBTEMP_32K PAGESIZE  32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL  MYDB_32K;

 Read More on DB2 tablespace management

How to check reclaimable space enabled on DB2 tablespace with ...

DB2 – How to check if autoresize is enabled - DBA DB2