SQL0286N A default table space could not be found with a pagesize of at least "<pagesize>" that authorization ID "<user-name>" is authorized to use

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software
SQL0286N A default table space could not be found with a pagesize of at least "<pagesize>" that authorization ID "<user-name>" is authorized to use

Software

IBM DB2 Database

Symptoms

When importing data to a DB2 database, the SQLSTATE0286N message is returned.

Actions

SQLSTATE0286N means that you are creating a table with the row length exceeding 4K. In order to create such tables, you have to create a tablespace with sufficient page size (at least "<pagesize>") in the database.