Re: change log size

Hi, Chi-fung You can change the size to edit the onconfig file,$ONCONFIG file in the $INFORMIXDIR/etc/ or to do "onmonitor" of command following is the file: ...... # Logical Log Configuration LOGFILES 15 # Number of logical log files LOGSIZE 500 # Logical log size (Kbytes) <-- 500bytes/logical log file ......You can check the size by 'onstat -l' onstat -l is: [:/db/informix {27} ] onstat -l INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 00:00:52 -- 26256 Kbytes physical log Buffer bufused bufsize numpages numwrits pages/io P-1 0 16 0 0 0.00 phybegin physize phypos phyused %used 10003f 5000 1247 0 0.00 logical log: Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 16 1 1 1 1.0 1.0 'ּ' number flags uniqid begin size used %used c35d49f8 1 U---C-L 1 1013c7 2500 2272 90.88 c35d4a14 2 F------ 0 101d8b 2500 0 0.00 c35d4a30 3 F------ 0 10274f 2500 0 0.00 c35d4a4c 4 F------ 0 103113 2500 0 0.00 c35d4a68 5 F------ 0 103ad7 2500 0 0.00 c35d4a84 6 F------ 0 10449b 2500 0 0.00 <-- # of pages OR You can use the onmonitor . onmonitor -> parameters ->initialize ->disk parameters's Log. Log Size field LAM Chi-fung wrote: > Hello, I would like to ask how can I change the log size of Informix ? > (point me which manual to read is o.k. :> ) > Since I perform a lot of search, comparing and the log 'full' very > quick. I don't want to do 'ontape -a' in the middle of my job. (Our DBA > is out town so I don't have anyone to ask) Thanks a lot. > > Regds > LAM Chi-fung