>"Alan" <in**@lsl.com.hkwrote in message news:45********@127.0.0.1...
>Guys,
Got a DB2 ver. 8.2 on Windows 2003 with four tablespaces (some field size
around varchar(2000 on it) define on it. Try >to create another database on
another Windows 2003 server using db2move export/import, and I got this
message.
SQL0286N A default table space could not be found with a page size of at
least "16384" that authorization ID "DB2ADMIN" is authorized to use.
SQLSTATE=42727
My question is do I need to create the database and tablespaces before I
run the db2move import? Any others way I >can do it with one command?
Thanks
Alan
You should use db2look to create the DDL before you do the db2move in order
to get all the object created that you will need. This will create the
tablespaces, bufferpools, foreign keys, authorizations, etc.
In the future, please post using text only (no rtf).