Re: physical log space problem

Kai Stuke wrote in message <34e8a2a5.585702@news.detmold.netsurf.de>... >With a recent installation of Informix 7.22 TC 1 on NT 4.0 SP1 I am >experiencing a problem with the physical log space. >When Informix starts up it issues a warning message 'physical log >space 100 is to small, must be number of user threads * 20'. >The Informix manuals tell me about the the same, unfortunately it >doesn't tell me what the unit of those 100 is, is it bytes, KB, MB, >pages? >The database was automatically configured by the installation program >of an application (BaaN IVc), which created a physical log space of >100 MB, and set the onconfig entry PHYSIZE to 100. >I considered that last one wrong and changed it to 100000 but the >warning message remained the same. > >So the question is, what is a reasonable value for a dedicated >physical log space for 25 user threads? > >Kai >home: stuke@iname.com >work: kstuke@systec-ag.de > > Hi there! The same problem happened to me using the instalation wizard provided by Baan/Informix CD-ROM (Informix ODS 7.20 TE1 & BaanIV b2) for NT SP3. But the instalation guide gave us some configuration steps that had to be done after installing the database, before installing Baan. One of those was to move the physical log from 'rootdbspace' to a 'phylogdbspace' and to change the physical log size. As far as I know the BaanIV c / Informix instalation is almost fully automatic and was supose to allow a quick database & Baan software instalation. The default physical log size is a bug (a very serious one) and can cause Informix to stop if the physical log becames completly full. For a 2Gb datadbspace, the recommended value for physical log is 100 Mb (value recommended by Baan!). You can change the physical log size in tree ways: 1 - Using ONMONITOR (if you have it!). 2 - Using the command line 'onparams'. 3 - Changing the PHYSIZE in the ONCONFIG file (the rigth file!). This last options forces you to manualy restart Informix. For manuals, you migth want to take a look on this site: http://www.informix.com/answers/answers/english/ods.htm It gives you access to a lot a usefull information. Best regards! Joao Carvalho joao.s.carvalho@mail.telepac.pt