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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.