## 解决方法 A 机器备份 $ db2 backup database db_name online to /db2data compress include logs
传送到B 机器后进行恢复 $ db2 restore database db_name from /db2data/backup taken at 20150805145729 into new_db_name logtarget /db2data/backup/logs
$ db2 "rollforward database ne_db_name to end of logs and stop overflow log path(/db2data/backup/logs)"
恢复之后,B 机器新建的实例用户binst只能连接,无查询权限 $ db2 "select * from syscat.tables fetch first rows only" SQL0551N "FUNDINS" does not have the required authorization or privilege to perform operation "EXECUTE" on object "NULLID.SQLC2H23". SQLSTATE=42501
B 机器上新建ainst用户,与binst同一用户组,配好db2 的bash_profile 之后,连接上new_db_name ,给binst 授权dbadm 权限 $ db2 "grant dbadm on database to user binst