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".