PHISICAL LOGS configuration

Posted in 1996

"Mauro G. Pisano" — 23 Dec 1996 10:53:30 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi: I am tryin to improve perfomance in our environment. We have On-line 5.0. The On-line Administrator Guide recommends to define the phisical logs size twice the logical logs size. Other rule is to define both size with a relation 3:1 logical logs vs phisical logs. If I follow this I always have six logical logs. I have 5 GB of disk space for Informix. 1 GB is for the root dbspace and the other 4 GB. for the others chunks. Here are my questions : 1. Is the disk space well managed ? 2. wich is the On-line's space, is all the space or only the root dbspace's space ? 3.shoul I prefer few and large logical logs or many and small ones ? Thanks very match in advance for your help. @@@@ @@@@@@@@@ Mauro G. Pisano @@@ @@@ @@@ @ Analista Programador. @@@ @ @@@@@@@@@ Direcc. Gral. de Cultura y Educaci'n. @@@ @@@ - Liquidacion de Sueldos Transferidos/EGB - @@@ @@@ Email: mpisano@ed.gba.gov.ar