Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Resident memory size vs. Virtual memory size

Posted By: FRANK
Date: Thursday, 10 January 2013, at 12:40 p.m.

In Response To: Re: Resident memory size vs. Virtual memory size (Fernando Nunes)

The following is the output of onstat -g mem, it sounds pool: dictpool has
a excessive virtual memory consumption ( around 3GB?),

dictpool V 13f5bc040 3083149312 22008
1505143 12

Any idea why " dictpool" is such a big consumer of Virtual segments?

Thanks,
Frank

[informix@maggie ~]$ onstat -g mem
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 42 days
19:52:04 -- 8130128 Kbytes
Pool Summary:
name class addr totalsize freesize
#allocfrag #freefrag
CDRGeval8 V 140e89040 147456 26776
92 18
CDRD_40754 V 22ef87040 159744 40584
197 40
CDRD_40763 V 22f947040 159744 43480
183 42
CDRD_40772 V 22fcc4040 135168 34736
178 38
afpool V 13e270040 307200 246576
118 108
tpcpool V 13f5c6040 98304 7912
88 7
grprUpLinks V 140471040 4096 808
1 1
CDRGeval9 V 140eef040 147456 27688
91 18
CDRD_40764 V 22f359040 155648 36664
197 38
CDRD_40773 V 22e434040 159744 43408
183 40
CDRD_40765 V 22f92a040 159744 40568
197 44
seqpool V 13f602040 4096 736
2 1
CDRD_40757 V 22e75b040 159744 40184
203 39
pnlpool V 13f5c9040 90112 3288
82 3
grouper V 14046f040 5791744 2417656
40423 4556
CDRD_40758 V 230e7c040 155648 36272
199 40
sbtlist V 13e617040 20480 7200
4 3
sqcrypto V 13ec84040 4096 464
2 1
dstpool V 13f5c5040 2027520 175528
1723 108
CDRD_40768 V 22ec07040 159744 40760
197 42
CDRGtx23320 V 22c680040 4096 808
1 1
CDRD_40769 V 2285af040 159744 43424
183 39
ampool V 13f5f8040 8192 3464
17 1
shmcon M 21028a040 1085440 4864
2 2
main_loop() V 13f882040 352256 17968
64 22
sb_delundoq V 13e649040 49152 8752
4 3
XTF_mem V 13f659040 716800 6632
4 3
61*O0 V 14313f040 4096 808
1 1
6103734*O0 V 1a0fa2040 4096 808
1 1
22700700 V 223ec1040 155648 52248
246 34
EXE.37.91 V 22d942040 4096 616
4 1
EXE.37.91 V 22bda9040 4096 680
3 1
EXE.37.91 V 22a441040 12288 3584
57 1
37*O0 V 14055d040 4096 808
1 1
22700701 V 223e5a040 159744 57272
236 37
38*O0 V 14328f040 4096 808
1 1
22700702 V 222a82040 155648 52416
246 38
22815110 V 22a6f9040 196608 45184
246 35
EXE.38.92 V 22a378040 4096 744
2 1
EXE.38.92 V 22b937040 4096 680
3 1
EXE.38.92 V 22cb41040 4096 544
5 1
EXE.38.92 V 22ff36040 4096 360
8 1
39*O0 V 142416040 4096 808
1 1
bf_prioswee V 1424b3040 28672 3104
13 3
22700703 V 2242ff040 143360 45544
234 34
CDRGtx23398 V 22df70040 4096 808
1 1
16020616 V 1dd217040 102400 25008
113 20
22700704 V 222476040 139264 42016
229 39
EXE.39.93 V 22ac27040 4096 680
3 1
EXE.39.93 V 227f7c040 4096 744
2 1
EXE.39.93 V 229f58040 4096 544
5 1
EXE.39.93 V 22ecf0040 4096 360
8 1
6103659*O0 V 1a18dc040 4096 808
1 1
22700705 V 222784040 151552 54352
229 42
20580270 V 19fcf8040 98304 21072
113 19
22700670 V 14813a040 159744 55704
256 40
22700706 V 223d60040 139264 41736
234 34
18506302 V 1e5b1f040 12288 416
16 1
22700671 V 211e70040 167936 65008
241 38
22700680 V 14d372040 151552 48016
251 36
22700707 V 22482a040 118784 33152
174 28
22700672 V 212b1e040 151552 37944
259 24
22700681 V 2131b5040 163840 60440
251 36
SES.37.91 V 1405ba040 8192 3736
3 2
3546871*O0 V 1776e7040 4096 808
1 1
16023834 V 1f7da1040 98304 21072
113 19
22523076 V 22828a040 151552 62528
146 38
22664016 V 22974d040 12288 416
16 1
22700682 V 217aea040 155648 52064
251 36
22700718 V 2268e6040 143360 45528
234 33
22731363 V 22bfca040 258048 138360
294 71
22815036 V 22aed5040 196608 51008
247 36
3546881*O0 V 1521f7040 4096 808
1 1
22700683 V 218703040 147456 49872
234 36
22815118 V 22cfa5040 196608 51968
247 35
SES.38.92 V 1425d0040 8192 3736
3 2
4076658*O0 V 182c5b040 4096 808
1 1
4076766*O0 V 17895f040 4096 808
1 1
20580734 V 19d820040 98304 21040
113 18
22700684 V 219f76040 151552 53816
234 40
22849211 V 22e0ce040 196608 51968
247 35
3546874*O0 V 174dba040 4096 808
1 1
3546883*O0 V 184ac8040 4096 808
1 1
3546892*O0 V 179a4a040 4096 808
1 1
22700685 V 21c60c040 143360 45472
234 38
userlbacpoo V 13f5cd040 8192 3288
2 2
SES.39.93 V 142b8f040 8192 3736
3 2
3546875*O0 V 1784dd040 4096 808
1 1
9645923*O0 V 1dc2dc040 4096 808
1 1
22700686 V 21e362040 147456 49320
239 37
22815832 V 22c60c040 102400 33088
124 19
22875106 V 22edf4040 233472 68624
369 54
22887211 V 22feaa040 126976 33608
200 36
22887310 V 194d09040 126976 40320
171 36
3546876*O0 V 191bf0040 4096 808
1 1
3546885*O0 V 179048040 4096 808
1 1
19460453 V 1b1400040 192512 46600
246 36
22700687 V 21f684040 139264 41488
234 33
22887311 V 22dd82040 122880 35840
172 34
22695612 V 22b1f5040 274432 153072
314 73
22764516 V 228c0e040 204800 53120
247 37
22884351 V 230307040 196608 51968
247 35
22887303 V 22fc07040 135168 48416
172 38
22887312 V 22eea2040 126976 39888
172 39
22887510 V 22751d040 200704 81712
247 44
PRP.37.91 V 140556040 4096 408
3 1
16657090 V 1c9f79040 98304 20992
113 19
22843807 V 22c55b040 249856 44192
356 37
22868242 V 22ff7d040 229376 64304
369 57
22880464 V 231c4d040 122880 40112
126 34
22881058 V 2300e1040 114688 34704
122 30
22883182 V 22fe6f040 192512 47952
246 40
22886107 V 22f6f6040 106496 17784
154 20
22887313 V 22b1ae040 122880 35920
172 31
22700699 V 21e5e9040 155648 52472
246 35
22841558 V 22faec040 114688 30912
142 23
22883174 V 231054040 196608 51968
247 35
22885163 V 22fa37040 172032 34888
283 40
22887314 V 22fe90040 122880 35840
172 33
PRP.38.92 V 14039d040 4096 408
3 1
CDRRTBClean V 141c57040 118784 31000
87 17
22815099 V 22d31a040 196608 50368
247 36
22883535 V 22f3a7040 98304 21576
109 17
22884336 V 22b7c8040 196608 50368
247 36
22885038 V 22ee96040 184320 79288
210 48
22885164 V 229212040 241664 111112
303 56
22887315 V 22ad40040 126976 39952
172 36
22887405 V 22e111040 192512 73640
247 43
22887423 V 22e9f9040 167936 54528
214 43
22808764 V 22fd2a040 270336 149848
299 76
22876138 V 22f6dc040 102400 30488
144 22
22885255 V 22f557040 106496 17856
154 20
22887253 V 22d9d4040 126976 33952
200 36
22887316 V 22c2b7040 122880 35824
172 29
22887415 V 2298bd040 135168 47392
177 37
PRP.39.93 V 1403c9040 4096 408
3 1
22866581 V 22c957040 106496 29272
114 21
22883483 V 22e286040 167936 30872
283 39
22885256 V 2289f3040 167936 30968
283 34
22887173 V 23010a040 131072 37896
200 35
22887317 V 22f347040 122880 35792
172 32
22887425 V 22fae2040 143360 48432
213 48
17683365 V 1b2b10040 307200 45880
324 45
22883169 V 22c030040 196608 50368
247 36
22887246 V 22e331040 131072 37928
200 37
22887318 V 22e77d040 126976 40696
170 34
22796950 V 22c2d1040 147456 52032
199 45
22887292 V 22ef95040 167936 54264
214 51
cdrRQM V 14081d040 962560 309464
197 112
CDRGeval10 V 140f56040 147456 26992
91 18
11828786 V 20618a040 86016 6472
81 11
22780778 V 22d122040 204800 53008
247 38
22885088 V 228a72040 106496 19800
152 20
22885277 V 23026b040 172032 34896
283 39
22887284 V 22f3fe040 167936 54248
214 52
CDRGeval11 V 140fbc040 147456 26984
91 20
22868727 V 22fce7040 159744 71672
135 38
22887276 V 22d147040 122880 29928
200 35
22887285 V 22b660040 167936 54272
214 49
22887762 V 228594040 12288 416
16 1
onmode_mon V 140280040 28672 3104
13 3
CDRGeval12 V 141022040 147456 29320
85 18
sblo per-st V 156484040 12288 864
6 2
sblo per-st V 154619040 12288 992
5 2
sblo per-st V 1543ad040 12288 992
5 2
sblo per-st V 154b46040 12288 864
6 2
sblo per-st V 1527ef040 12288 864
6 2
sblo per-st V 15255e040 12288 992
5 2
sblo per-st V 154ec5040 12288 992
5 2
sblo per-st V 204909040 12288 864
6 2
sblo per-st V 2039fd040 12288 608
8 2
sblo per-st V 2039ea040 12288 992
5 2
sblo per-st V 1f8638040 12288 992
5 2
22885288 V 22f034040 102400 29904
139 23
22887655 V 22ce95040 147456 45712
219 38
22887709 V 22c845040 155648 54016
219 44
22887754 V 2269b4040 106496 32512
147 26
CDRGeval13 V 141089040 147456 27032
91 19
22797476 V 22d5fc040 131072 42040
169 33
22885289 V 22fffc040 167936 30824
283 37
22887566 V 22876e040 155648 53344
221 43
22884669 V 22db42040 12288 416
16 1
lgflushpool V 140021040 8192 3320
9 2
22887758 V 2265fb040 147456 45776
219 38
2 V 13f905040 12288 416
16 1
rsam V 13e6ec040 501370880 1412480
16386 570
sscpool0 V 13f5bb040 12288 1024
2 2
3 V 13f961040 12288 416
16 1
4 V 13f9bd040 12288 416
16 1
compr cache V 13ec82040 8192 4008
8 1
5 V 13fa19040 12288 416
16 1
6 V 13fa75040 12288 416
16 1
7 V 13facf040 16384 2872
22 3
CDRCparse V 1406ec040 1789952 105280
1491 362
CDRACK_0 V 1407ec040 94208 7544
95 10
8 V 13fb35040 16384 2872
22 3
aslogflush V 140063040 28672 3104
13 3
CDRACK_1 V 1407e6040 98304 11512
96 12
aio V 13ec80040 22376448 1578056
3361 758
CDRDTCleane V 140833040 69632 5312
65 5
CDRACK_2 V 147dd9040 94208 7552
95 10
opcinstpool V 13f5c8040 8192 1240
4 2
CDRACK_3 V 14a3ff040 94208 7520
95 10
dbausrpool V 13f609040 8192 2648
18 2
CDRACK_4 V 146134040 94208 7536
95 11
22700700*O0 V 228130040 4096 808
1 1
CDRACK_5 V 149be0040 94208 7552
95 10
22700701*O0 V 226c29040 4096 808
1 1
CDRACK_6 V 147c5a040 94208 7528
95 11
22700702*O0 V 2275f7040 4096 808
1 1
22815110*O0 V 22d790040 4096 808
1 1
22700703*O0 V 227321040 4096 808
1 1
16020616*O0 V 1d7441040 4096 808
1 1
CDRNrA23 V 1c2e89040 98304 3800
105 9
22700704*O0 V 22793a040 4096 808
1 1
22700705*O0 V 226c84040 4096 808
1 1
ddr_snoopy V 141d29040 28672 3040
14 3
20580270*O0 V 19f4f2040 4096 808
1 1
22700670*O0 V 2269ec040 4096 808
1 1
22700706*O0 V 227d0a040 4096 808
1 1
22700671*O0 V 22a0f1040 4096 808
1 1
22700680*O0 V 221c60040 4096 808
1 1
22700707*O0 V 2277bd040 4096 808
1 1
11844161*O0 V 201475040 4096 808
1 1
22700672*O0 V 227f30040 4096 808
1 1
22700681*O0 V 220840040 4096 808
1 1
16023834*O0 V 1cfad3040 4096 808
1 1
22700682*O0 V 2237b1040 4096 808
1 1
22700718*O0 V 22a2b8040 4096 808
1 1
22731363*O0 V 22c794040 4096 808
1 1
22815036*O0 V 22c4fa040 4096 808
1 1
22523076*O0 V 22ecc5040 4096 808
1 1
22700683*O0 V 2237b3040 4096 808
1 1
22815118*O0 V 22e20f040 4096 808
1 1
smartblob V 13e616040 106496 10608
32 23
gls V 13f5b8040 36864 2416
348 4
20580734*O0 V 19ab1a040 4096 808
1 1
22700684*O0 V 2225f0040 4096 808
1 1
22849211*O0 V 22d2f0040 4096 808
1 1
22700685*O0 V 222792040 4096 808
1 1
22700686*O0 V 223173040 4096 808
1 1
22815832*O0 V 22d433040 4096 808
1 1
22875106*O0 V 231cf3040 4096 808
1 1
22887211*O0 V 22dbc6040 4096 808
1 1
22887310*O0 V 22ead0040 4096 808
1 1
19460453*O0 V 1ae20d040 4096 808
1 1
22700687*O0 V 22319e040 4096 808
1 1
22887311*O0 V 22f4c9040 4096 808
1 1
res-buff0 R 5fed8040 2457624576 4864
2 2
policypool V 13f5cc040 8192 3288
2 2
22695612*O0 V 22b7a3040 4096 808
1 1
22764516*O0 V 2286ae040 4096 808
1 1
22884351*O0 V 23007b040 4096 808
1 1
22887303*O0 V 22dafc040 4096 808
1 1
22887312*O0 V 22fc4b040 4096 808
1 1
22887510*O0 V 228a68040 4096 808
1 1
DefConvWrit V 13f655040 16384 2776
102 1
16657090*O0 V 1d66a5040 4096 808
1 1
22843807*O0 V 22df13040 4096 808
1 1
22868242*O0 V 22deb5040 4096 808
1 1
22880464*O0 V 2319ed040 4096 808
1 1
22881058*O0 V 22f7ef040 4096 808
1 1
22883182*O0 V 230906040 4096 808
1 1
22886107*O0 V 22f1fa040 4096 808
1 1
22887313*O0 V 22fe12040 4096 808
1 1
22700699*O0 V 228184040 4096 808
1 1
22841558*O0 V 22ef4f040 4096 808
1 1
22883174*O0 V 2308c8040 4096 808
1 1
22885163*O0 V 22e807040 4096 808
1 1
22887314*O0 V 22f2ed040 4096 808
1 1
res-buff3 R f269e040 1228824576 4864
2 2
proxyWrite V 13e60c040 40960 2976
2 2
sysprocpool V 13f60a040 8192 2960
6 2
22815099*O0 V 22d166040 4096 808
1 1
22883535*O0 V 22fc69040 4096 808
1 1
22884336*O0 V 22fc64040 4096 808
1 1
22885038*O0 V 22ea12040 4096 808
1 1
22885164*O0 V 22f664040 4096 808
1 1
22887315*O0 V 22f7b9040 4096 808
1 1
22887405*O0 V 229d71040 4096 808
1 1
22887423*O0 V 22ab22040 4096 808
1 1
resroutpool V 13f5cb040 45056 2264
39 3
22808764*O0 V 22fd28040 4096 808
1 1
22876138*O0 V 22efb2040 4096 808
1 1
22885255*O0 V 22fd75040 4096 808
1 1
22887253*O0 V 22fd7c040 4096 808
1 1
22887316*O0 V 22fa8c040 4096 808
1 1
22887415*O0 V 22f7f1040 4096 808
1 1
btscanner_0 V 14013e040 94208 18224
38 10
periodic V 140875040 28672 3040
14 3
22866581*O0 V 22fe0a040 4096 808
1 1
22883483*O0 V 22f457040 4096 808
1 1
22885256*O0 V 22e6c1040 4096 808
1 1
22887173*O0 V 22f3fb040 4096 808
1 1
22887317*O0 V 22fefa040 4096 808
1 1
22887425*O0 V 22ecb4040 4096 808
1 1
btscanner_1 V 14021c040 94208 18208
38 10
17683365*O0 V 1afe55040 4096 808
1 1
22883169*O0 V 22ec97040 4096 808
1 1
22887246*O0 V 22fc71040 4096 808
1 1
22887318*O0 V 2301fe040 4096 808
1 1
22796950*O0 V 22f862040 4096 808
1 1
22887292*O0 V 22fa9c040 4096 808
1 1
CDRNsT22 V 1fee18040 102400 18000
97 14
22780778*O0 V 22cbaa040 4096 808
1 1
22885088*O0 V 22cea9040 4096 808
1 1
22885277*O0 V 2301e2040 4096 808
1 1
22887284*O0 V 22f4d5040 4096 808
1 1
22868727*O0 V 22d81a040 4096 808
1 1
22887276*O0 V 22fae1040 4096 808
1 1
22887285*O0 V 230274040 4096 808
1 1
22885288*O0 V 22f795040 4096 808
1 1
22887655*O0 V 22e7d3040 4096 808
1 1
22887709*O0 V 22f403040 4096 808
1 1
22887754*O0 V 228e08040 4096 808
1 1
CDRGfan V 140b00040 90112 7144
75 13
22797476*O0 V 22fbd7040 4096 808
1 1
22885289*O0 V 22f5ff040 4096 808
1 1
22887566*O0 V 230354040 4096 808
1 1
smx V 13f5b3040 16384 1664
10 2
22887758*O0 V 22a044040 4096 808
1 1
CDR V 140680040 2043904 1160688
2803 502
sb_delq V 13e61c040 57344 1792
239 1
DDR V 1415ee040 7602176 2737576
7705 1389
resident R 46eda040 419422208 2816
2 2
dictpool V 13f5bc040 3083149312 22008
1505143 12
mt V 13e271040 20688896 4530280
58321 4417
10 V 13fbdc040 12288 416
16 1
11 V 13fc32040 16384 2872
22 3
13 V 13fcda040 16384 2872
22 3
CDRSchedMgr V 140823040 28672 3040
14 3
6103734 V 1a4d30040 77824 15128
97 11
aggpool V 13f5ca040 8192 3288
2 2
37 V 1402a0040 544768 159536
392 50
grprBlLinks V 140472040 4096 808
1 1
38 V 1402c4040 491520 90208
496 51
39 V 1405e4040 487424 84504
517 57
procpool V 13f5c0040 1032192 11584
1001 21
6103659 V 1a1da7040 98304 4304
147 8
extdpool V 13f603040 8192 1784
9 2
global V 13e25f040 371630080 301234512
13077 3105
3546871 V 1878e5040 98304 21072
113 19
3546881 V 1784dc040 98304 21072
113 19
ctcpool V 13f5c7040 126976 18648
103 12
tmxapool V 13f608040 4096 680
3 1
4076658 V 18d946040 126976 42864
131 37
4076766 V 1741bf040 131072 46920
131 37
3546874 V 179bc0040 98304 21072
113 19
3546883 V 179a50040 98304 21072
113 19
3546892 V 15611c040 98304 21072
113 19
sb_arcspace V 13e6e6040 8192 1448
6 2
3546875 V 18b701040 98304 21072
113 19
9645923 V 1dfde1040 98304 21040
113 18
3546876 V 175ce2040 98304 21072
113 19
3546885 V 1829bc040 98304 21072
113 19
sb_loheader V 13e67b040 282624 6528
413 57
RSS V 13f896040 188416 3768
507 43
rascron V 140506040 1847296 1196152
516 819
CDRGeval0 V 140b65040 147456 27872
90 20
CDRD_40701 V 22f09a040 196608 48216
293 56
inhpool V 13f5fa040 8192 224
51 1
CDRGeval1 V 140bc6040 143360 24448
86 16
CDRGeval2 V 140c28040 147456 27064
91 18
CDRGeval3 V 140c8a040 147456 26752
92 19
CDRM_Monito V 1407ee040 28672 3040
14 3
opcpool V 13f5f9040 8192 1720
34 1
CDRGeval4 V 140cf1040 147456 27040
91 17
CDRD_40714 V 22ec59040 225280 60960
358 69
CDRGeval5 V 140d57040 147456 27176
90 16
CDRNr22 V 20319e040 102400 6728
105 14
CDRD_40706 V 22f97d040 233472 69640
350 75
CDRGeval6 V 140dbd040 147456 26800
92 18
CDRGeval7 V 140e23040 147456 26752
92 18
CDRD_40762 V 22fa61040 155648 39360
183 43
CDRD_40771 V 230248040 135168 34696
178 42
Blkpool Summary:
name class addr size #blks
mt V 13e273a00 14188544 200
global V 13e26d9c8 0 0

