Re: Long Transaction

From: "Agnes Ng" <agnesng@pc.jaring.my> > > Recently i do face a long of Long Transaction problem and cause the >whole database engine hang there until we kill certain process to release >it. below are my configuration for my IDS 7.3 UC5 which running on Sun >Solaris 2.6 and my onstat -d output. any help would appreciate. ># Logical Log Configuration > >LOGFILES 100 # Number of logical log files >LOGSIZE 500 # Logical log size (Kbytes)>#LOGFILES 100 # Number of logical log files >#LOGSIZE 5000 # Logical log size (Kbytes) Whoa, mamma! Why such small logical log files? You need to add more log files, but I would rather reinitialise and make my logs bigger. Like, say, 5000...or even bigger, seeing as you have such a large llogdbs. >------------------------------------------- >onstat -d output> > > >Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 1 days >19:08:50 -- 1587776 Kbytes > >Dbspaces >address number flags fchunk nchunks flags owner name >56ece150 1 1 1 1 N informix rootdbs >56ecf670 2 1 2 1 N informix llogdbs >56ecf730 3 1 3 1 N informix tempdbs >56ecf7f0 4 1 4 10 N informix datdbs >56ecf8b0 5 1 14 5 N informix dwdbs >56ecf970 6 1 18 1 N informix cycdbs > 6 active, 2047 maximum > >Chunks >address chk/dbs offset size free bpages flags pathname >56ece210 1 1 0 500000 370300 PO- >/dev/rawlinks/rootdb01 >56ece6b0 2 2 0 1048575 48522 PO- >/dev/rawlinks/llogdb01 >56ece790 3 3 0 1048575 1029796 PO- >/dev/rawlinks/tempdb01 >56ece870 4 4 0 1048575 58 PO- >/dev/rawlinks/datdb01 >56ece950 5 4 0 1048575 11 PO- >/dev/rawlinks/datdb02 >56ecea30 6 4 0 1048575 5 PO- >/dev/rawlinks/datdb03 >56eceb10 7 4 0 1048575 1 PO- >/dev/rawlinks/datdb04 >56ecebf0 8 4 0 1048575 7931 PO- >/dev/rawlinks/datdb05 >56ececd0 9 4 0 1048575 126 PO- >/dev/rawlinks/datdb06 >56ecedb0 10 4 0 1048575 22 PO- >/dev/rawlinks/datdb07 >56ecee90 11 4 0 1048575 416 PO- >/dev/rawlinks/datdb08 >56ecef70 12 4 0 1048575 7371 PO- >/dev/rawlinks/datdb09 >56ecf050 13 4 0 1048575 516669 PO- >/dev/rawlinks/datdb10 >56ecf130 14 5 0 1048575 94679 PO- >/dev/rawlinks/dwdb01 >56ecf210 15 5 0 1048575 129626 PO- >/dev/rawlinks/dwdb02 >56ecf2f0 16 5 0 1048575 64945 PO- >/dev/rawlinks/dwdb03 >56ecf3d0 17 5 0 1048575 547359 PO- >/dev/rawlinks/dwdb04 >56ecf4b0 18 6 0 1048575 965981 PO- >/dev/rawlinks/cycdb01 >56ecf590 19 5 0 1048575 722195 PO- >/dev/rawlinks/dwdb05 > 19 active, 2047 maximum > > > > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com