Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome
1999-11-22 16:50:54
Subject: |
Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome |
From: |
Tony Rynan <tonyr AT AU1.IBM DOT COM> |
Date: |
Tue, 23 Nov 1999 08:50:54 +1100 |
Hi Francis,
I had the same unfortunate occurence recently and have decided to make the
log size 5.2GB leaving room for an emergency extension of up to 200MB.
It's a waste of useful log space but means recovery takes minutes instead
of 15 hours.
regards Tonyr
"MAES, FRANCIS" <francis.maes AT FORTISBANK DOT COM> on 23/11/99 00:09:56
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: Tony Rynan/Australia/IBM)
Subject: Help: ANY HINTS TO SPEED UP LOADDB are welcome
Hello,
Due to a server cancel during a DB BACKUP with a RECLOG FULL and at maximum
size (5.4GB), it is impossible to restart the server, impossible to extend
the RECLOG.
The only way I've found is to DUMP, FORMAT and LOADDB the DB.
The duration of the DUMP DB was about 6 hours for 428.632.091 DB entries
and
30497 MB copied (DB size 60GB).
The FORMAT was quick but the LOADDB is VERY VERY SLOW!!
About 10 times slower as the DUMP DB. This means an elapsed time of about
60
hours !!!!!
Any ideas to speed up this process are welcome.
Best regards
Francis
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Help: ANY HINTS TO SPEED UP LOADDB are welcome, MAES, FRANCIS
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, Richard Sims
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, Andreas Buser
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, Angela Hopkins
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, Steven P Roder
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome,
Tony Rynan <=
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, MAES, FRANCIS
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, MAES, FRANCIS
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, MAES, FRANCIS
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, Reinhard Mersch
- Re: Help: ANY HINTS TO SPEED UP LOADDB are welcome, MAES, FRANCIS
|
|
|