Avoiding container format during a redirected restore 
Author Message
 Avoiding container format during a redirected restore

Hi Group.

I have a 300GB DB2 (SAP) database that I am trying to move from one
site to another using a redirected restore via TSM.  The new site is
tape constrained until we can move the drives from the old to the new
sites, but we are in testing phase at the moment.

When the restore runs, TSM mounts a tape, restores a small amount of
data and then sits there for a couple of hours  while DB2 formats its
containers.  Once these are formatted the restore proceeds correctly.

Is there any way to pre-format the containers so that the tape mount
is not held unnecessarily, or alternatively to get TSM to let go of
the drive until it is actually needed once again?

Thanks

Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia



Sun, 31 Jul 2005 14:35:58 GMT
 Avoiding container format during a redirected restore

Hi Steve,

we have the same problem with a 500GB Database, but no change.
What you can do, is to extract the image with db2adutl
to disk. But think about the OS limit 64GB for files.

When we backup our DB2 with two TSM sessions (we can't take more),
we can't extract the image because each file ist 250GB great;-)

If anyone has a solution, give it us.

Regards, Joachim Mller



Quote:
> Hi Group.

> I have a 300GB DB2 (SAP) database that I am trying to move from one
> site to another using a redirected restore via TSM.  The new site is
> tape constrained until we can move the drives from the old to the new
> sites, but we are in testing phase at the moment.

> When the restore runs, TSM mounts a tape, restores a small amount of
> data and then sits there for a couple of hours  while DB2 formats its
> containers.  Once these are formatted the restore proceeds correctly.

> Is there any way to pre-format the containers so that the tape mount
> is not held unnecessarily, or alternatively to get TSM to let go of
> the drive until it is actually needed once again?

> Thanks

> Steve Harris
> AIX and TSM Admin
> Queensland Health, Brisbane Australia



Sun, 31 Jul 2005 21:17:31 GMT
 Avoiding container format during a redirected restore
Not a solution, but we're running UDB on Solaris 8 and we can go over 64GB
for a file no problem. Our biggest backup currently is 130GB all in 1 file.
So maybe you want to check if this limit can not be raised on the OS level?

Also, how long does it take you to backup this 500GB database to tape? How
is your system connected to the tape storage?

Thanks.


Quote:
> Hi Steve,

> we have the same problem with a 500GB Database, but no change.
> What you can do, is to extract the image with db2adutl
> to disk. But think about the OS limit 64GB for files.

> When we backup our DB2 with two TSM sessions (we can't take more),
> we can't extract the image because each file ist 250GB great;-)

> If anyone has a solution, give it us.

> Regards, Joachim Mller



> > Hi Group.

> > I have a 300GB DB2 (SAP) database that I am trying to move from one
> > site to another using a redirected restore via TSM.  The new site is
> > tape constrained until we can move the drives from the old to the new
> > sites, but we are in testing phase at the moment.

> > When the restore runs, TSM mounts a tape, restores a small amount of
> > data and then sits there for a couple of hours  while DB2 formats its
> > containers.  Once these are formatted the restore proceeds correctly.

> > Is there any way to pre-format the containers so that the tape mount
> > is not held unnecessarily, or alternatively to get TSM to let go of
> > the drive until it is actually needed once again?

> > Thanks

> > Steve Harris
> > AIX and TSM Admin
> > Queensland Health, Brisbane Australia



Mon, 01 Aug 2005 02:30:36 GMT
 Avoiding container format during a redirected restore
Hi Steve,
Sounds like you are using file containers instead of device
containers. I have not noticed a delay when restoring from tape to
device containers. Certainly have seen considerable time taken to
create a tablespace using file containers versus next to no time with
device containers.

You can change this on the redirected restore, according to the Admin
Guide.

Otherwise, do you have room on disk? (and using db2adutl to create a
copy of the backup on disk).

Regards,
Bruce Allen
GrapeVine Information Technology, Sydney
bruce dot allen at grapevineit dot com dot au

Quote:

> Hi Group.

> I have a 300GB DB2 (SAP) database that I am trying to move from one
> site to another using a redirected restore via TSM.  The new site is
> tape constrained until we can move the drives from the old to the new
> sites, but we are in testing phase at the moment.

> When the restore runs, TSM mounts a tape, restores a small amount of
> data and then sits there for a couple of hours  while DB2 formats its
> containers.  Once these are formatted the restore proceeds correctly.

> Is there any way to pre-format the containers so that the tape mount
> is not held unnecessarily, or alternatively to get TSM to let go of
> the drive until it is actually needed once again?

> Thanks

> Steve Harris
> AIX and TSM Admin
> Queensland Health, Brisbane Australia



Mon, 01 Aug 2005 14:30:43 GMT
 Avoiding container format during a redirected restore
Erik,

the full backup take in online modus takes approximately 4h and 30 minutes.
It's a backup with tsm with 2 session over a css0 (high perfomance switch)
between SP boxes. The data are on IBM ESS.

Regards, Joachim Mller



Quote:
> Not a solution, but we're running UDB on Solaris 8 and we can go over 64GB
> for a file no problem. Our biggest backup currently is 130GB all in 1
file.
> So maybe you want to check if this limit can not be raised on the OS
level?

> Also, how long does it take you to backup this 500GB database to tape? How
> is your system connected to the tape storage?

> Thanks.



> > Hi Steve,

> > we have the same problem with a 500GB Database, but no change.
> > What you can do, is to extract the image with db2adutl
> > to disk. But think about the OS limit 64GB for files.

> > When we backup our DB2 with two TSM sessions (we can't take more),
> > we can't extract the image because each file ist 250GB great;-)

> > If anyone has a solution, give it us.

> > Regards, Joachim Mller



> > > Hi Group.

> > > I have a 300GB DB2 (SAP) database that I am trying to move from one
> > > site to another using a redirected restore via TSM.  The new site is
> > > tape constrained until we can move the drives from the old to the new
> > > sites, but we are in testing phase at the moment.

> > > When the restore runs, TSM mounts a tape, restores a small amount of
> > > data and then sits there for a couple of hours  while DB2 formats its
> > > containers.  Once these are formatted the restore proceeds correctly.

> > > Is there any way to pre-format the containers so that the tape mount
> > > is not held unnecessarily, or alternatively to get TSM to let go of
> > > the drive until it is actually needed once again?

> > > Thanks

> > > Steve Harris
> > > AIX and TSM Admin
> > > Queensland Health, Brisbane Australia



Mon, 01 Aug 2005 19:01:35 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Restore with redirect in Shell

2. Redirected Restore Problems

3. Difficulty with redirected restore of tablespace-level backup

4. Redirect Restore on DB2 7 EEE using a backup from DB2 EE

5. Silly Redirected Restore Questions?

6. Redirect Restore?

7. Redirected restore

8. Redirect Restore

9. Redirected restore and schema change...

10. DB2 RESTORE db INTO new_db REDIRECT

11. Redirected restore

12. Problem with redirected restore db2 7.1 and OS/2


 
Powered by phpBB® Forum Software