求救DB2 导入 问题

perry001

DB2 V8.1   备份文件是通过 export .........select * from table  导出的IXF 文件,
现在另一台服务器上通过import还原时,报
" import from SHOP_REGISTRATION.ixf of ixf  insert into SHOP_REGISTRATION
SQL3030C  An I/O error (reason = "sqlofopn -2079391743") occurred while
opening the input file.

SQL3110N  The utility has completed processing.  "0" rows were read from the
input file."  错误.


请教各位,急,在线等.

coolalibaba

db2 ? SQL3030C


SQL3030C An I/O error (reason = "<reason>") occurred while
          opening the input file.  

Explanation:

A system I/O error occurred while opening the input file.  This
error can refer to a problem on either the client or the
server.  

A possible cause may be that the input file is in use by another
application.  

The command cannot be processed.  

User Response:

Ensure that the input file is valid, including the path, and that
it is not currently in use by another application.  

Resubmit the command.

perry001

原帖由 coolalibaba 于 2007-3-31 17:19 发表
db2 ? SQL3030C


SQL3030C An I/O error (reason = "<reason>") occurred while
          opening the input file.  

Explanation:

A system I/O error occurred while opening th ...

我本人刚接触DB2 ,能说说一些解决办法吗?


谢谢!

zhong0912

打开输入的ixf文件的时候报错，检查ixf文件是否正常，权限、文件是否损坏等，或者文件所在的lv状态。
检查一下db2diag.log

zxalh..

ixf文件的存放路径没写对吧。写个绝对路径试试

红胡子

估计是文件路径问题把

xmltiger

在ixf文件所在目录执行import命令

psc2001

load replace 写错文件名好像直接=load from /dev/null
上次测试时候错过一次 吓死了

suoyongbo

有几个问题你需要试验确定一下
1、你导回数据时新服务器数据库中是否存在表SHOP_REGISTRATION，如果没有，你用的命令就是错误的。
2、你是否可以先八数据库停掉，然后再进行操作。
3、要导入的文件是否在IMPORT默认的目录下？

huyuhui001

补充一个，检查一下数据文件的权限。