DB2异机导入备份数据

问题已解，原因是/db2data/qydb/data目录不存在，创建并赋权限后就可以了。收起

SQL1051N  The path "/db2data/qydb/data" does not exist or is not valid.
从这个错误来看，要么是这个路径不存在，要么是权限不对。你用db2实力用户执行touch /db2data/qydb/data/a.txt这个命令，看看能不能创建/db2data/qydb/data/a.txt这个文件，如果报错的话，就是权限不对，或者根本没有这个目录。收起

如果两边数据库表空间路径不一样，需要做重定向恢复收起

我是在esxi 环境的虚拟机上，我还原机器重装过多次依然无法导入数据进去。以下是操作步骤。
[root@localhost ~]# mkdir /home/db2backup
[root@localhost ~]# mv QYDB.0.db2inst1.DBPART000.20150121010008.001 /home/db2backup/
[root@localhost ~]# chown -R db2inst1:db2iadm1 /home/db2backup/
[root@localhost ~]# chmod 755 /home/db2backup/
[db2inst1@localhost ~]$ db2 restore db qydb from /home/db2backup/
SQL2523W  Warning!  Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version.  The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL1051N  The path "/db2data/qydb/data" does not exist or is not valid.  
SQLSTATE=57019
---------------------------------------------------------------------------------------------------------
[db2inst1@localhost ~]$
[db2inst1@localhost ~]$ db2 restore database qydb from /home/db2backup/QYDB.0.db2inst1.DBPART000.20150121010008.001
SQL2036N  The path for the file, named pipe, or device
"/home/db2backup/QYDB.0.db2inst1.DBPART000.20150121010008.001" is not valid.
[db2inst1@localhost ~]$

----------------------------------------------------------------------------------------------
[db2inst1@localhost ~]$ db2 restore db qydb from /home/db2backup/QYDB.0.db2inst1.DBPART000.20150121010008.001
SQL2036N  The path for the file, named pipe, or device
"/home/db2backup/QYDB.0.db2inst1.DBPART000.20150121010008.001" is not valid.收起

回复 10# 新数科技


   您好！试过还是无法导入进去。能加个QQ指导下吗？非常感谢。我的  QQ 2669660794收起

改权限：
chown -R db2inst1:db2igrp1 /db2data/qydb/data
chmod -R 755  /db2data/qydb/data
你改完之后，重新restore，有什么报错？收起

回复 7# 新数科技


   您好！我查看过。是有权限的。但是还是无法导入收起

这种问题比较简单，建议作者仔细阅读restore database命令收起

回复 3# alan9668


  非常感谢您的指导，我是按照备份机的路径一模一样的路径设置的。谢谢！收起

回复 4# 新数科技


  非常感谢您的指导。根据您的指导我做了如下操作。[db2inst1@localhost ~]$ db2 restore database qydb from /home/db2backup/ taken at 20150727010015
SQL2523W  Warning!  Restoring to an existing database that is different from
the database on the backup image, but have matching names. The target database
will be overwritten by the backup version.  The Roll-forward recovery logs
associated with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL1051N  The path "/db2data/qydb/data" does not exist or is not valid.  
SQLSTATE=57019


从操作中来看发现好像还是错误的。收起