Save 
Join IIUG
 for   
 

Informix News
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 #121)
July 2010

Other Issues

Highlights: New Informix Packaging

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

In May IBM came out with a new pricing and new editions for Informix. Two months later there is a modification to the new offerings. The Ultimate-C free version no longer exists. The Innovator-C edition is now the only free deployable edition available on Mac and Windows. A new low price entry level edition called Choice was added to Windows and Mac. It is tempting to say the first pricing module was poorly planned and the new one is just a hysteric reaction.

I don't think this is the case. The May announcement was carefully planned. The main target was the SMB space the fastest growing market segment. After the May pricing model IBM kept a close watch and talked to many partners and customers. The model was reevaluated and revised. I think it is the right course of action. Please read the highlights section for detailed information.

IBM has a clear road map for Informix, offers a new production free edition, is aggressively promoting Informix in the SMB market place and recruiting new solutions partners. I regard it as a big step forward. Informix always had a technological advantage now it is offered in a competitive price.

Gary Ben-Israel
IIUG Insider Editor
gary@iiug.org


Highlights Back to top

New Informix Packaging

New Informix Editions - Creating Growth Opportunities for Clients and Partners

New free edition to drive new solutions adoption Greater value for purchase new editions
Informix Innovator-C Edition
  • Ideal for small applications with HA
  • Free to download, develop, and deploy
  • 1 socket, 4 cores, 2GB memory
  • All platforms
  • Optional Selected Support available
  • Requires IBM license to re-distribute
Informix Choice Edition
  • Ideal for small to medium size business
  • HA pair
  • Mac OS X and Windows
Informix Developer Edition (existing)
  • Full functionality, limited scalability
  • 1 core, 1GB memory, 20 connections, 8GB DBSpace
  • Free to download, develop, test
  • All platforms
Informix Growth Edition
  • Ideal for medium size business
  • Rich HA options
  • Shared disk clustering
  • All Platforms
  Informix Ultimate Edition
  • Full enterprise class functionality for all businesses
  • Optional compression feature
  • All Platforms

Greater values on new for purchase editions on Informix V11.50xC7

IDS Workgroup to Informix Growth Edition

  • 3-nodes HA cluster of any type
    • Queries and updates on secondary nodes
    • No warm/idle standby charge
    • Full Informix license on each hot standby node, charge metric can be different from primary
  • Continuous Availability Feature (aka Shared Disk Secondary (SDS) ) included, up to 3 SDS nodes
    • Same charge metric on all SDS nodes
  • Advanced Access Control Feature (aka LBAC) included
  • Unlimited Enterprise Replication (ER) nodes, both root/admin and leafnodes
  • Informix Warehouse for Workgroup Edition rolled into Growth Edition
    • SQL Warehousing Tool (formerly Informix Warehouse Feature) included
  • 4 sockets processor limits for all charge metrics, no more PVU limit

IDS Enterprise to Informix Ultimate Edition

  • Unlimited scaling and functionality
  • Formerly for charge feature options now included
    • Continuous Availability Feature
    • Advanced Access Control Feature
  • Storage Optimization Feature remains a for charge feature option
  • HA cluster of any type
    • No warm/idle standby charge
    • Full Informix license on each hot standby node, charge metric can be different from primary
  • Unlimited SDS nodes
    • Same charge metric on all SDS nodes
  • Informix Warehouse for Enterprise Edition rolled into Ultimate Edition
    • SQL Warehousing Tool (formerly Informix Warehouse Feature) included
    • Purchase Storage Optimization Feature separately

Informix Editions Summary

Edition Charge Metrics Resource limits Informix Editions Summary
Ultimate
 Linux, Unix, Win, Mac
PVU, CS, AU Single Install Unlimited For Charge Feature - Storage Optimization Feature option Everything else included
Growth
 Linux, Unix, Mac, Win
LU Socket, PVU, CS, AU Single Install 4 sockets, max 16 cores
16GB Informix memory across all instances per Install
Features Unavailable: Compression, parallel features, partitioning
Partially Available: 3-node cluster1 primary, any 2 secondary servers (HDR, RSS, SDS) unlimited ER root & leafnodes
Choice
 Mac & Win only
