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