现在有个环境，如上题所述win下db2 v9.1数据迁移到aix v9.7的问题
我先在win下进行dll的导出
db2look -d chdhrzs -o aa.sql -a -e -td @ -l -x -f -nofed
之后编辑里面的信息，将连接和表空间的文位置等改变成aix中需要的位置。
但在aix导入时候，提示下面的错误
db2 -tvf aa.sql > a.txt
SQL0104N An unexpected token "CREATE" was found following "".
Expected tokens may include: "USER". SQLSTATE=42601
declare str_crt_temp_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
declare str_inst_temp_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
declare str_drop_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
是不是我这种方式不正确能？
我先在win下进行dll的导出
db2look -d chdhrzs -o aa.sql -a -e -td @ -l -x -f -nofed
之后编辑里面的信息，将连接和表空间的文位置等改变成aix中需要的位置。
但在aix导入时候，提示下面的错误
db2 -tvf aa.sql > a.txt
SQL0104N An unexpected token "CREATE" was found following "
Expected tokens may include: "USER". SQLSTATE=42601
declare str_crt_temp_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
declare str_inst_temp_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
declare str_drop_tab CLOB(5000000)
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003
是不是我这种方式不正确能？
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7652889/viewspace-627111/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
EM配置中古怪的错误。
下一篇：
9i安装问题？
请登录后发表评论
登录
全部评论
