1

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?

asked Jan 11, 2014 at 15:38
3
  • Do you know which fix pack both versions were on? I found this APAR list which mentions the error if you move from FP1 back to the GA release of 10.1: www-01.ibm.com/support/docview.wss?uid=swg1IC85565. It looks from what I'm seeing elsewhere on the web that this can result if you restore from a newer version of DB2 to an older version (possibly even fix pack-wise) such as the link above shows. Check to make sure both are at the same FP level to rule out the problem. Commented Jan 12, 2014 at 1:49
  • I ran across that same article. I am in the process of updating to 10.5 which has the added benefit of 16G memory (up from 4). I will update this question with the results, but as of this comment the restore has been running for more than 4 hours (trying to restore on my development laptop VM with 1G ram)... Commented Jan 12, 2014 at 1:59
  • @ChrisAldrich, the update to 10.5 did the trick. It doesn't really explain the problem, but nonetheless it worked. If you would like to change your comment to an answer, I would be happy to mark it that way. Commented Jan 12, 2014 at 19:34

1 Answer 1

0

Do you know which fix pack both versions were on? I found this APAR list which mentions the error if you move from FP1 back to the GA release of 10.1. It looks from what I'm seeing elsewhere on the web that this can result if you restore from a newer version of DB2 to an older version (possibly even fix pack-wise) such as the link above shows. Check to make sure both are at the same FP level to rule out the problem.

answered Jan 12, 2014 at 21:27

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.