RE: Swap Space on DEC ALPHA with 7.30FC10 Engine

Questions are: Is the server swapping or is the swap space just allocated? Is the database set to resident ? Does "vmstat -S 5" show swapping or not? Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Porcello, John [mailto:jep-corp@kaman.com] Sent: Wednesday, February 07, 2001 4:13 PM To: Informix (E-mail) Subject: Swap Space on DEC ALPHA with 7.30FC10 Engine We are attempting to keep our engine running on a DEC Alpha with Compaq Unix 4.0G for a week without bouncing it. We have found that after about three days, our swap space starts getting utilized to the point that we need to bounce the engine. Once the engine is bounced, all swap space returns and we're good for another three days. This server is a Primary in a HDR pair, the Secondary server, doesn't seem to have the issue. This server usually has about 350 to 400 VERY active sessions running in an OLTP environment. Any ideas would be greatly appreciated. Thanks, John John E. Porcello, Jr., ICP, MCSE Corporate DBA Kaman Corporation jep-corp@kaman.com My views and opinions may not reflect those of Kaman Corporation. onstat -g glo Informix Dynamic Server Version 7.30.FC10 -- On-Line (Prim) -- Up 2 days 11:00:21 -- 856384 Kbytes MT global info: sessions threads vps lngspins 328 382 10 6 sched calls thread switches yield 0 yield n yield forever total: 75571941 70081417 8018129 279769 29537656 per sec: 5199 4120 1584 143 1948 Virtual processor summary: class vps usercpu syscpu total cpu 4 18252.63 6517.08 24769.72 aio 2 11.53 31.35 42.88 lio 1 0.87 2.62 3.48 pio 1 1.00 3.43 4.43 adm 1 0.35 0.75 1.10 msc 1 21.70 32.47 54.17 total 10 18288.08 6587.70 24875.78 Individual virtual processors: vp pid class usercpu syscpu total 1 8817 cpu 4846.83 1771.32 6618.15 2 8819 adm 0.35 0.75 1.10 3 8809 cpu 4749.85 1674.17 6424.02 4 8808 cpu 4535.37 1606.83 6142.20 5 8823 cpu 4120.58 1464.77 5585.35 6 8810 lio 0.87 2.62 3.48 7 8806 pio 1.00 3.43 4.43 8 8820 aio 8.23 16.85 25.08 9 8825 msc 21.70 32.47 54.17 10 8824 aio 3.30 14.50 17.80 tot 18288.08 6587.70 24875.78 ps aux | grep oninit USER PID %CPU %MEM VSZ RSS TTY S STARTED TIME COMMAND root 8809 41.7 33.9 849M 693M ?? S Feb 05 09:35:59 oninit root 8817 30.9 34.6 849M 708M ?? R Feb 05 09:00:25 oninit root 8823 30.7 33.8 849M 692M ?? S Feb 05 08:12:22 oninit root 8808 28.5 33.8 849M 692M ?? R Feb 05 09:08:03 oninit root 8825 0.6 0.5 849M 10M ?? S Feb 05 3:15.08 oninit root 8820 0.2 0.2 849M 4.9M ?? S Feb 05 1:31.91 oninit root 8824 0.1 0.1 849M 2.6M ?? S Feb 05 1:04.13 oninit root 8810 0.0 0.0 849M 320K ?? S Feb 05 0:13.06 oninit root 8806 0.0 0.0 849M 336K ?? S Feb 05 0:16.89 oninit root 8819 0.0 0.4 849M 7.9M ?? S Feb 05 0:07.14 oninit root 24818 0.0 0.0 1.66M 184K ttyp3 S + 16:00:34 0:00.01 grep oninit onstat -g seg Informix Dynamic Server Version 7.30.FC10 -- On-Line (Prim) -- Up 2 days 10:57:23 -- 856384 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 2049 1381386241 200000000 130351104 2888 R 15904 8 2050 1381386242 207c50000 746586112 11896 V 67828 23308 Total: - - 876937216 - - 83732 23316 swapon -s Swap partition /dev/rz8b: Allocated space: 64655 pages (505MB) In-use space: 5148 pages ( 7%) Free space: 59507 pages ( 92%) Total swap allocation: Allocated space: 64655 pages (505MB) In-use space: 5148 pages ( 7%) Available space: 59507 pages ( 92%)