468,117 Members | 1,649 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

DB2MOVE QUESTIONS

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

Similar topics

1 post views Thread by TD Matthews | last post: by
2 posts views Thread by erkki | last post: by
1 post views Thread by Terry | last post: by
4 posts views Thread by Christos Kalantzis | last post: by
reply views Thread by ibm_97 | last post: by
2 posts views Thread by Mani | last post: by
reply views Thread by mikeodba | last post: by
13 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.