Re: How to size the logical log ?

In article <6gdono$8f1$1@news.xmission.com>, Timothy_Lam@crow.bmc.com wrote: > > > Hello Guys, > > Does anybody know how to calculate the size of the logical logs ? > > What does the logical log size based upon ? What are the factors ? > > I want to backup the logical logs very often to avoid disaster. > > How does informix backup logical logs ? > > Rdgs > Timothy > > Hi Timothy, i can give you following inproved facts for an Online 5.xx-Server: Space of your data in the dbase * 20% = logspace in logdbs. Physlog 2xsize of logical log. e.g. 1.000.000 kB * 20% = 200.000 kB Logspace. ==> 20 Logs + 2 Logs for Physical Logging = 22 (divisor) ==> 200.000 kb / 22 = 9090 kB for 1 Logfile --> rounded to: 10.000 kB Physical Log 2 x 10.000 kB. Result: 20 Logfiles with 10.000 kB and a physical log with 20.000 kB. Please remember that the dbase needs administative space for every chunk/dbs. Size of logdbs ~ 220.000 kb, Size of physdbs ~ 25.000 kb. For a good performance logdbs, physdbs, rootdbs and datadbs should be placed on seperate hdd's and seperate controllers. Rootdbs, physdbs and logdbs should be created first. Please use continuous backup! Logs are backed up, if they are full and all transactions in this backed-up log closed. Otherwise the log will not cleaned. Hope, that helps you. Andy Bettin -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading