Re: Avoiding holding a tape during a DB2 Redirected restore

[Tudor,Troy,VEVEY,GL-IS/IT]

Hi

We experience the SAP problem except I don't believe TSM 'holds' the drive.

DB2 will read backup header from tape
DB2 then creates containers as required.
While the containers are being created, TSM waits for the client to return.
The tape is unmounted after a timeout period.
When containers are created, TSM remounts tape.


Cheers
> Troy Tudor
> my SAP support - Design and Construction
> Information Systems
> GLOBE - Global Business Excellence
> *+41 (21) 924 7083   * CLA 308
> E-mail address:[EMAIL PROTECTED]
> Our link: http://globe.nestec.ch/GLOBE
>


-Original Message-
From: Steve Harris [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2003 07:37
To: [EMAIL PROTECTED]
Subject: Avoiding holding a tape during a DB2 Redirected restore


Hi Group.

I have a 300GB DB2 (SAP) database that I am trying to move from one site to
another using a DB2 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



**
This e-mail, including any attachments sent with it, is confidential
and for the sole use of the intended recipient(s). This confidentiality
is not waived or lost if you receive it and you are not the intended
recipient(s), or if it is transmitted/ received in error.

Any unauthorised use, alteration, disclosure, distribution or review
of this e-mail is prohibited.  It may be subject to a statutory duty of
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this
e-mail in error, you are asked to immediately notify the sender by
telephone or by return e-mail.  You should also delete this e-mail
message and destroy any hard copies produced.
**

Avoiding holding a tape during a DB2 Redirected restore

[Steve Harris]

Hi Group.

I have a 300GB DB2 (SAP) database that I am trying to move from one site to another 
using a DB2 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 



**
This e-mail, including any attachments sent with it, is confidential 
and for the sole use of the intended recipient(s). This confidentiality 
is not waived or lost if you receive it and you are not the intended 
recipient(s), or if it is transmitted/ received in error.  

Any unauthorised use, alteration, disclosure, distribution or review 
of this e-mail is prohibited.  It may be subject to a statutory duty of 
confidentiality if it relates to health service matters.

If you are not the intended recipient(s), or if you have received this 
e-mail in error, you are asked to immediately notify the sender by 
telephone or by return e-mail.  You should also delete this e-mail 
message and destroy any hard copies produced.
**