Size, Number, and Location of Logical Logs

When either IDS or OnLine is first installed, all logfiles are in the root dbspace. The OnLine engine defaults to three logfiles, so unless changes are made in the tb/onconfig file, you will start out with three logfiles in your root dbspace. The IDS engine creates six logfiles by default. Version 7.30 creates 10. Informix does not allow you to change the size of the logfiles, although it does allow you to change the number and location of the logfiles. In OnLine systems all logfiles will be the same size.

IDS systems give the DBA the option of specifying the size of each logfile at the time of creation. In these systems, the logfiles can be of different sizes. The big advantage to this LOGSIZE parameter ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.