Resources and publications relating to Data Studio
are on the increase. Here is a quick round up of places to read about, download, post questions and follow tutorials pertaining to IBM Data Studio - the new Eclipse based data management and development environment..Official SiteForums
There are two forums where you can post Data Studio questions and look for announcements, take your pick..DeveloperWorks ArticlesDocumentationOther Resources
If you know of any good resources I can add please let me know. Eagle eyed readers may notice blog comments have been switched off. I made this decision with reluctance at the weekend when the overhead of deleting comment spam became overwhelming. I hope a solution is found as reading comments is one of the best things about writing a blog, and comments and suggestions from Informix users come in very useful when planning new features. If anyone has any feedback to any of my high on quantity low on quality postings please use email
for now. (Update: I since relented and switched comments back on.)[Read More
Today is turning into a good day for announcements...
Brought to you from Hagenau, France
a new Web magazine has arrived: Informix Magazine
. A Joomla!
based creation, powered by IDS Cheetah, Hibernate and Java
, Informix Mag describes itself as
..focusing on Informix Technology on products like IDS (Informix Dynamic Server), Informix 4GL (I-4GL)..
Looking at today's page it has some news items, as well as a conglomeration of other Informix news feeds, a DBA Zone
and a Developer Corner
for job postings.JGP
, looks good, when you read this please comment and tell us more about the site...Update: 2/14/07
Here are Jean Georges Perrin's comments, which I'll add directly to this post, thanks JGP...
InformixMag aims to be the central place for Informix information, offering news, etc. It is purely a news site, it won’t have much unique and exclusive content, but I wish it to become the “Google for Informix information”. We have a real web-based forum, where we hope to see people discuss the news in a more efficient manner, etc. You have plenty of different partners already providing banners, Alfatec from Croatia, MoreData from Portugal, famous Kazer. We don’t want to “own” or steal content, just provide a convenient aggregation. We keep all copyright notices, and we are (soon) shortening long feeds, like yours :-). The project has been quite secret for a few months, released in a very early stage a few weeks ago, finding some partners has started last week. On the purely technical side, we have developed some technologies to aggregate the data from various places (including but not only RSS) and we are polishing the product and applying it in InformixMag. I’ll talk about the product later. It’s still alpha. We use a derived (or very extended) of Joomla, as you said, but the core of the data, is using Cheetah, Hibernate and Java…
Hi all, another PSA today.
Still this one is pretty cool, because the lab will be talking about application development with Data Studio and Informix. Even if you don't use Data Studio, and even if you don't plan to, I highly recommend attending. The more interest a call like this generates, the more calls like this (i.e. Application Development) will occur.
You have been invited to attend the following event:
Informix Chat with the Lab - Improve Databse Development Productivity & Save Tooling cost by using IBM Data Studio
10:30 AM - 12:00 PM (Central Time)
Jerry Keesee - Director, IBM Informix Database Development (IBM), Lakshman R. Sakaray - Software Engineer (IBM)
This session will take on a customer use case and go through each step of the development cycle demonstrating how using IBM Data Studio will help to improve the productivity of Informix users. IBM Data Studio has something to offer for each type of user, a demo for Java developers, the rich Eclipse development integrated development environment and utilities to support Java application development. SQL developers and Administrators will learn how the IBM Data Studio helps to improve productivity by using various features like object management explorer. This powerful stored procedure debugger and deployment manager allows you to deploy multiple scripts on test and production all at once.
Register for the Event
Register for this event at:
If clicking a link above does not work, please copy the entire link and paste it into your Web browser.
For technical questions, contact support at email@example.com.
For questions about this event, contact the host at: firstname.lastname@example.org.
Powered by IBM SmartCloud for Social Business
©Copyright 2000, 2012 IBM Corporation. All Rights Reserved.
The Washington Area Informix Users Group has announced free registration for Forum 2006
to anyone providing proof of a round-trip ticket from outside the United States. The regular registration price is $120. See the Forum Website
for more details, including discount hotel rates.
Kudos to the conference organizers for encouraging international participation.[Read More
So I got back from this years IIUG. It was a blast, as usual. The IIUG is making efforts to increase the number of presentations that are applicable to developers. This year it included presentations on Database programming with PHP, a section on open source coding with informix, programming with drupal, and then I did a best practices presentation for application developers.
I don't know when the IIUG will make the presentations available, but you do need to be a member to get them, and the process is simple, and free. Just go over to
And sign up.
Back in May
I mentioned there may be a tech fair in Menlo Park later this year. I was a few miles out but if you're based in the California Bay Area mark your calenders for September 14th - the Bay Area Informix Tech Fair is going ahead in San Jose
. This is an opportunity to spend a day learning about Informix topics from Advanced Support and Development engineers and meet other Informix users in the area. If you'd like to attend or have questions please RSVP..
FREE Informix Tech Fair
September 14, 2006
- IDS 10.00 Features
- Application Development
- High Availability Data Replication (HDR)
- SQL Optimizer
- Much more..
IBM Informix Advanced Support & Development Speakers:
Ajay Gupta, Guy Bowerman, Joaquim Zuzarte, Santosh Sajip, Suma Vinod,Vijay Lolabattu
Come and see demos integrating several application technologies.
Having a problem or question about Informix? Talk to an engineer and get free advice about your specific issue. Time is limited.
WHEN: September 14, 2006 9:15am - 4:30pm
The free Bay Area Informix tech fair
is Thursday September 14th in San Jose. Send your RSVPs (or questions) to email@example.com if you can attend.Directions
Here is a final list of planned talks and demos:
Bring your problems
- High Availability Data Replication (HDR)
- Application Optimization - low cost methods to improve application performance
- Lunchtime demos to accompany pizza: HDR, IDSAdmin for PHP preview
- MQ Datablade Overview
- IDS Optimizer - recent features, and using explain outputs to optimize your statements
- New features in IDS 10.0
- engineers from Advanced Support and Development will be on-hand to discuss problems and answer questions. Hope to see you there.[Read More
Here are the provisional agendas for the upcoming Beaverton
and San Jose
Informix tech fairs. Agendas are subject to whimsical and subliminal change.Beaverton, OR - Wednesday May 20
San Jose, CA - May 28
|9:00 - 9:15||Intro|
|9:15 - 9:30||IIUG President (Stuart Litel)|
|9:30 - 10:30||Informix Data Warehouse|
|10:30 - 10:45||Break|
|10:45 - 12:00||Storage Optimization & Performance|
|12:00 - 1:00||Lunch|
|1:00 - 2:00||Demo - OAT|
· Replicate a table/database in 3 clicks
· Online Data Compression
· Real-time & Historical SQLTrace
· Query By Example
· Graphical dbaccess
|2:00 - 3:00||New Cheetah Features|
|3:00 - 3:15||Break|
|3:15 - 4:15||Virtualization & Cloud Computing|
|4:15 - 4:30||Closing|
The time after 2pm is currently set aside for more demo's and in depth chats with developers, advanced support and product management - bring your problems.
|10.00am-10.30am||IDS Marketing Details (promotions, support, upgrade path)|
|11.30am-12.30pm||Virtualization & Cloud Computing|
|12.30pm-1.00pm||Lunch & Demos|
|2.00pm-||MEET THE EXPERTS|
We're planning another Beaverton Tech Fair for May 20th. Not many details yet but here's what we have so far...
Please save the date of Wednesday May 20, 2009 for the IBM Informix Tech Fair in Beaverton Oregon.
There will be a full day of talks, meet the developers lunch and new demos you have to see to believe.
There will be more details about this information packed day to follow. Please put this day on your
WHEN: May 20, 2009 between 9:00 – 4:30
WHERE: IBM Beaverton
15400 SW Koll Parkway
Beaverton, OR 97006
The Beaverton tech fairs are always good for a few giveaways, pizza, and lots of technical information. Hope to see you there.[Read More
Here are more details for the Beaverton Tech fair on May 20th...
Free Informix Tech Fair
Talks include the following topics:
- New 11.x Features
- New Data Warehouse Offerings
- New Storage Optimization Features
- Performance Features
- Virtualization & Cloud Computing
3 Informix IDS Architects
IIUG President Stuart Litel
IBM Informix Engineers
Replication & Storage Optimization
Free ConsultingHaving a problem or question about Informix? Talk to an engineer and get free advice about your specific issue.
WHEN: May 20, 2009, 9:00 AM – 4:30 PM
WHERE: IBM Beaverton
15400 SW Koll Parkway
Beaverton, OR 97006
Hope to see you there.[Read More
The latest issue of the innacurately named DB2 Magazine
has a very helpful article on the IDS 11 certification test. As anyone who has taken it knows, the IDS 11 exam is challenging - it is heavily focussed on IDS 11 features, and passing it requires preparation.
The new article, written by Eric Herber
, entitled Becoming a Certified Informix Professional
deconstructs the exam format and the weighting of questions. Looking at the exam in this way allows you to focus your study time and prepare intelligently.
On a positive note, perhaps a certification should be tough. What use is an easy certification to a potential employer or client? Anyone with IBM Test 918
to their name deserves to be called an IDS Expert.
As well as providing a collection of study references, Eric also mentions how to take the test for free (attend the IIUG conference). I'll add one other way to take it for free.. attend the Beaverton Tech Fair
next week.[Read More
Sitting on a flight to Las Vegas for the IOD conference affords an oportunity to tear myselfaway from the laptop and turn my attention to Carlton Doe
's new book: Administering Informix Dynamic Server - Building the Foundation
I should start by admitting a bias. I like Carlton, and from before Iknew him I've liked his writing; he writes not only with energy and passion for the subject, but with a great deal of technicalknowledge and experience. What this means is that you get all the information you would expect, but also something more than just adry technical book. So, needless to say, I was looking foward to a chance to read this book.
Is there a need for an Informix book when there is a comprehensive set of high quality Informix documentation available online?
The documentation is great but there is a huge amount of it, and zeroing in on exactly what you need can take time. Carlton addresses this question in the introduction:
In this book, I try to take the dry technical details of the documentationand put them into the context of daily life. I cover topics in what I thinkis their logical order of occurrence when working with a database environment. First, you design the environment; then you build andpopulate it. You create backups on a regular basis and monitor and tune asnecessary. There are other responsibilities and functions, but these are the most important. I use this approach to build the subjectsdiscussed in each chapter.
One thing this book does very well is provide current information. A greatdeal of new functionality has been added to IDS in the last year, andknowing how much of a lead time publishing deadlines impose I am impressed by the amount of up to date 11.50 feature descriptions thebook has. It can be stressful trying to write about a feature beforerelease while the developers change it as you watch (OpenAdmin Tool which keeps getting new features is a good example).Somehow Carlton has managed to stay current, and write with an inside knowledge ofwhich features are likely to change.
I'm glad to see a few in-jokes to keep us paying attention. In a section entitledProblem solving with Extensibility
a fictitious org chart is introduced,where Mukta, Fred, Kevin and Kassa report to someone called Jerry. That soundsstrangely familiar, though I can't quite place it.
At 424 pages Administering Informix Dynamic Server is small enough tocarry around, yet comprehensive enough to serve as a single referencesource. It also manages to provide a balance between introductory material for new Informix users and advanced technical information forInformix power users. After flicking through the backup and restore chapter I find myself drawn into a few diagrams and now know enough about XBSA architecture to be dangerous.
Overall, an excellent reference that both new and experienced Informix DBA's will find useful to have around.
Books links: Barnes & Noble
Bruce Weed, who leads Informix marketing strategy for Informix and IBM Information Management Business Partner Strategy, has started a new blog: Bruce Weed's Blog
. In his first post he threatens to share thoughts, experiences, and conversations about Informix and Information Management channels and begins with an interesting analogy about multi-talented olympic snowboarder Shaun White and how he chooses to focus his talents. I'm looking forward to part two of this when Bruce finds another can of Red Bull..
Thanks to the wonders of jet lag I'm in the office bright and early and catching up with some of the Informix content over the last two weeks...Real-time Database Monitoring with PHPMarty and Aron Lurie
have published an intriguing developerWorks article DB2/Informix and open source: Database defense against the dark political arts
- Real-time monitoring of your database for career enhancement.
It includes PHP code which uses ODBC to monitor system tables to provide real-time database information. I see they managed to include a reference to the quasi-mythical Informix race-car.. Ruby/Informix 0.5.0 releasedGerardo Santana's
Ruby extension for IDS continues its rapid development with the release of version 0.5.0. Download it from http://rubyforge.org/projects/ruby-informix/
0.5.0 12/27/2006------------------New features: * Easier to install * BigDecimal accepted for input parameters * BigDecimal used for instantiating DECIMAL and MONEY values * Cursor, Statement, Slob and Database accept an optional block that automatically frees resources after execution. Based on ideas and pseudo-code by Edwin Fine and me. * Database#slob shortcut for creating Slob objects. * Slob::Stat class implemented. Returned by Slob#stat, represents the SLOB status. Methods: atime, ctime, mtime, refcnt and size. Includes Comparable. * Slob new methods: <<, rewind, stat, pos, pos=, lock, unlock, estbytes, extsz, flags, maxbytes, sbspace, extsz=, flags=, atime, ctime, mtime, refcnt and size * Thread safeRuby on Rails/AJAX developerWorks Article
Remarks: * DECIMAL and MONEY columns are no longer returned as Float. BigDecimal is used instead.
Bugs fixed: * If there was an error reading (ifx_lo_read) an SLOB, memory allocated for the read buffer was not freed. Noticed by Edwin Fine * maxbytes option was ignored when creating an Slob object * Documentation for Slob mentioned an RDRW constant, but it actually is RDWR.
Continuing the Ruby theme Jack Herrington
has written a database generic developerWorks article entitled Build Ajax into your Web apps with Rails Practical examples of how to use Ajax with Ruby on Rails
. Worth a look.Python CornerInformix Zone
has a new Python corner
which kicks off with a tutorial from Carsten Haese
on using a number generator to create a Fibonacci sequence. Part 2 promises a how-to on incorporating number generators with InformixDB
Happy New Year![Read More
This week saw an interesting pair of articles in Computer Business Review Online
The first article on Monday, had the dramatic title: IBM has lost 80% of Informix users in six years
by Jason Stamper
. This must have sounded a little strange to anyone who has been paying attention to the rise of Informix in the last 18 months, and the fact that Informix revenue has been growing at a significantly faster rate than database market as a whole.
Sure enough, today the same journalist appears to have accepted the story is entirely false and issued a follow-up.. IBM corrects its own Informix customer figures
. "Instead we are now told there are 20,000 in the International Informix User Group, over 100,000 Informix customers, and millions of users.
" - Good to see a journalist make a humble and gracious apology for releasing a bogus story without checking the facts. Many people in his position would be tempted to blame their sources.Code line merger seems unlikely
A better-researched analysis of post-merger Informix is offered today by Philip Howard
of Bloor Research
in his Regdeveloper
article: IBM and Informix tie down Cheetah - Code line merger seems unlikely
. In it he discusses IBM's evolving strategy when it comes to Informix; contrasting the increasing scope of the last two major IDS releases, versions 10 and 11 and concluding favourably that any initial hints that the DB2 and IDS code lines might merge are off the table. Viewed from the inside, seeing the rate at which the IDS development team is growing, this assessment seems pretty accurate.[Read More