DB2MOVE QUESTIONS

Alan

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

Sep 12 '06 #1

Mark A

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

Sep 12 '06 #2

Pierre Saint-Jacques

You need to create the db with its three default tablespaces before running db2move on the receiving system
db2move does not create the tablespaces. It just moves data by creating the tables (if import option is used).

On the source, run db2look with the proper parms to extract all ddl for the objects.
Create the default db on the target and run the outout of db2look against it. (You may have to edit the container defs. if they can't match).
Then run db2look in load option.

Since you are going forom Win to Win why not backup and restore. If containers can't match then do a redirected restore.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Alan" <in**@lsl.com.hka ¨¦crit dans le message de 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

Sep 12 '06 #3