I restored a database backup taken on a different server using this script:
FORCE APPLICATIONS ALL; RESTORE DATABASE MY_DATABASE_NAME FROM /backup/db2inst1 TAKEN AT 20140104051657 ON /data INTO MY_DATABASE_NAME WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING; TERMINATE;
From which I receive the message:
Restore is successful
Then I try to connect:
[db2inst1@host sql]$ db2 CONNECT TO MY_DATABASE_NAME SQL0901N The SQL statement or command failed because of a database system error. (Reason "Scan interface error".) SQLSTATE=58004
I was able to restore the exact same backup to the server it came from with no problems. This only occurs when attempting to restore it to a different server. The second server has a nearly identical setup (both CentOS 6.3, both using db2 10.1 express-C), the only difference being the main server has a user db2inst1 in group db2iadm1 and the second has db2inst1 in group db2inst1. Any ideas?