LU Socket, AU Single Install 2 sockets, max 8 cores
8GB Informix memory across all instances per Install
Features Unavailable: Compression, Shared Disk Secondary (SDS), parallel features, partitioning, Advanced Access Control, Informix Warehouse Feature (aka SQL Warehousing Tool), multiple secondary servers
Partially Available: 2-node cluster 1 primary, 1 secondary servers (HDR, RSS) Enterprise Replication (2 root nodes)
Innovator-C
 Linux, Unix, Mac, Win
Free License to develop, test, and deploy Re-distribution license required Optional support — per Install/year, renewable each year 1 socket, max 4 cores
2GB Informix memory across all instances per Install
Features Unavailable: Compression, Shared Disk Secondary (SDS), parallel features, partitioning, Advanced Access Control, Informix Warehouse Feature (aka SQL Warehousing Tool), multiple secondary servers
Partially Available: 2 node cluster 1 primary, 1 secondary servers (HDR) Enterprise Replication (2 root nodes)
Express (existing)
 Linux, Win
LU virtual server, PVU, AU Single Install 200 PVUs
4GB Informix memory across all instances per Install
Features Unavailable: Compression, CAF, parallel features, partitioning, ER,HDR, RSS, SDS, Advanced Access Control, Informix Warehouse, all DataBlades except geospatial, time-series, and real-time loader

Informix Offering Mapping — Old to New Editions

PID Old Offering New PID New Replacement Offering
5724L23 IDS Enterprise Edition 5725A39 Informix Ultimate Edition
5724L23 IDS Storage Optimization Feature for Enterprise Edition 5725A39 No Change — Informix Storage Optimization Feature is a for charge feature option available only on the Ultimate Edition
5724L23 IDS Continuous Availability Feature for Enterprise Edition N/A No replacement - feature included in Ultimate Edition, New - limited clustering availability included in Growth Edition not included in Innovator-C
5724L23 IDS Advanced Access Control Feature for Enterprise Edition N/A No replacement - feature included in Ultimate Edition
5724L23 IDS Workgroup Edition 5725A40 Informix Growth Edition
5724L23 IDS Advanced Access Control Feature for Workgroup Edition N/A No replacement - feature included in Growth Edition
5724W92 Informix Warehouse Enterprise Edition 5725A39 Informix Ultimate Edition plus Storage Optimization Feature
5724W93 Informix Warehouse Feature for Enterprise Edition N/A No replacement - feature included in Ultimate Edition
5724W92 Informix Warehouse Workgroup Edition 5725A40 Informix Growth Edition
5724W93 Informix Warehouse Feature for Workgroup Edition N/A No replacement - feature included in Growth Edition
5724Z04 Workgroup Edition 5724Z04 No change — Informix Express Edition

License Entitlement Migration for IBM Passport Advantage Customers

  • Active IBM Passport Advantage customers have been automatically migrated to the new Informix replacement license entitlements on May 25, 2010
  • In the interim, until their next S&S renewal is completed, Passport Advantage will display both the old and replacement Informix license entitlements
  • Beginning on May 25, 2010, renewal quotes will be based on the new replacement part numbers.
  • After the next S&S renewal is completed, only the new replacement entitlements will be displayed
  • We prepared a customer letter explaining the entitlement migration and what to expect
 
Competitive Pricing and Packaging  
 
Edition MS Express Informix Innovator-C Informix Express MS Workgroup
Limits 1 CPU, 1 GB RAM, 10GB database size 1 socket, maximum 4 cores, 2 GB memory 200 PVU, 4GB memory 2 proc (socket), 4 GB RAM
Feature options N/A N/A None None
Key functionality included Online schema change, log shipping 2-node cluster (r+w) — RSS, HDR, 2-root node ER (replication), encryption, Continuous Log Restore, Admin API, built-in DataBlades Continuous Log Restore, Admin API, built-in DataBlades Online schema change, log shipping, subscriber only replication
Key functionality not available Parallelism, partitioning, HA, online indexing, compression, warehousing, Starjoin, OLAP, XML, replication, encryption Parallelism, partitioning, compression, SDS, LBAC, CDC, SQL warehousing, multiple secondary nodes Parallelism, partitioning, HA, SDS, compression, LBAC, CDC, SQL warehousing, multiple secondary nodes Parallelism, partitioning, HA, online indexing, compression, warehousing, Starjoin, OLAP, XML, replication, encryption
 
