By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,533 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

Restore DB2 9.1 backup problem

P: 1
Hello,

I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows.

Expand|Select|Wrap|Line Numbers
  1. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2
  2. UPDATE COMMAND OPTIONS USING S ON Z ON MYDB_NODE0000.out V ON
  3. DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
  4.  
  5. SET CLIENT ATTACH_DBPARTITIONNUM 0
  6. DB20000I The SET CLIENT command completed successfully.
  7.  
  8. SET CLIENT CONNECT_DBPARTITIONNUM 0
  9. DB20000I The SET CLIENT command completed successfully.
  10.  
  11. RESTORE DATABASE mydb FROM 'C:\' TAKEN AT 20080310154100 INTO mydb REDIRECT WITHOU
  12. T ROLLING FORWARD
  13. SQL1277W A redirected restore operation is being performed. Table space
  14. configuration can now be viewed and table spaces that do not use automatic
  15. storage can have their containers reconfigured.
  16. DB20000I The RESTORE DATABASE command completed successfully.
  17.  
  18. SET TABLESPACE CONTAINERS FOR 2 USING ( FILE 'C:\db2_data\userspace1'
  19. 256000 )
  20. DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
  21.  
  22. SET TABLESPACE CONTAINERS FOR 3 USING ( FILE 'C:\db2_data\regtbs'
  23. 768000 )
  24. DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
  25.  
  26. SET TABLESPACE CONTAINERS FOR 4 USING ( FILE 'C:\db2_data\idxtbs'
  27. 128000 )
  28. DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
  29.  
  30. SET TABLESPACE CONTAINERS FOR 5 USING ( FILE 'C:\db2_data\lobtbs'
  31. 512000 )
  32. DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
  33.  
  34. SET TABLESPACE CONTAINERS FOR 6 USING ( PATH 'C:\db2_data\testspace' )
  35. DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
  36.  
  37. RESTORE DATABASE mydb CONTINUE
  38. SQL1277W A redirected restore operation is being performed. Table space
  39. configuration can now be viewed and table spaces that do not use automatic
  40. storage can have their containers reconfigured.
  41. DB20000I The RESTORE DATABASE command completed successfully.
As you can see, although all the redirects finish successfully, it fails to run the restore db mydb continue

1. The script is generated by db2

2. I manually run the above commands too, got the same problem

3. There are 0~7 tablespace containers, but 0, 1, and 7 are automatic storage tablespace,
e.g.
Expand|Select|Wrap|Line Numbers
  1. db2 => set tablespace containers for 7 using (file "C:\db2_data\C0000000.LRG" 32)
  2. SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an
  3. automatic storage table space. SQLSTATE=55061
4. The only thing I changed is the file size in the SET TABLESPACE CONTAINERS command, since I don't have enough space for the tablespace allocated on the original machine, but I do have enough space to hold all the data (the backup file is about 28GB only).

Any suggestion/help is appreciated!
Apr 1 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I have just had the same problem, but I have finally tracked down the cause.
One of more of the "redirect" commands is using a container name that is already in use, OR a redirect is missing for a tablespace and the original location is still in use.
There is no error message when issuing the redirect and a totally misleading message when you try to "continue", but the file name has already been used.
To find which tablespace is causing the problem, look in the diagnostic log. There should be a message.
The conatiner may be in use by another database. This was the problem I had. The redirect commands were generated by a script, which missed them some tablespaces.
The "continue" will not work if it knows that a container is already in use - it is asking you for a missing redirect command.
I hope this helps.
Oct 6 '10 #2

vijay2082
100+
P: 112
Hi,
You need to provide path for the automatic storage tablespaces. This the reason why your restore is failing.How will the database figure out where to set automatic storage containers for the tablespace (0, 1, and 7 in youe case)

You will also see mesages related to container failed operation while doing a rollforward continue operation in the db2diag.log file.

ideally your restore command should be like one below
-- assuming that you have sufficient space on D: and that teh drive is present on the server

db2 "RESTORE DATABASE mydb FROM 'C:\' TAKEN AT 20080310154100 on ' D:\' dbpath on 'C:\' INTO mydb REDIRECT WITHOUT ROLLING FORWARD "


Ref: http://publib.boulder.ibm.com/infoce...c/r0001976.htm


Cheers, Vijay
Oct 18 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.