Re: Logical Log Configuration

onmonitor, Add-Log option in the Parameters menu allows you to add logical logs to server. as for command line, take a look at onparams -a -d <dbspace name where the log will be created> -s <size> for more detail info, refer to informix online document - System administration regards --- "Ing.Germ'n Garc'a Ibarra" <german.garcia@tmn.com.mx> wrote: > How can I add logical logs in informix 7.24 using > onmonitor and on archieve???, > I'm using digital unix 4.0g > > Thanks in advance > > Doug McAllister wrote: > > > 1st Anyone with the name McAllister can't be > all bad. > > > > 2nd Get your logs out of the rootdbs and into > their own dbspace > > > > 3rd You can do a number of things. Add more > logs (I use 20 of 5000 for my > > mix but that is purely a function of your own > application), you can change the > > load to do shorter transactions, or you can change> the LTXHWM parameter in the > > onconfig file. This parm is defaulted to 50%, but > you can adjust that up if > > this is the only transaction that is running. > > > > Doug McAllister > > Fidelity Investments > > > > david.mcallister@soi.co.uk wrote: > > > > > Good Evening (well it is here in Scotland), > > > > > > I have a query regarding the size and number of > logical logs. Until > > > lately, we had around 80 users logging into our > informix database and > > > running various reports, updates etc. > Unfortunately (?) we no longer have > > > the same amount of users but we still require to > maintain the database, and > > > indeed, we need to update the database on a > nightly basis from our legacy > > > systems. > > > > > > For the last year or so a nightly cron job > uploaded a comma delimited file > > > containing around 6000 entries. This however in > the last month has > > > increased to around 20000 entries and is causing > long transactions in the > > > upload. > > > > > > So, the question is, what should I set the size > and number of logical logs > > > to ? > > > > > > Currently I have 24 logical logs each of size > 2000. The logical logs sit > > > in raw disk out of the rootdb space. > > > > > > onstat -d > > > INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- > Up 3 days 01:24:05 --> > > 138808 Kbytes > > > Dbspaces > > > address number flags fchunk nchunks > flags owner name > > > c036100 1 1 1 > 1 N > > > informix rootdbs > > > c036978 2 1 2 > 1 N > > > informix inflogs > > > Chunks > > > address chk/dbs offset size free > bpages flags pathname > > > c036170 1 1 0 50000 > 48913 > > > PO- /dev/vx/rdsk/datadg/rootspac > > > c0362b8 2 2 0 1005109 > 947056 PO- > > > /dev/vx/rdsk/datadg/vol02 > > > > > > Regards > > > > > > David M MacAllister > > > Securicor Omega International > > -- > +++++++++++++++++++++++++++++++++++++++++++++++++++++ > Ing. Germ'n Garc'a Ibarra > Systems Specialist > > Telecommunications Management Solutions, S.A. de > C.V. > Herschel 131. Col. Anzures. C.P.11590. > M'xico, D.F. - M'xico > Tel. +52 5263 1780 > Fax +52 5203 8954 > > email: German.Garcia@tmn.com.mx > ++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > ===== __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com