Edition Informix Choice Edition for Mac & Win MS Standard Informix Growth Oracle Standard
Limits 2 sockets, maximum 8 cores, 8 GB memory 4 sockets, 64 GB RAM 4 sockets, maximum 16 cores, 16GB memory 4 sockets, OS Max memory (no limit)
Feature options None None None None
Key functionality included 2-node cluster (r+w) — RSS, HDR, 2-root node ER (replication), encryption, Admin API, built-in DataBlades 2-node failover, DB Mirror, LBAC, encryption, data replication, limited warehousing 3-node cluster (r+w) — SDS, RSS, HDR, unlimited ER, encryption, SQL warehousing, LBAC 4 CPU RAC (no Infincluster iband), encryption, data replication, online indexing, Starjoin, subset warehousing
Key functionality not available Parallelism, partitioning, compression, SDS, LBAC, CDC, SQL warehousing, multiple secondary nodes Parallelism, partitioning, online indexing, compression, backup compression, Starjoin, analysis services Compression,Parallelism, partitioning, Change Data Capture (CDC) Parallelism, partitioning, compression, High Availability (HA), LBAC. OLAP
 
Edition MS Enterprise MS Datacenter Informix Ultimate Oracle Enterprise
Limits 8 sockets, 2 TB RAM Unlimited, unlimited Unlimited, unlimited Unlimited, unlimited
Feature options none none compression Numerous (partitioning, compression, HA, OLAP ...)
Key functionality included All Virtualization R2 Hyper-V support, Application and Multi-Server management, event processing StreamInsight All, except compression is optional All, except options
Key functionality not available None None None None

Education Back to top

Advanced DataTools

Informix Training - Online, Onsite or in Our Classroom

Advanced Informix Performance Tuning Course by Lester Knutsen and Art Kagel.

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 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 IDS 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.

This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an IDS 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 IDS database server. (Cost $2,000 USD)

Course Schedule:

  • September 27-30, 2010
  • November 15-18, 2010

Class times are 9:00 AM to 5:00 PM; dress is casual.

For directions and hotels near Advanced DataTools' Office see:

http://www.advancedatatools.com/OurCompany/DirectionsMapsHotels.pdf

For more information visit http://www.advancedatatools.com/Training/InformixTraining.html or call 703-256-0267 Ext. 101 for more information and to register.

IBM

US only, All IM

Register now to get your software skills, and a complimentary netbook, too!
Now you can receive a complimentary Lenovo S10-3 netbook after completing an eligible Information Management class. Simply register for an eligible software training class between May 5 — October 29, 2010 and complete the class by December 17, 2010. Note this is a U.S. only promotion cannot be combined with other IBM discounts.

Learn more! http://www.ibm.com/training/us/swgnetbook5

US only, All IM

Time is running out! Redeem your Assess and Save voucher now!
Candidates who purchased, and passed an Information Management Online Assessment Exam during the offering period, automatically received a 50% off certification voucher good for the corresponding exam. Plan to redeem your voucher on or before August 31st, 2010 and save before it expires!

For more information visit http://www-01.ibm.com/software/data/education/voucher.html?ca=july2010nl


Developer corner Back to top

Informix Chat with the Lab

Thursday, August 26
8:30 AM Pacific
10:30 AM Central
11:30 AM Eastern
4:30 PM London
5:30 PM Paris

Informix Post End of Service Support Options and Upgrade Best practices

Speakers:

Al Martin - Director; WW Data Management Support; IBM
Charles Gonsalves - Sr. Manager; WW Informix Support, IBM
Chris Fender - Program Director; WW IM S&S Strategy and Sales
Ron Privett - Sr.Engineer, Americas Down Systems and Diagnostics Team.

When a software version reaches its End of Service date - when support is no longer available through standard Software Subscription and Support — there is no need to tackle support issues on your own. Discover new flexible options available to you when your Informix software reaches End of Service.

Available for Informix versions 7.3, 9.4 and 10, these options will provide you with access to expert IBM Support professionals and will help you maintain business continuity until you upgrade to the latest version of Informix. We will also cover best practices when upgrading from Informix 10 to Informix 11.50; including upgrading standalone and replicated environments.