On Sat, Jan 5, 2013 at 2:44 PM, Fernando Nunes <domusonline@gmail.com>wrote:

> For the record, "my personal record" means the worst situation I've seen as
> a DBA... It was not caused by me! :)
> But it's really "easy" to happen because Java applications tend to use
> persistent connections, so this kind of situations get more visibility...
>
> As for your personal situation, recent versions would probably avoid
> that... (FULL_DISK_INIT)
>
> On Sat, Jan 5, 2013 at 6:36 PM, rroussey@comcast.net
> <rroussey@comcast.net>wrote:
>
> > We all look back and chuckle at mistakes and discoveries that had us
> > sweating
> > bullets at the time.
> > "My personal record"....... I laughed out loud! I once wiped out an
> entire
> > development instance by not setting the IFX environment correctly.
> >
> > Bob
> >
> > ----- Original Message -----
> > From: "Fernando Nunes" <domusonline@gmail.com>
> > To: ids@iiug.org
> > Sent: Thursday, January 3, 2013 5:17:36 PM
> > Subject: Re: Resident memory size vs. Virtual memory size [29180]
> >
> > Besides the locks... which is a frequent cause until IBM fixes the issue
> > and implements a limit per session, if you use Java in your applications
> > run:
> >
> > onstat -g ses | sort -nk 7
> >
> > and look at the last sessions... memory usage column... I'm mentioning
> > Java, but it can happen with any language... It's just more frequent with
> > Java and persistent sessions... sometimes the programmers miss the point
> of
> > preparing the statement and put the prepare inside the loops (or use
> > methods that implicitly make a prepare).
> > My "personal" record was 1.5GB in a session... But if it gets that far
> > you'll notice a great performance degradation.
> > Anyway, worth the checking....
> >
> > Regards.
> >
> > On Thu, Jan 3, 2013 at 10:02 PM, MARK JALKIEWICZ <
> > mark.jalkiewicz@verizon.net> wrote:
> >
> > > more sessions = more work = more locks = which means more memory needed
> > for
> > > those locks.
> > >
> > > look in the msg log and you should see "dynamically allocating more
> > locks "
> > > (or similiar) if that is the case. But I have to say that 4 gigs is
> alot
> > so
> > > check $ONCONFIG paramater "shmadd" , there may be an extra 0 tacked on
> > the
> > > end. As a FYI every time there is a dynamic allocation of memory it is
> > > recorded in the messags log so you should be able to quickly decipher
> the
> > > circumstance surrounding the dynamic allocation.
> > >
> > > Mark
> > >
> > >
> > >
> > >
> >
> >
> >
>
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --
> > Fernando Nunes
> > Portugal
> >
> > http://informix-technology.blogspot.com
> > My email works... but I don't check it frequently...
> >
> > --20cf307f333ea813fe04d269bab8
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --047d7b66f3c54d5ec904d28fd29d
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf300fb15f04ab7e04d2f2ae7b

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.