james...@gmail.com
unread,Feb 11, 2014, 12:44:52 AM2/11/14You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
I am using partitioned DB2 10.1 (AESE), with 15 partitions on 5 machines (each machine hosts 3 partitions).
I have taken an offline backup from my database (after deactivating it) by running following command on catalog node (instance owning node):
db2 backup database myDb on ALL DBPARTITIONNUMS to /home/data/db2/backup
Now I am trying to restore it, by running restore command without roll forward. Starting from catalog node, I run following command on ALL machines, and all of them return success code:
db2 RESTORE DATABASE myDb FROM /home/data/db2/backup TAKEN AT 20140210171717 INTO myDb REPLACE EXISTING WITHOUT ROLLING FORWARD
But when I start my database, and run queries, I keep getting following error:
SQL1471N Cannot connect to database "MYDB" on node "2" because the
database on this node is not synchronized with catalog node. SQLSTATE=08004
Reading IBM pages, I realized it is happening because of roll forwarding issues. I even tried running restore command, and right after that running following command from catalog node:
db2 rollforward db myDb to end of logs ON ALL DBPARTITIONNUMS and complete
But it keeps giving me the same error.
I am just wondering what I am missing, as I just want to restore myDb to its initial state that I had right after loading it, when I took backup.
Any suggestion/idea ?
(Thanks in advance)
James