Presentation material will be available at http://www.ibm.com/informix/labchats prior to the event.

Questions, comments: ahujam@us.ibm.com

To register for this event, use the following link:

https://events.webdialogs.com/register.php?id=d6def198fd&l=en-US

For webinar-specific questions, contact the moderator. For technical support, contact UnyteSupport@us.ibm.com.

Using Estimated Rollback Time Feature of 11.50.xC6

It was a beautiful morning on July 4, 2010. I had taken a long weekend to enjoy the lake with some friends and celebrate my wife's birthday. Birds were chirping, fish were jumping, coffee was brewing, bacon was sizzling, the kids were spending some quality time with the grandparents and I was enjoying a rare treat, sleeping in. When the phone rang and I saw the number I knew it wasn't a good phone call.

You see, I'm the only Informix DBA where I work, which means I'm always on call. I'm OK with this and so is my employer. This setup rarely causes either of us problems because Informix is so darn stable and if I'm completely unavailable I do have a backup with a good bit of Informix know-how.

I answer the phone and get a description of "the database is running slow and new connections are failing, can you join the outage bridge?"

At about this time the alarms that are sent to my phone start rolling in. "Dynamically allocated new virtual shared memory segment", "DR: ping timeout" and "DR: Turned off on primary server". Well crap, any hopes of this being a false alarm are DOA and I fire up the laptop and wireless internet card and join the bridge.

To my disappointment I am unable to acquire an internet connection at the lake (it worked earlier when I tested it) and am now in the unfortunate position of asking my backup to run onstat commands and look at the online logs and telling me what he sees. I don't know how the Informix Support people do this day in and day out, it is totally frustrating. My hat goes off to them.

10 minutes into the outage I'm in the car driving into town in search of civilization and internet and after a lengthy back and forth between me and my Eyes that went something like this:

Me: Run onstat -g act and tell me what you see.
Eyes: onstat -g acv just returns a list of onstat options
Me: Did you say you ran onstat -g atp?

