468,257 Members | 1,408 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Redirected Restore and container removal

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
0 2396

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by GL | last post: by
1 post views Thread by Jack | last post: by
7 posts views Thread by CCC via DBMonster.com | last post: by
11 posts views Thread by Chris | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.