RE: Dumb DBA mistakes

davidwrote: > - some idio^H^H^person I once trained had LTXHWM and LTXEHWM set too > high and filled their logs. 30 and 40 should be made manadatory. You > can have 32767 logical logs - use more logs. And make them all the > same size. > Tilman disagreed: > I disagree. LTXHWM and LTXEHWM should be set, so that any transaction > that might be executed by you application does not lead ot the case > where the rollback cannot complete as all logs are 100% full. > This can be very much higher than 30 / 40 depending on you > application. Besides the DYNAMIC_LOGS in IDS 9.4, there are some occasions where you want to take advantage of all your log space. Our system is mixed OLTP with some DSS activity. As much as I wish we could separate the activities, we cannot. Sometimes, when we have major loads, we want to be able to use all of the log space available. Up go LTXHWM & LTXEHWM. Of course, if the DBA is not careful, you get into a long transaction and are hung. That is bad, but is it "dumb"? "Dumb" is pretty subjective, when one DBA's tuning disaster is another DBA's tuning necessity. When I worked for Informix support, we would keep track of the "stupid user trick of the week". This we reserved for folks like the customer who opened a case to ask how to spell oninit. Sincerely, Christopher Coleman Steering Committee President Kansas City Informix Users Group http://www.iiug.org/kciug Database Analyst Pharmacy Division Mediware Information Systems, Inc.