Re: DB2 restore takes long
2002-08-15 04:22:16
Hi Lindy ,
We have SAP R3 4.B with DB2 database running on aix 4.3.3 and
we had similar problem about 1.5 years ago.
our db2 size was 120 GB and when we started database restore its took nearly
12 hours to create
db2 conteiners and 4 hours to restore them.
after that we have moved filesystem conteiners to rowdevices conteiners and
distrubute them over
diferent disks .
now our db2 size is 420 GB and restore take approximately 4 hours.
"Crawford,
Lindy" To: ADSM-L AT VM.MARIST DOT
EDU
<lcrawford@BOECO cc: (bcc: MUSTAFA
BAYTAR/BILSIS/ANADOLU)
RP.CO.ZA> Subject: DB2 restore takes long
Sent by: "ADSM:
Dist Stor
Manager"
<[email protected]
T.EDU>
15.08.2002 10:26
Please respond
to "ADSM: Dist
Stor Manager"
Hi TSMers,
Could some please assist me. I did a restore yesterday, started it 8:13am
and it only completed at 21:04 pm. This for the environment that we work
with it is unacceptable in terms of response. My client - node is as
follows:_
TSM 4.2
DB2 7.2
SAP R3 4.6c
Database size is : 48gigs
What can I do to make this process faster. The reason why I am concerned is
that my backup only takes 1h30mins, so the most time it took I would have
expected it to be 2 or 3hours.
Please help....!!!
> Lindy Crawford
> Business Solutions: IT
> BoE Corporate
>
> * +27-31-3642185
<<...OLE_Obj...>> +27-31-3642946
lcrawford AT boecorp.co DOT za <mailto:lcrawford AT boecorp.co DOT za>
WARNING:
Any unauthorised use or interception of this email is illegal. If this email
is not intended for you, you may not copy, distribute nor disclose the
contents to anyone. Save for bona fide company matters, BoE Ltd does not
accept any responsibility for the opinions expressed in this email.
For further details please see: http://www.boe.co.za/emaildisclaimer.htm
|
|
|