- Figure out the partnum for the table being altered, best way is to run the following SQL from the DB the table is in:
select hex(partnum) from systables where tabname="<tabname>"
Where <tabname> is whatever the table name is you are altering.
- using onstat -k |grep <partnum you got above> , find out who is holding the locks.
- contact user about locks, or if you are under a rush, just kill the offending user/session
Administrating and Developing with Informix
So I ran into an interesting issue last week. A customer couldn't alter a table. Non-Exclusive access. Sounds pretty normal right? I mean after all it's not like a DBA doesn't see this fairly often.
The Normal routine is for a DBA to run the following:
However what happens when you still get non-exclusive access after doing the above?
You need to have two considerations then. #1, check for referential integrity issues, and #2 look for open cursors?
RI can be checked using dbaccess, or dbschema, but how do you check open cursors?
The easiest way is with
onstat -g opn
In the situation I wan into, we had several open cursors with transactions running against the child table holding RI.
This allowed us to identify where applications were forgetting to close the cursors. As soon as those cursors were closed, the alter table was successful.
From a development standpoint, this brings up a salient point to always remember, close your cursors.
For more info on onstat -g opn
Amazon Web Services announced an addition to their pricing model today called Reserved instances. Instead of just an hourly and usage fee, you pay an annual or triannual fee together with a lower hourly usage fee. The details can be found here: Amazon Elastic Compute Cloud Pricing.
If I take the simplest example of running a small standard demand Linux instance continuously for a year (8760 hours) in the US and ignore data transfer, storage and leap years, the prices work out as:
Reserved Instance: $325 + (8760 * 0.03) = $587.80
x = 4643 hours (rounded up)
To make a real world cost-effectiveness calculation for pay-by-the-hour computing resources implies you have a comprehensive understanding of your physical hardware costs (electricity, rack space, IT staffing/hardware support, equipment costs, replacement costs, etc.) as well as average and peak data storage and usage requirements factoring in growth, and implementation costs of any new software solution. The calculation is further complicated when data service providers start offering license fees by the hour instead of fixed one time or annual fees - another calculation around the number of usage hours required to break even becomes necessary.
Also to be factored in is whether security, performance, availability and reliability concerns outweigh the many cloud benefits including rapid scalability and SAAS friendly model. Not everyone is convinced commercial cloud offerings currently meet all the requirements: Cloud computing not fully enterprise-ready, IT execs say - though enough people are convinced to make for some nice looking graphs; and AWS customer numbers are now approaching half a million.[Read More]
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..
There are two forums where you can post Data Studio questions and look for announcements, take your pick..
IBM Data Studio: Get started with Data Web Services
pureQuery: IBM's new paradigm for writing Java database applications.
Increase productivity in Java database development with new IBM pureQuery tools, Part 1: Overview of pureQuery tools
Common Development Tool
email for now. (Update: I since relented and switched comments back on.)[Read More]
gbowerman 100000B5T0 2,640 Views
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...
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…[Read More]
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.
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
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
4400 N 1st St, Suite 100
San Jose, CA 95134
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.
Here is a final list of planned talks and demos:
Bring your problems - 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
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.
We're planning another Beaverton Tech Fair for May 20th. Not many details yet but here's what we have so far...
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]
gbowerman 100000B5T0 4,126 Views
Here are more details for the Beaverton Tech fair on May 20th...
Free Informix Tech Fair
Talks include the following topics:
IIUG President Stuart Litel
IBM Informix Engineers
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:
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, Amazon
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..