SQL0286N cannot find a default tablespace with a page size of at least "8192" and a license to use the authorization identity "Db2inst".

During SQL processing, it returns:

SQL0286N cannot find a default tablespace with a page size of at least "8192" and a license to use the authorization identity "Db2inst".

As the name implies, DB2 default page size is 4K, so the table field is too long, close to 8K. A record cannot be stored across pages.

So we need to create a table space with a page length of 8K.

First, create a 8K buffer pool:

Create Bufferpool ibmdefault8k IMMEDIATE SIZE PAGESIZE 8 K;

Then, use the buffer pool to create a table space

CREATE tablespace Mytbs

In DATABASE PARTITION GROUP ibmdefaultgroup

PAGESIZE 8K

MANAGED by SYSTEM

USING

(' D:db2mycontainer '

)

Extentsize 32

Prefetchsize 16

Bufferpool ibmdefault8k

OVERHEAD 24.10

Transferrate 0.90

DROPPED TABLE RECOVERY OFF;

GRANT use of tablespace mytbs to public;

Then the execution passes smoothly.

SQL0286N cannot find a default tablespace with a page size of at least "8192" and a license to use the authorization identity "Db2inst".