如何将windows下的db2数据库还原到linux下？

ceshi85

我在linux命令行下运行db2 -tvf createdb.sql语句导入createdb.sql时，系统老是提示如下：

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
....
....
....

The TERMINATE command completed successfully.

表结构导不进去，是什么原因？

Jens

SQL1024N A database connection does not exist. SQLSTATE=08003

ceshi85

我是先connect to 这个数据库的，提示连接成功，为什么导数据的时候还会显示a database connection does not exist呢？

Jens

把脚本贴出来。

ceshi85

我是在windows下面用db2look -d bdcc60 -e -a -x -i db2admin -w bdcc -o createdb.sql命令导出数据的表结构，

然后用db2move bdcc60 export -u db2admin -p bdcc命令导出表数据，

然后将导出的表结构和数据cp到linux /usr/db2data/0521的文件夹下面，

进入该文件夹后，运行db2 -tvf createdb.sql命令导入表结构，现在表结构导入成功了，

但是在运行db2move bdcc60 load时，出现如下提示：

[db2admin@localhost 0521]$ db2move bdcc60 load


Error opening report file.  Terminating ...
**Error occured while opening a file.


End time:  Fri May 23 09:25:27 2008


这是什么原因？要如何解决啊？

cuteapple

db2diag.log 有什麼？

ceshi85

我不怎么会看日志，就把今天日志里面error的部分都截下来了，请各位帮忙看看，小女子在此谢过了~                         ....

2008-05-24-08.51.33.326398+480 I65177G269         LEVEL: Error
PID     : 3593                 TID : 3086178512
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-08.51.35.062914+480 I65447G425         LEVEL: Error
PID     : 3593                 TID : 3086178512
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-08.52.57.751812+480 I65873G269         LEVEL: Error
PID     : 3674                 TID : 3086604496
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-08.52.58.209745+480 I66143G425         LEVEL: Error
PID     : 3674                 TID : 3086604496
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.33.42.748783+480 I69598G269         LEVEL: Error
PID     : 5488                 TID : 3086117072
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.33.43.423645+480 I69868G425         LEVEL: Error
PID     : 5488                 TID : 3086117072
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.35.22.803852+480 I70697G269         LEVEL: Error
PID     : 5508                 TID : 3085977808
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.35.23.591754+480 I70967G425         LEVEL: Error
PID     : 5508                 TID : 3085977808
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)


2008-05-24-09.42.29.762028+480 I77991G269         LEVEL: Error
PID     : 5732                 TID : 3085932752
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.42.29.829339+480 I78261G425         LEVEL: Error
PID     : 5732                 TID : 3085932752
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.44.09.901404+480 I78687G269         LEVEL: Error
PID     : 5916                 TID : 3086862544
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.44.10.078066+480 I78957G425         LEVEL: Error
PID     : 5916                 TID : 3086862544
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.45.12.420837+480 I79383G269         LEVEL: Error
PID     : 5956                 TID : 3086563536
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.45.13.431881+480 I79653G425         LEVEL: Error
PID     : 5956                 TID : 3086563536
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)


2008-05-24-08.51.33.326398+480 I65177G269         LEVEL: Error
PID     : 3593                 TID : 3086178512
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-08.51.35.062914+480 I65447G425         LEVEL: Error
PID     : 3593                 TID : 3086178512
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-08.52.57.751812+480 I65873G269         LEVEL: Error
PID     : 3674                 TID : 3086604496
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-08.52.58.209745+480 I66143G425         LEVEL: Error
PID     : 3674                 TID : 3086604496
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.33.42.748783+480 I69598G269         LEVEL: Error
PID     : 5488                 TID : 3086117072
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.33.43.423645+480 I69868G425         LEVEL: Error
PID     : 5488                 TID : 3086117072
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.33.49.384338+480 E70294G402         LEVEL: Info
PID     : 3786                 TID  : 3086046912  PROC : db2agent (BDCC60) 0
INSTANCE: db2admin             NODE : 000         DB   : BDCC60
APPHDL  : 0-53                 APPID: *LOCAL.db2admin.080524013320
AUTHID  : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391
MESSAGE : Starting an offline db backup.

2008-05-24-09.35.22.803852+480 I70697G269         LEVEL: Error
PID     : 5508                 TID : 3085977808
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.35.23.591754+480 I70967G425         LEVEL: Error
PID     : 5508                 TID : 3085977808
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.36.21.296936+480 E71393G375         LEVEL: Info
PID     : 3786                 TID  : 3086046912  PROC : db2agent (BDCC60) 0
INSTANCE: db2admin             NODE : 000         DB   : BDCC60
APPHDL  : 0-53                 APPID: *LOCAL.db2admin.080524013320
AUTHID  : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:833
MESSAGE : Backup complete.


2008-05-24-09.42.29.762028+480 I77991G269         LEVEL: Error
PID     : 5732                 TID : 3085932752
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.42.29.829339+480 I78261G425         LEVEL: Error
PID     : 5732                 TID : 3085932752
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.44.09.901404+480 I78687G269         LEVEL: Error
PID     : 5916                 TID : 3086862544
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.44.10.078066+480 I78957G425         LEVEL: Error
PID     : 5916                 TID : 3086862544
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

2008-05-24-09.45.12.420837+480 I79383G269         LEVEL: Error
PID     : 5956                 TID : 3086563536
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-09.45.13.431881+480 I79653G425         LEVEL: Error
PID     : 5956                 TID : 3086563536
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)


2008-05-24-16.39.18.320001+480 I86394G269         LEVEL: Error
PID     : 3623                 TID : 3086686416
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x9000028C Timeout occured while calling a GCF interface function

2008-05-24-16.39.19.486495+480 I86664G425         LEVEL: Error
PID     : 3623                 TID : 3086686416
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller::getState, probe:40
MESSAGE : ECF=0x90000292 The GCF function ran properly but the service did not behave accordingly
CALLED  : DB2 Common, Generic Control Facility, gcf_reset
RETCODE : ECF=0x90000298 Failure as reported through GCF standard (GCF_FAILURE)

wangzhonnewnew

it says failed to open report file, are you sure you got all files generated under windows copied to linux?

wangli2000_cn

还是用export import方便些