关于DB2导出语句的问题

梦在别离时 2019-03-11 09:03:55

***** DB2MOVE *****

Action: EXPORT

Start time: Wed Jan 30 13:05:09 2019

Connecting to database RUNDB ... successful! Server : DB2 Common Server V10.5.7

EXPORT: 30030 rows from table "BSPHIS "."A_LXFS"
EXPORT: 84 rows from table "BSPHIS "."A_XWZR"
EXPORT: 67 rows from table "BSPHIS "."A_XWZR_JZ"
EXPORT: 65 rows from table "BSPHIS "."A_XWZR_YW"
EXPORT: 0 rows from table "BSPHIS "."AC007"
EXPORT: 75 rows from table "BSPHIS "."AC008"
EXPORT: 0 rows from table "BSPHIS "."AC009"
EXPORT: 0 rows from table "BSPHIS "."AC010"
EXPORT: 0 rows from table "BSPHIS "."AC011"
EXPORT: 0 rows from table "BSPHIS "."AC012"
EXPORT: 207 rows from table "BSPHIS "."AC013"
EXPORT: 299 rows from table "PLAT "."PF18"
EXPORT: 0 rows from table "BSPHIS "."PF19"
EXPORT: 3 rows from table "PLAT "."PF19"
EXPORT: 0 rows from table "BSPHIS "."PF20"
EXPORT: 18 rows from table "PLAT "."PF20"
EXPORT: 69 rows from table "BSPHIS "."PF21"
EXPORT: 117 rows from table "PLAT "."PF21"
EXPORT: 50 rows from table "BSPHIS "."PF22"
EXPORT: 72 rows from table "PLAT "."PF22"
EXPORT: 286 rows from table "BSPHIS "."PF23"
EXPORT: 50 rows from table "PLAT "."PF23"
EXPORT: 16 rows from table "BSPHIS "."PF24"
EXPORT: 16 rows from table "PLAT "."PF24"
**Error occured -1

Disconnecting from database ... successful!

End time: Wed Jan 30 14:18:37 2019

--------------------------------上面的是EXPORT日志--------------------------------------------------------------------------------------------------------------下面的是DB2move.lst语句--------------

!"WORKFLOW"."A"!tab1.ixf!tab1.msg!
!"BSPHIS "."A_LXFS"!tab2.ixf!tab2.msg!
!"BSPHIS "."A_XWZR"!tab3.ixf!tab3.msg!
!"BSPHIS "."A_XWZR_JZ"!tab4.ixf!tab4.msg!
!"BSPHIS "."A_XWZR_YW"!tab5.ixf!tab5.msg!
!"BSPHIS "."AC007"!tab6.ixf!tab6.msg!
!"BSPHIS "."AC008"!tab7.ixf!tab7.msg!
!"BSPHIS "."AC009"!tab8.ixf!tab8.msg!
!"BSPHIS "."AC010"!tab9.ixf!tab9.msg!
!"BSPHIS "."AC011"!tab10.ixf!tab10.msg!
!"BSPHIS "."AC012"!tab11.ixf!tab11.msg!
!"BSPHIS "."AC013"!tab12.ixf!tab12.msg!
!"BSPHIS "."AC014"!tab13.ixf!tab13.msg!
!"BSPHIS "."AC015"!tab14.ixf!tab14.msg!
!"BSPHIS "."AC016"!tab15.ixf!tab15.msg!
!"BSPHIS "."AC018"!tab16.ixf!tab16.msg!
!"BSPHIS "."AC019"!tab17.ixf!tab17.msg!
!"BSPHIS "."AC020"!tab18.ixf!tab18.msg!
!"BSPHIS "."AC021"!tab19.ixf!tab19.msg!
!"BSPHIS "."AC022"!tab20.ixf!tab20.msg!
!"BSPHIS "."AC023"!tab21.ixf!tab21.msg!

1.请问这其中的 "BSPHIS","PLAT"代表的是表空间吗 ? 日志比较多,上面只是一部分

2.这些还原的数据文件格式:db2move.lst,EXPORT.out,tab1.ixf,tab1,tab100.ixf,tab100都是类似域这种

3.这个是在Linux下的备份数据,请问怎么还原到windows下的DB2数据库中,怎么使用语句还原

4.谢谢

...全文