Number 2 is your problem, you never want to drop the tablespace and try
to restore it. You will always get the error that the tablespace does
not exist. I called IBM on this once thinking it was a problem...Their
response was that it was not a problem but a "feature". You are going
to have to restore the entire database either some place via a
redirected restore or restore the database to it's original database. I
found this out the hard way.
Jeremy D. Schleicher
Database Administrator
Office: 850-645-2130
Cell: 314-550-3956
-----Original Message-----
From: Vaibhav_Jain
[mailto:db2udbdba-ezmlmshield-x45213999.[Email address protected]
Sent: Wednesday, May 25, 2005 8:02 AM
To: LazyDBA Discussion
Subject: problem in tablespace restore
Dear all,
I have a problem regarding tablespace restore
I went through following steps
1) I take a full backup of a database.
2) Then I drop a dms table space from it.
3) When I try to restore only tablespace using a full database
backup or a tablespace backup as following
db2 => restore db db_vj tablespace ( tab_vj3 ) taken at
20050524112933
4) it gives the following error:
SQL2549N The database was not restored because either
all of the table spaces
in the backup image are inaccessible, or one or more
table space names in list
of table space names to restore are invalid.
When I see this error message through error code it says that the
containers it used cant
Explanation:
The containers which were used by the table spaces in the backup
image are not available, are already in use, or one or more table
space names specified in the list on the restore command do not
exist in the backup image.
It suggests to do redirected restore.
But even then it gives the same error.
Regards
Vaibhav Jain
Satyam Computer Service Ltd.
EABIS (Ohri Towers)
Secunderabad
mobile no. 9866304822
DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page