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