472,985 Members | 2,844 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 2584

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Vikrant | last post by:
Friends, Due an application (old) install program problem, Under AIX I could only create DB2 instance, I could also catalog it. Its complex application and I am not expert in creating full...
1
by: Vikrant | last post by:
Hi Kelly This is from old response by you. What is 'callerac' parameter in REDIRECTED restore, how can I provide 'callerac' value ? Thanks, VKG =====
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was...
1
by: Jack | last post by:
Is it possible to find out what the tablespace definitions are of database you are about to build using a redirected restore? What I am wanting to do is build a script that can take only a backup...
7
by: CCC via DBMonster.com | last post by:
We use redirected restore to refresh test from prod on different AIX 5.2 servers. The databases have the same number, size and names of cooked containers. The only difference is the fully qualified...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
1
by: Kent.Brooke | last post by:
When a backup is taken from server a and then redirected restore is done on server b, the tables and data is fine however db2advis says "explain & advise tables not created for user x properly"....
1
by: okonita | last post by:
Hi all, This is a very urgent issue for my team. We are trying a Redirected restore the most current online DB2 UDBv8.2 backup copy from prod disk to disk on another/test instance. Our...
0
by: mccuenpat | last post by:
Currently trying to perform a redirected restore of DB2 database using Netbackup in AIX environment. The restore command completes successfully but the set tablespace commands fail due to no...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.