Hi Ian We've made a unload, audit and then a load on this 160GB database.
Didnt take days to complete. The full process took about 40 hours. If we had choosen not to do the audit, the process would have taken about 28 hours. Best Regards Daniel Sparrman ----------------------------------- Daniel Sparrman Chef Utveckling & Drift Exist i Stockholm AB Propellervägen 6B 183 62 TÄBY Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51 Ian Hobbs <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-10-15 06:51 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Re: Splitting apart a Tivoli DB On Thu, 14 Oct 2004 10:58:54 -0500, Stapleton, Mark wrote: The magic # I have seen is about 100GB. Even a 100GB database would take days depending on the hardware if a full DBAUDIT had to be done. I wouldn't want to do that <G>. >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On >Behalf Of Chris Hund >30GB is a little small for such consideration. Properly configured >databases, spread across fast spindles, should perform well at twice the >size. > ... >Mark Stapleton ([EMAIL PROTECTED]) >Berbee Information Networks >Office 262.521.5627 Ian Hobbs [EMAIL PROTECTED] ======================================================= "Never argue with an idiot. They drag you down to their level then beat you with experience." -Dilbert
