Re: Informix Log File?

Hello, what I must to say, your client have to either read books or attend Online Adminitration course. Understanding of logical logs is a must. Logical logs are not normal files but internal server' objects. They can become full if either they are not backed up or long transaction failed to roll back. To "back up" log automatically you may specify "/dev/null" as a tape device for log backup (parameter LTAPEDEV) To prevent failed long transaction roll-back keep total logical log space large enough. Ones again, read the book. Sincerely yours, Sergei Melikhov Arnold Noche wrote: > > I can only provide limited information since I'm presently not on-site. > > My client is using Informix 7.x as the underlying database for Remedy AR > System 2.13. > > Client receives "Informix Log File Full" which prevents him from going > any further with the Remedy AR System. > > Client would like to know how to clear this *.log file as needed, using > Informix's Utilities, to resume business as usual. > > I was not successful in walking him how to clear it manually if there was > ever such a way in Informix. I recall that Informix has it's own set of > tools and utilities to use. > > TIA, > Arnold A. Noche > aan@ssds.com