By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,304 Members | 3,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,304 IT Pros & Developers. It's quick & easy.

DB2MOVE QUESTIONS

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.