(Phonetic Alphabet Tables can be found here: http://www.osric.com/chris/phonetic.html)

We finally determine that a huge delete took place, ran for some time, was aborted by the user and the rollback is causing all kinds of havoc with locks being dynamically added, dynamically allocated virtual segments, memory swapping and general server unhappiness. Eventually the rollback completes and the engine is bounced to free the allocated locks and things are back to normal. We are lucky that our bread and butter application does not depend too heavily on this server to function, so the damage to our bottom line was minimal.

When things like this happen we have a follow up meeting after the dust settles to discuss what happened and how to prevent it from happening again. Pretty standard, really.

In this case my initial suggestion of "Don't accidentally attempt to delete 11.5 million rows from a table with row level locking in a single transaction on a holiday" was met with little enthusiasm. While it is a good policy, accidents do happen, and we need to identify potential long transactions before they become a problem.

A new feature in 11.50.xC6 that allows you to view the estimated rollback time of a transaction gave us the information we needed.


> onstat -x 

IBM Informix Dynamic Server Version 11.50.FC6   -- On-Line -- Up 93 days 
01:09:22 -- 376408 Kbytes 

Transactions 
                                                                            
              est. 
address          flags userthread       locks  begin_logpos      current 
logpos    isol    rb_time  retrys coord 
db99a028         A---- db957028         0      -                 - 
COMMIT  -        0 
db99a340         A---- db957880         0      -                 - 
COMMIT  -        0 
db99a658         A---- db9580d8         0      -                 - 
COMMIT  -        0 
df40b750         A-B-- e0147788         4      13026:0x1ebb6018 
13026:0x1ebb609c  COMMIT  5:31     0 
4 active, 16 total, 8 maximum concurrent

A new column, est. rb_time, has been added to onstat -x. We can continuously monitor this column via a light weight script run by cron (or whatever you like) and send an alarm if we find a potentially long transaction. This gives us the ability to log in, identify what is going on, determine if this is a legitimate transaction or a bad one that will cause problems and kill the session before the rollback time gets out of hand.

Is this a perfect solution for everyone? Nah, but it works well for my OLTP environment where our transactions are teeny tiny and a rollback time of more than 30 seconds should raise an eyebrow and a rollback time of more than 60 seconds is cause for alarm.


#!/bin/ksh 

# script to monitor for long rollback times 

# sendmail used to email alerts 
SENDMAIL="/usr/sbin/sendmail -t" 

# send only an email if rollback time reaches MAXROLLBACKEMAIL 
MAXROLLBACKEMAIL=${1:-30} 

# send a page if rollback time reaches MAXROLLBACKALARM 
MAXROLLBACKALARM=${2:-60} 

# email address 
EMAIL_NOTIFY=dba@email.com 

# pager 
DBA_PAGE_EMAIL=number@pager.com 

# force MAXROLLBACKEMAIL to be less than or equal to MAXXROLLBACKALARM 
if [[ ${MAXROLLBACKEMAIL} -gt ${MAXROLLBACKALARM} ]] 
then 
       MAXROLLBACKEMAIL=${MAXROLLBACKALARM} 
fi 

# use grep and awk to extract rollback times and convert them to seconds 
# inspect each rollback time and send an email or alarm if over the limits 
for time in $(onstat -x | awk '{print $8}' | grep -vE "isol|On-Line|-|^$" | 
awk ' 
BEGIN { 
       FS=":" 
} 
{ 
       printf("%ld\n", $1 * 60 + $2) 
} 
') 
do 
       if [[ ${time} -ge ${MAXROLLBACKEMAIL} ]] 
       then 
               if [[ ${time} -ge ${MAXROLLBACKALARM} ]] 
               then 
                       EMAIL_NOTIFY="${EMAIL_NOTIFY},${DBA_PAGE_EMAIL}" 
               fi 

               cat - << EOF | ${SENDMAIL} > /dev/null 2>&1 
to:${EMAIL_NOTIFY} 
from:$longTx@yourcompany.com 
subject:${INFORMIXSERVER} - long transaction 
there is a transaction with an estimated rollback time of ${time} seconds 
EOF 
               print -- "$(date +'%Y-%m-%d %H:%M:%S'): there is a 
transaction with an estimated rollback time of ${time} seconds" 
       fi 
done

Andrew Ford
IIUG Board of Directors

New in DeveloperWorks

Migrating from Microsoft SQL Server to IBM Informix
http://www.redbooks.ibm.com/abstracts/sg247847.html?Open
In this IBM Redbooks publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft SQL Server 2008 to the Informix Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan.
26 Jul 2010

Compare the Informix Version 11 editions
http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/index.html
Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease-of-use, reliability, stability, and access to extensibility features.
22 Jul 2010

Get started with direct file I/O support in IBM Informix 4GL
http://www.ibm.com/developerworks/data/library/techarticle/dm-1007informix4gl/index.html
IBM Informix 4GL is a comprehensive development and production environment for creating sophisticated database applications. The 7.50.xC4 release of Informix 4GL includes direct support for file I/O without requiring function calls in another language such as C. This article describes the advantages of using the direct I/O support and provides you with an introduction to how you can use it with operations such as OPEN FILE, CLOSE FILE, READ, WRITE, and SEEK. The article includes code samples that can help you get started with implementing the file I/O feature in your own applications.
15 Jul 2010

For more information go to DeveloperWorks - Informix:
http://www.iiug.org/url/devworks.html


Support corner Back to top

Announcing the Continuing Support Pilot for Informix versions 9.4 and 10

IBM is pleased to introduce the Continuing Support offering, a pilot program for Informix versions 9.4x and 10.x that will provide you with continued access to the same knowledgeable Informix global Support team you are working with today. This assistance, included with your active Informix Subscription and Support renewal, will help keep your business running on Informix software until you are able to upgrade to take advantage of new features available in the latest Informix version. The Continuing Support Pilot begins October 1, 2010 and ends September 30, 2011.

http://www-01.ibm.com/software/data/informix/upgrade/

This exciting offering allows you to enjoy many of the Subscription and Support benefits that you have told us matter most to you, including:

  • 24x7 Service Request assistance over the phone or online for Severity 1 issues
  • Local business hours Service Request assistance over the phone or online for Severity 2 - 4 issues
  • Access to documentation, technotes and other online product material
  • Access to existing available fixes created before the product's EOS date to correct known defects

The Continuing Support offering does not include:

  • Development analysis of new defects
  • Development of or packaging fixes that are not already available
  • Support for 3rd party components
  • Infrastructure validation for Informix products that are not included on the product compatibility matrix released as part of the product end-of-support announcement

Pilot Program Participation

On or before the September 30, 2010 End of Service date for IBM Informix version 10, you only need to complete your annual Informix Subscription and Support renewal to receive Continuing Support assistance for a period of one year.

To get more information the Continuing Support Informix Pilot Program, email askifmx@us.ibm.com.


Informix corner Back to top

Message from the Director

As many of you know, in late May we introduced new Informix packaging and pricing to deliver greater value to our clients and partners with what we believed would enable growth opportunities at a lower cost. We received a lot of positive feedback, but also some suggestions to add a more attractive mid-market offering.

We took this feedback and decided to make changes to the new offerings. On July 20, we are launching a new Informix Choice Edition for Mac OS X and Windows. This is a low-cost, feature-rich Informix edition that offers enterprise-class functionality at a very attractive price point with high-availability for the mid-market. It will replace the Informix Ultimate-C Edition introduced in May, which is now withdrawn. Further, the Informix Growth Edition introduced in May now supports Windows and Mac OS X environments, in addition to UNIX and Linux.

Complete details of all Informix editions and entitlements are available on the IIUG website:

http://www.iiug.org/news/announcements/new_prices.php

We recognize that major changes such as this need to be communicated as widely as possible, and we'll continue to strive to do a better job of that. I hope this newsletter is a step in that direction.

Regards,

Jerry

Migrating from Microsoft SQL Server to IBM Informix

An IBM Redbooks publication

Abstract

In this IBM Redbooks publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft SQL Server 2008 to the Informix Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan.

We provide a conversion methodology and discuss the processes for migrating the database objects and data from SQL Server to Informix using various methods. We show the SQL differences between SQL Server and Informix and illustrate, with examples, how to convert tables, views, stored procedures, functions, and triggers. We provide script conversion samples for data loading. We describe application programming and conversion considerations. In addition, we discuss the Informix configuration, as well as the administration features and functions Informix provides to help DBAs manage the Informix database server after it is migrated.

With this information, you can develop your required transition methodology, and you can plan and execute the conversion activities in an orderly and cost-effective manner.

http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg247847.html?Open

New Informix Choice Edition announcement  
 
Withdrawal of Ultimate-C Edition announcement  
 

Informix resources Back to top

Informix Blogs and things  
   

Calendar of events Back to top

August - 2010
Date Event Location Contact
4-6 2010 IDS 11.5 Bootcamp Shenzhen, China linzhao@cn.ibm.com
9-11 2010 IDS 11.5 Bootcamp Beijing, China gyzhang@cn.ibm.com
12 Software Summitt Mexico City, Mexico
18-20 2010 IDS 11.5 Bootcamp Cali, Columbia iamaya@co.ibm.com
23 Discover the New Face of Informix Event Sao Paulo, Brazil
September - 2010
Date Event Location Contact
1-2 Discover the New Face of Informix Event Quito, Ecuador
6-7 Discover the New Face of Informix Event Bogota, Columbia
9-10 Discover the New Face of Informix Event Caracas, Venezuela
13-14 Discover the New Face of Informix Event Santiago, Chile
14 Southeast Informix User Group Meeting The Home Depot, Atlanta kate@iiug.org
16-17 Discover the New Face of Informix Event Buenos Aires, Argentina
20-21 Discover the New Face of Informix Event Lima, Peru
22-24 2010 IDS 11.5 Bootcamp Warsaw, Poland bartlomiej.makolus@pl.ibm.com
28-30 2010 IDS 11.5 Bootcamp Frankfurt, Germany BRYCH@de.ibm.com
October - 2010
Date Event Location Contact
11-12 Discover the New Face of Informix Event Mexico City, Mexico
18-20 2010 IDS 11.5 Bootcamp Istanbul, Turkey BANUS@tr.ibm.com
24-28 IBM Information on Demand 2010 Las Vegas, Nevada
November - 2010
Date Event Location Contact
9-11 2010 IDS 11.5 Bootcamp Casablanca, Morroco ACHAARAN@ma.ibm.com
23-25 2010 IDS 11.5 Bootcamp Kuala Lumpur, Malaysia
 

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
Tammy Frankforter

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