473,327 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

db2 restoration problem

hi everyone

I m restorimg a database , during which i m facing the peoblem
Here is the details description the problem.




RESTORE DATABASE NSWD FROM "C:\db2_backups" TAKEN AT 20080429211406 TO "C:" INTO NSWD WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

SQL0294N The container is already in use.

Explanation:

Table space containers may not be shared. The possible causes of
this error include the following.

o A CREATE TABLESPACE or ALTER TABLESPACE statement included a
container that is already in use by another table space.

o A CREATE TABLESPACE or ALTER TABLESPACE statement included a
container from a table space that has been dropped but the
drop statement has not been committed.

o An ALTER NODEGROUP statement used to add a node used the
containers of a LIKE node that is on the same physical node.
These containers would therefore already be in use.

o A CREATE TABLESPACE or ALTER TABLESPACE statement is
attempting to use the same container on more than one logical
node on a single physical node. The same containers cannot
be used for more than one node on the same physical node.

o An ADD NODE command or API used the containers from the
system temporary table spaces of a LIKE node that is on the
same physical node. These containers would therefore already
be in use.

o A CREATE TABLESPACE or ALTER TABLESPACE statement included a
DMS container from another database that no longer exists but
was not dropped properly. The container is not actually in
use but it is tagged as being in use. Therefore, DB2 will
not allow it to be used until it is untagged. However, it is
very important to verify that the container is not in use by
the same database or another database when untagging it. If
the container is in use when you untag it, the database(s)
involved will be corrupted.



User Response:

Ensure the containers are unique.

o For the CREATE or ALTER TABLESPACE statement, specify a
different container for the table space.

o For the CREATE or ALTER TABLESPACE statement including a
container from a dropped table space, try again after the
drop statement is committed or specify a different
container.

o For the ALTER NODEGROUP statement, reissue the statement
using the WITHOUT TABLESPACES clause, and then use the ALTER
TABLESPACE statement to create unique containers for the new
node.

o For CREATE or ALTER TABLESPACE statements where the
environment includes more than one logical node on a physical
node, ensure that the same containers are not specified for
such logical nodes.

o For an ADD NODE command or API, reissue the statement using
the WITHOUT TABLESPACES clause, and then use the ALTER
TABLESPACE statement to create unique containers at the new
node for the system temporary table spaces.

o If you are trying to use a DMS container that belonged to a
database that no longer exists but was not dropped properly,
then the db2untag utility can be used to remove the DB2
container tag from it. When this tag is removed DB2
considers the container to be free and the container can be
used in a CREATE TABLESPACE or ALTER TABLESPACE statement.

NOTE: Use extreme caution with db2untag. If you issue a
db2untag command against a container that is still in use by
a database, then both the database that originally used the
container and the database that is now using the container
will be corrupted.



sqlcode : -294

sqlstate : 42730


can you please anyone tell me entire process how to resolve that.
Jun 6 '08 #1
0 1548

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

Similar topics

0
by: Adam Smith | last post by:
Hello, I did a server upgrade and at the same time did a mysql update from 4.0.12 to Ver 12.22 Distrib 4.0.16. Essentially, moving from one machine to another. The dump consists of a cluster of...
3
by: Tommy.Vincent | last post by:
Hi, its newbie question. I have one production server(A) ,one backup server(B),additional server(C). my database backup are moved from A to C in regular basis. My problem is that when...
0
by: Richard | last post by:
hi, I am using SQL SERVER 2000. My query is, Can I restore my 60 transactional log file backup in one sql statement,giving condition where it is suppose to start and end.
1
by: Tommy.Vincent | last post by:
Hi, When i use to work on Windows 2000 advance server and Sql 2000 I was able to do network restoration by using a mapped drive where my backup use to be lying.What i did was I assigned...
1
by: Thyagu | last post by:
Hi, Does a database restoration perform any update-statistics/defragmentation by default. We observed a marked improvement in performance when we restored the a database from an high end...
2
by: bharadwaj | last post by:
any automated restoration script is available in sql server2000. I want to do the restoration for 10 databases(full backup,latest differential backup) in other server. Pls do the needful.
0
by: bharadwaj | last post by:
Hi, I am trying to do restoration for n databases using automated script.The script is given below. it is not giving errors while job execution ,but restoration is not happening.(no record is in...
0
by: bharadwaj | last post by:
hi, i am trying to do master restoration using the following steps. 1.net stop MSSQLServer 2.sqlservr -m 3.use MASTER go RESTORE DATABASE master FROM disk='master.BAK' replace, MOVE...
1
Ali Rizwan
by: Ali Rizwan | last post by:
Hi all, I want to disable auto restoration of windows. Suppose if i delete a file say explorer.exe after a while it will create again by windows. If i change any registery it will restore...
0
by: Now You Know | last post by:
Water Damage Restoration 24 hour open 7 Days Phone 1 877 364 5264 When disaster strikes such as a washing machine overflow, bath overflow, burst pipe, rainwater from balcony etc, water damage...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.