Re: Log files in Online 5.x
Why so much log space? Recommendation is for physical and logical log is
20% of your total configuration disk space. With a 3:1 ratio between the
logical and physical log space. If this is not correct (or if many of you
have found not to work), plese let me know.
Thanks!!!!
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
OR
cherylk@spamis.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Thu, 18 Apr 1996, Mickey Mestel wrote:
} dave,
}
} > Can anybody tell me an easier method for changing th logfile size on
} > I-Online 5.x than unloading the whole database and reloading it with a
} > new size? When we went through and redesigned the dbspaces and table
} > distribution, we brought the system back up with very small log files.
} > This is killing us with long transaction aborts. Can anybody help?
} > Thanks,
}
} in 5.X there is nothing you can do about this, short of unloading
} and loading. but why not up LOGSMAX, and just add a bunch more log files?
} give them their own dbspace as well. the size of the log file doesn't
} *really* matter, (it does, in terms of how much transaction data is there
} that isn't logged to tape, etc...), but as far as transaction aborts, it's
} the number of files that you have.
}
} we have 7.11 running in an environment with ~70 sessions at a time,
} running mostly oltp and some dss. i have 60 log files, 1000k each, sitting
} in 2 dbspaces. the first dbspace has all the odd numbered logs, and the second
} all the even. this way there is less disk contention, as ontape reads the
} disk to back up the previously written log, the system is accessing another
} disk to write the current log.
}
} hope this helps.
}
} mickm
}