Save 
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
Insider

IIUG Insider (Issue #149)
November 2012

Other Issues

Highlights: IBM's Big Data for Smart Grid Goes Live In Texas

Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.

Contents:

 

Editorial Back to top

October looks like it was ages ago. Since the last Insider we had war, once again, in our region. I hope it is the last one but find it hard to believe.

The vNext EVP is on its way. Those who are participating are aware of the great improvements. The rest will need to wait until it is GA. I hope it will be announced at our conference. One more reason to come. Registration is now open.

Looking forward to meeting you all in San Diego.

Gary Ben-Israel
IIUG Insider Editor


Highlights Back to top

IBM's Big Data for Smart Grid Goes Live In Texas

Last week, IBM publicized a big data project with client Oncor, the largest electricity distribution and transmission company in Texas, that delivers an advanced smart grid to help 3 million households conserve energy.

Coverage focused on the benefits of the project with local media reporting from Fort Worth Star Telegram, and industry and tech publications including InformationWeek, Smart Grid News, Green Tech Media, Inside Big Data, Seeking Alpha, Data-Informed, Utility Products and TMC Net. An IBM bylined article in Dataversity exploring how big data is transforming the energy and utilities industry was timed to run with the news.

Highlights

Oncor Electric Delivery...says it is teaming up with IBM on a new data management project designed to give consumers a better look at their electricity usage. The online service works with advanced "smart" meters and other networked devices installed at homes and businesses to provide a nearly real-time monitor of consumption, the companies were set to announce today. The system also gives Oncor automatic alerts on power issues and outages. —Fort Worth Star Telegram

When IBM came on board, Oncor was expanding its project to more than 3 million advanced meters, each of which sends information every 15 minutes to Oncor's offices -- a dramatic increase over a traditional electric meter with its monthly readings. The logistics posed a classic big-data challenge. How could Oncor process and store all of that data in a cost-effective way? Oncor needed to upgrade from its relational database management system, which was efficient at managing modest volumes and velocities of data, but was too inefficient for the new smart grid. So Oncor installed IBM's Informix database software to run its smart grid. The new Informix system loaded meter data 20 times faster, and performed queries up to 30 times faster than the system it replaced, IBM claims. In addition, it reduced data storage needs by 70%, an improvement that remained linear over time and therefore allowed Oncor to accurately predict its storage requirements. —InformationWeek

IBM is a giant in smart grid big data, with partners around the world using its IT heft to link up power meters, grid sensors, leak detectors for water networks, and other end devices into the back-end systems that make them run. —Seeking Alpha

IBM and big Dallas-area utility Oncor announced the latest achievement on this long-running relationship - a big data platform that's analyzing Oncor's 118,000-plus miles of power lines, crunching data from its 3 million or so, smart meters from Landis+Gyr and meter data management software from Ecologic Analytics (both owned by Toshiba), and rolling out the results for both utility operations staff and to customers via the state's smart meter web portal. —GreenTech Media

In its big data initiative with Oncor, the largest electric delivery company in Texas, IBM points to a list of benefits... Oncor now has pinpoint access and insight into billions of data measurement points, from advanced meters and networking devices, to transmission sensors, power lines and generation plants. Many Texas households have noted a 10 percent decrease in energy usage since the implementation. — Smart Grid News

Media

Fort Worth Star Telegram - Near-instant electric use data planned
By: Jim Fuquay, November 5, 2012

InformationWeek - Big Data Meets Texas Smart Energy Grid
By Jeff Bertolucci, November 12, 2012

Inside Big Data - Smart Grids Meet Big Data: Oncor Joins Global Intelligent Utility Network Coalition
By: Staff, November 5, 2012

Seeking Alpha - IBM's Big Data For Smart Grid Goes Live In Texas
By Jeff St. John, November 9, 2012

Smart Grid News - Data analytics buying guide part 1: What's in Big Data for you?
By Staff, November 5, 2012

GreenTech Media - IBM's Big Data for Smart Grid Goes Live in Texas
By Jeff St. John, November 8, 2012

Data-Informed - Texas Utility Oncor Launches Smart Grid Project with IBM
By Christopher Nerney, November 6, 2012

TMC Net - Oncor Knows Outage Detection
By Joe Wolf, November 6, 2012

Dataversity - IBM Partners with Oncor to Bring Smart Grid to Texas
By Angela Guess, November 6, 2012

TMCNet - Texas Goes Live with IBM's Big Data for Smart Grid
By Tabitha Naylor, November 12, 2012

Utility Products - IBM Tackles Big Data to Deliver Advanced Power Grid

For more information about Oncor, please visit www.oncor.com or follow Oncor on Twitter and Facebook.

For more information about IBM big data technologies, please visit www.ibm.com. For more information about IBM Informix software, an important element of IBM's big data technologies, please visit: www.ibm.com. You can also follow @IBMBigData on Twitter.

For more information about Smarter Energy at IBM, please visit: www.ibm.com. Follow IBM Smarter Energy on Twitter and LinkedIn.


Conference corner Back to top

IIUG Informix Conference 2013 - Call for speakers

Please join us April 21 — 25 as we return to beautiful San Diego, CA and the Marriott Mission Valley.

The 2013 conference will continue to provide the quality you are familiar with but with one major addition: This year the conference tutorials have been moved to Thursday April 25th and are included with all paid registrations. The conference will begin Sunday evening with the Welcome Reception. There will be three full days of conference seminars with a variety of topics to choose from and we will also continue to offer our Hands-on sessions. Don't forget the valuable networking opportunities as well as the exceptional sponsors offering products and services for your business. The conference will introduce several new speakers, offering new and relevant topics related to using IBM Informix to meet all of your business needs.

Register for the conference by the Early Bird date of January 17, 2013 and receive a $275 discount off the regular price of registration. IIUG members can save an additional $100. Don't forget, this year the tutorials are included at no additional cost for all paid attendance making this conference an even better value.

Reinforce your professional skills and distinguish yourself in today's competitive environment by becoming IBM Certified. IBM Informix certification testing will be available during this year's conference at no cost to attendees for the first test. Additional tests can be taken for a nominal fee. Become certified in areas of Optimization, Tuning, Administration and 4GL programming. The entire IBM certification portfolio will be available, so test in one or more disciplines while attending the conference.

Still haven't read enough to justify attending the 2013 IIUG Informix Conference? Check the Justification document and share it with your supervisor for a list of additional reasons to attend. The Conference, including seminar content, tutorials, certification testing, hands-on labs and the opportunity to speak with Informix-specific professionals, is definitely a bargain when considering where to invest your 2013 training dollars.

See you at the conference!

2013 IIUG Conference Planning Committee

Click here to learn more about the conference
Follow IIUG 2013 on Facebook and Twitter


Developer corner Back to top

New in DeveloperWorks
21-Nov-2012
Starting with IBM Informix 11.70xC2, Informix started supporting the private installation feature. The private installation feature(non-root user installation) will allow Informix to be installed by a user other than root, and will permit the software to run without user Informix or group Informix on the machine. Inside the server, Informix will be used as the owner of the system catalog, but neither user Informix nor group Informix will have any special privileges with respect to a private server. The CSDK and other installers which are part of the Informix bundle will also permit non-root users to install the software. In this article, we discuss aspects of this feature in Informix and provide tutorials on how to manage users using JDBC, ESQL/C and ODBC drivers.

Save this link to find about Informix on DeveloperWorks: http://www.iiug.org/url/devworks.html


Informix news Back to top

Articles

IBM Data Management Magazine
The Preeminence of IBM Informix TimeSeries, Part 2
Handling the large volumes of time-stamped data generated from stock transactions, smart metering, and more

Ashdown Group
New Informix Database Administrator job in Scotland
Due to continued growth they are in urgent need of an experienced Informix Database Administrator to take an instrumental client facing position

Banking Business Review
Congo's RAWBANK deploys IBM smarter computing technology
Offering technology architecture and flexibility, the new core banking systems such as IBM Blade Center HS22, PS700 servers and Informix ...

Sacramento Bee
RAWBANK Adopts IBM Smarter Computing Solution to Drive Business Growth and Expansion
RAWBANK has also been using IBM's Informix software for its database and information management.

Videos

IBM Informix Business Partner Montage
A montage taken by the IOD client reference team. Informix users talking about the value of Informix to their business.

Why NOT Informix
Replay of the Webcast hosted by Tom Reiger (IBM Informix) — We all talk about "data explosions", "more users", "uglier queries and questions'. Informix is here to help you do what is NEXT around all those needs - and do it with less. Less hardware. Less administration. Less total cost. Webcast was hosted by : TOM RIEGER (IBM Informix).


Support corner Back to top

Communication Setting Optimizations: Fetch Buffer Size

This setting applies to Informix client-server communications when using the SQLI protocol. While it can be set for other types besides TCP (shared memory or pipe), as we will see, it is only really useful for TCP connections.

When the server responds to a client request for data, it arranges the data in an buffer of the size requested by the client. The data is arranged by tuples, or rows. When the buffer is full, or the server has come to the end of the rows being fetched, the buffer is copied over the communication channel to a like buffer within the client application process memory. The client API (ODBC, JDBC, ESQL...) reads from the buffer, and copies or transforms the data into application variables as the application requests rows. When the client comes to the end of the buffer, and there is still more data in the result set, the client requests the server to send it another buffer of data.

The fetch buffer size setting is intended to allow the application to reduce the number of times the client API has to request another buffer. This setting is very much in the domain of speed versus size tradeoffs. Since at least one buffer has to be sent, there is no advantage to setting the buffer size to be larger than the typical, expected result set. Also, each buffer is associated with one executing statement; so, if there are lots of statements being processed concurrently, the size of the buffer can have an impact on the application's memory footprint.

A simple way of thinking of how the fetch buffer size affects the application performance is to think of it in terms of number of buffers per result set, times how long of an inherent delay there is between the client and server. If the result set size is small, or the communication channel has little to no delay (which is always the case with shared memory or pipe connections), there is no significant benefit to larger buffer sizes. What follows are the results of series of tests where the result set size, fetch buffer size, and network delay are varied.

These tests were written using the ODBC interface, but the pattern of results should be the same across all Informix APIs when using the SQLI protocol. The client and server are on the same physical machine, with the client running under Windows and the Informix server on a Linux virtual machine. The network delay is controlled using Linux's network emulation (netem) functionality.

The data do not actually exist in the database; they are manufactured at the time of query execution through the use of views created to multiply the base result set. This configuration is not representative of any real world scenarios. So, while the pattern of effects produced from fetch buffer size settings is reliably produced, any other metrics, such as the number of queries per second, that might be inferred should not be considered to be representative of real world performance.

Empirical Results

The empirical results match predictions. As the size of the result set is increased, the effect of increasing the size of the fetch buffer is that slower communication between the client and the server has less effect. When sending large results to the client, it is possible to compensate for a slow network with a large fetch buffer. When the result size is small, or the network has little delay between the sending and receiving of packets, the setting of fetch buffer size has little effect.


Example 1: Small result set size — 1K

Increasing the fetch buffer size beyond the size of the result set has no meaningful effect, across all network conditions.

Table 1. Result set 1K data

Network Delay
05100
5000204.525.91.969887
50000207.325.91.96818
500000208.426.11.966548


Example 2. Moderate result set size — 256K

When there is a negligible network delay, the size of the fetch buffer has negligible effect. As the network delay increases, the effect of increasing the fetch buffer size becomes more significant. When the network delay is 100ms, increasing the fetch buffer can increase performance by over 6 times.

Table 2. Result set 256K data

Network Delay
Fetch Buffer Size05100
500057635538
50000585523153
500000580551262


Example 3. Large result set size — 4MB

When working with large result sets over a slow network, setting a large fetch buffer size can be crucial to performance. Notice that the data transfer rate of the largest buffer over the slowest network is only about 15% slower than the fastest condition, and 12 times faster than the same transfer using a small buffer.

Table 3. Result set 4MB data

Network Delay
Fetch Buffer Size05100
500058337241
50000589558239
500000595583504

The results above should provide a useful guide on an appropriate setting for fetch buffer size based on the actual queries being performed and the network infrastructure in use. The main drawback to a high setting of fetch buffer size is limited to when the memory footprint of the application starts to impede on memory requirements of other processes.

— Chris Golledge


Informix corner Back to top

Informix University initiative update

UMKC has opened enrollment for a new course offering - Introduction to Health Informatics - and they will be using IBM Informix in the course. It will be taught by one of our long time faculty partner Prof. Praveen Rao as a "Special Topics" graduate level course. You can find the course description here.

New Informix book available in China

Lu Chuan, one of IBM Informix technical experts in China, has just published a new book about Informix 11.x. It is currently only available in Chinese but hopefully it will make it into other languages. Go here for a closer look or to order.

New case study

IBM Informix success story with customer Westfleisch e.G.
"High-volume meat production is a logistical challenge. This new solution provides us with critical business data from our nine meat-production locations much faster and more reliably than before." — Joachim Badde, CIO, Westfleisch. Read more about this success store here.

Local user group meetings

WhereWhenLocation 
Seattle4 Dec 2012Tap HouseDetails
Chicago6 Dec 2012IBM TECDetails
North Texas11 Dec 2012Maximo CocinaDetails

Informix Bootcamps

WhereWhenLocation 
Informix Performance Tuning Bootcamp12-14 Dec 2012Shenzhen, ChinaRegistration
Informix Genero Bootcamp 4-7 Dec 2012Mexico City, MexicoRegistration


Sponsor corner Back to top

Advanced Datatools

Advanced Informix Performance Tuning Course

December 3-6 2012 by Lester Knutsen and Art Kagel (attend online or in our classroom)

This course is confirmed and only has 3 spaces left.

Do you want to learn how to be the FASTEST Informix DBA? This is the course our Fastest Informix DBA contest was developed from, and it will increase your database performance tuning skills.

This 4-day course focuses on techniques for optimizing an Informix Database. Labs will demonstrate more than 100% performance improvement. Each student will have a 4-core Linux server with Informix 11 and a large dataset for benchmark exercises and labs. Attend the class in person or online via our Web Training Center. Both Art Kagel and Lester Knutsen will be teaching the Advanced Classes together.

The Advanced Informix Performance Tuning This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an Informix database server. The focus is on skills, procedures, and scripts to improve the performance of your database server. The course will provide a toolkit of scripts and utilities to start monitoring and optimizing your Informix database server.

The course may be taken online on the web from your desk or at our training center in Virginia. All you need is a web browser and a SSH client (like Putty) to connect to the lab machines in our office.

Register online or call 703-256-0267 ext 101 for more information or to register by phone.

Visit our Informix Courses Schedules and Outlines page.


Informix resources Back to top

IBM Informix home page

http://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

Informix blogs and Wikis

Blogs and Wikis that have been updated during the last month

More Blogs and Wikis

 
Forums, Groups, Videos, and Magazines  

Calendar of events Back to top

December - 2012
Date Event Location Contact
4 Seattle Informix User Group Meeting Seattle, Washington  
6 Chicago Informix User Group Meeting IBM TEC Center, Chicago Illinois rbeal@us.ibm.com
11 North Texas Informix User Group Meeting Dallas, Texas  
 

Useful links Back to top

http://www.iiug.org/quicklinks.html


Closing and credits Back to top

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG's membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM's Data Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.

Sources:  IIUG Board of Directors
IBM Corp.
Editors:  Gary Ben-Israel
Rhonda Hackenburg

For comments, please send an email to gary@iiug.org.