ADSM-L

Re: DB2 restore takes long

2002-08-15 04:22:16
Subject: Re: DB2 restore takes long
From: MUSTAFA BAYTAR <mustafa.baytar AT EFESPILSEN.COM DOT TR>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 15 Aug 2002 11:17:37 +0300
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

<Prev in Thread] Current Thread [Next in Thread>