导入问题紧急 [英] Import Problem Urgent
问题描述
我在从.ixf文件导入数据时出现问题，转储是从AIX框中得到的
，这个转储将被导入到win2003框中
db2v7.2 fixpack8。我刚刚在win2003中创建了一个新数据库，这个
转储将被导入到新的数据库中。这是执行此操作的
所必需的db2look.sql吗？还是有其他方法可以做到这一点。请帮助我
这个问题。
谢谢
lakshmanan
1.）如果在Windows机器上创建的数据库与AIX中的数据库具有相同的DDl'，那么您无需担心。
否则，你需要使用db2look创建DDL。
2.）现在转储将拥有不可读的数据和IXF格式
您需要使用db2move导入数据。
db2move<数据库名称> IMPORT -IO INSERT
您好回复您的回复我想告诉您我们没有
有在Windows框中的ddl是新的，没有任何数据
只导入转储。并且它是ixf格式我试过
db2move<数据库名称> IMPORT -io replace_create。
或导入动作所需的ddl文件。
lakshmanan
" lakshmananl" < LA ************ @ gmail.com>在消息中写道
news：11 ********************** @ t39g2000cwt.googlegr oups.com ...如果你的回复引用我想告诉你我们没有在windows框中有ddl它是新的并且没有任何数据
只有转储是进口。并且它是ixf格式我试过了db2move<数据库名称> IMPORT -io replace_create。
或者是导入操作所需的ddl文件。
lakshmanan
你应该使用db2look来获取所有DDL，因为IXF文件只会创建表和主键。
hi, i have a problem in importing data from .ixf files the dump was got
from AIX box and this dump is to be imported to win2003 box with
db2v7.2 fixpack8. i have just created a new db in the win2003 and this
dump is to be imported to the new db. IS the db2look.sql necessary for
doing this???or is there any other method of doing this. kindly help me
in this issue.
thanks
lakshmanan
1.)If the database created in the Windows machine has the same DDl''s as
the one in the AIX , then you need not worry.
Else, you need to create the DDL using db2look.
2.) Now the Dump will have data which is not readable and in IXF format
You need to use db2move to import the data.
db2move <database name> IMPORT -io INSERT
hi with the ref to your reply i would like to tell you that we do not
have the ddl in the windows box its is new and does not have any data
only the dump is to be imported. and it is in ixf format i tried
db2move <database name> IMPORT -io replace_create.
or is the ddl file necessary for the import action.
lakshmanan
"lakshmananl" <la************@gmail.com> wrote in message
news:11**********************@t39g2000cwt.googlegr oups.com...hi with the ref to your reply i would like to tell you that we do not
have the ddl in the windows box its is new and does not have any data
only the dump is to be imported. and it is in ixf format i tried
db2move <database name> IMPORT -io replace_create.
or is the ddl file necessary for the import action.
lakshmanan
You should use db2look to get all the DDL, since the IXF file will only
create the table and primary key.
这篇关于导入问题紧急的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
