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
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

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

IDS Forum

RE: RE: RE: Informix 12.1 Blocking Checkpoints

Posted By: Luis Filipe Silvestre Marques
Date: Tuesday, 7 November 2017, at 11:10 a.m.

In Response To: Re: RE: RE: Informix 12.1 Blocking Checkpoints (NATYURAL HORACIO)

IO rate during the long checkpoints seems to be much lower (long checkpoints are not even the ones with the most dirty buffers).

What is the configuration value of the BUFFERPOOL ?
What is the configuration value of the CLEANERS ?
What is the configuration value of PHYSFILE ?
What is the configuration value of LOGFILES and LOGSIZE ?

What is the output of "onstat -F" ?
What is the output of "onstat -R" ?
And finally, the output of "onstat -g ioh", but it can be very verbose, so maybe just check if around the time of the longest timestamps there are any chunks with slower IO rates.

Luis Marques

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NATYURAL HORACIO
Sent: terça-feira, 7 de novembro de 2017 10:48
To: ids@iiug.org
Subject: Re: RE: RE: Informix 12.1 Blocking Checkpoints [40158]

Hi,

Here it is :

AUTO_CKPTS=On RTO_SERVER_RESTART=Off

Critical Sections Physical Log Logical Log

Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec
1027271 15:58:17 CKPTINTVL 1477179:0x7de2018 20.7 17.7 0.0 18 0.0 1.2 2.5
34765 1961 6889 22 19702 64
1027272 16:04:14 CKPTINTVL 1477180:0x28ca018 46.3 44.5 0.0 7 0.0 0.9 1.3 19817
445 6706 20 20341 61
1027273 16:08:48 CKPTINTVL 1477180:0x75242e0 4.4 3.6 0.0 6 0.0 0.3 0.7 14482
4069 7140 22 19877 63
1027274 16:13:53 CKPTINTVL 1477180:0xc44d018 5.8 5.0 0.0 7 0.0 0.4 0.5 16719
3321 7465 24 20571 67
1027275 16:19:38 CKPTINTVL 1477181:0x3392018 45.1 43.1 0.0 10 0.0 0.9 1.8
14921 346 7782 25 25211 82
1027276 16:24:36 CKPTINTVL 1477181:0xa661468 28.9 27.4 0.0 15 0.0 0.6 1.3
17436 636 8603 27 31287 99
1027277 16:29:40 CKPTINTVL 1477182:0xc4e018 4.3 3.5 0.0 2 0.0 0.4 0.5 14007
4055 7643 23 20696 63
1027278 16:36:22 CKPTINTVL 1477182:0x7f72018 103.0 102.6 0.0 0 0.0 0.0 0.0
17725 172 9144 30 36297 119
1027279 16:39:58 CKPTINTVL 1477182:0xd44a018 5.2 4.4 0.0 2 0.0 0.3 0.5 17563
4028 8092 25 22107 70
1027280 16:45:01 CKPTINTVL 1477183:0xa39b018 3.6 3.1 0.0 3 0.0 0.2 0.3 25191
8089 11422 37 47722 156
1027281 16:50:17 CKPTINTVL 1477184:0x69d0cc 16.9 14.4 0.0 13 0.1 1.1 2.2 13874
964 7435 24 21666 71
1027282 16:55:48 CKPTINTVL 1477184:0x748b018 31.1 30.0 0.0 13 0.0 0.7 1.0
21411 714 8747 27 29988 95
1027283 17:02:04 CKPTINTVL 1477185:0x9f278 96.8 95.4 0.0 8 0.0 0.5 1.0 17254
180 9177 29 30386 97
1027284 17:06:58 CKPTINTVL 1477185:0x6016018 74.9 72.8 0.0 14 0.0 1.0 1.5
16851 231 9194 29 29269 92
1027285 17:11:24 CKPTINTVL 1477185:0xe90f524 26.9 25.0 0.0 12 0.0 0.8 1.4
20564 822 10391 33 40336 128
1027286 17:18:23 CKPTINTVL 1477186:0x682f138 116.4 85.4 0.0 326 28.6 15.1 29.8
16459 192 8342 23 30949 86
1027287 17:22:29 CKPTINTVL 1477186:0x8f6e2a8 20.9 17.1 0.0 348 2.0 3.9 5.4
10849 635 5035 16 12260 39
1027288 17:27:52 CKPTINTVL 1477187:0x31d8184 19.4 17.6 0.0 24 0.2 0.9 1.8
27955 1587 13490 41 37744 117
1027289 17:33:12 CKPTINTVL 1477188:0x7f84018 12.8 12.4 0.0 16 0.2 0.4 0.4
27856 2252 19806 60 82764 253
1027290 17:39:07 CKPTINTVL 1477189:0x47801ec 55.3 16.5 0.0 247 35.1 22.2 37.4
23435 1417 12129 34 49628 142

Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time
2927 3850 103 2612 0 0

Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints.
If the server blocks transactions, increase the physical log size to at least 807852 KB.

Thanks,
Carlo

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

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.