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

Redirected Restore and container removal

P: n/a
Lew
Hi,

I have a database that I am restoring to another database in the same
instance using a redirected restore. It seems to work fine but what
is troubling to me is in the diag log i see that it is attempting to
remove the original containers from the originating db as part of my
redirected restore. It is unable to remove them as they are in use
but the idea of it is still troubling to me. Is this working as
designed?

Lew

db2v8.1 fp11

restore command snippet

restore db dpmp from /backup_new/DPMP/full taken at 20070506043101
into dpmpnew newlogpath /backup/DPMPNEW/logs/NODE0000 with 4
buffers redirect without rolling forward without prompting;

set tablespace containers for 0 using
( device '/dev/rR73RLV0616' 262144,
device '/dev/rR74RLV0617' 262144,
device '/dev/rR75RLV0618' 262144
);
diag log snippet

2007-05-31-15.54.44.215318-300 I3414387A437 LEVEL: Error
PID : 791190 TID : 1 PROC : db2agent
(DPMPNEW) 0
INSTANCE: db2pims NODE : 000 DB : DPMPNEW
APPHDL : 0-375
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:
844
MESSAGE : Error releasing container 15 (/dev/rn0catlv16) for tbsp 0.
Rc =
80020039

2007-05-31-15.54.44.226793-300 I3414825A573 LEVEL: Severe
PID : 791190 TID : 1 PROC : db2agent
(DPMPNEW) 0
INSTANCE: db2pims NODE : 000 DB : DPMPNEW
APPHDL : 0-375
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:
844
DATA #1 : String, 106 bytes
Skipping removal of a container which is currently in use:

Database name: DPMP
Instance: db2pims

May 31 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.