This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
A few month ago I wrote an article ( http://informix-technology.blogspot.pt/2012/03/why-or-why-not-prque-ou-porque-nao.html) where I picked on a twit made by someone who was asking why “some people still use Informix”… And hopefully I changed the point to “why shouldn’t you use it”?
Today there was an IBM webcast that raised the same point. I tried to att…
On my way to work this morning, there was a news story on the radio about a new cologne called Sushi. The product description explains this unique product:
Not what you think it would smell like! Demeter’s Sushi is the fresh scent of just cooked sticky rice and straight from the seaside seaweed, laced with hints of ginger and lemon essences. Simply delectable… after all, if it smelledlike fish, would you wear it?
This reminded me of an old joke about Informix Software (the company) and how they marketed their products:
If Informix sold sushi, they would call it cold, dead fish.
Now, I know that joke has been told many times for many different companies, but the first time I heard the joke it was in reference to Informix so for me, they get to own the joke.
I then started to think about two troubling conversations I recently had.
The first was with someone who emailed me at informix-dba.com asking if I knew of any Informix consultants looking for a short term gig. During our conversation he wanted to ask some questions about Informix since he…
On my way to work this morning, there was a news story on the radio about a new cologne called Sushi. The product description explains this unique product:
Not what you think it would smell like! Demeter’s Sushi is the fresh scent of just cooked sticky rice and straight from the seaside seaweed, laced with hints of ginger and lemon essences. Simply delectable… after all, if it smelledlike fish, would you wear it?
This reminded me of an old joke about Informix Software (the company) and how they marketed their products:
If Informix sold sushi, they would call it cold, dead fish.
Now, I know that joke has been told many times for many different companies, but the first time I heard the joke it was in reference to Informix so for me, they get to own the joke.
I then started to think about two troubling conversations I recently had.
The first was with someone who emailed me at informix-dba.com asking if I knew of any Informix consultants looking for a short term gig. During our conversation he wanted to ask some questions about Informix since he f…
Some things to note about IIUG 2013:
Registration is now open - Register before January 17, 2013 to get the $225 Early Registration Discount.
Register as an IIUG member and receive and additional $100 discount.
The IIUG 2013 Cost Justification Document is now available if you need some help convincing your boss that IIUG 2013 is an effective w…
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
This post’s title is an allusion to “It’s the economy, stupid” phrase that become popular in one of the USA presidential campaigns. It seems appropriate for today, and for the short problem description I’m going to describe.
Today, while working on a customer site, I was confronted with the following scenario:
A developer complained that two programs working against a non-logged database (yes, some customers still use them…) raised errors (-243/111) while DELETEing an overlapped result set. The customer DBAs replied the same as I probably would: “That can happen even on a non-logged database. Please use some sort of “SET LOCK MODE TO WAIT…’ “
But the program was already using it… So… why does it happen?!
Well… we all know that there are some differences between logged and non-logged databases, but a complete list is hard to find. One is that we cannot change the isolation level in a non-logged database. It raises an error stating that the only mode allowed is DIRTY READ. But it does accept the SET LOCK MODE WAIT statement, so we would expect it to enforce it…
In short, what was I missing, apart from a possible, but improbable bug? The answer is, I’m missing a careful analysis of the error codes! And I should be ashamed, because I have recommended many times that people MUST always look carefully into the errors, before trying to create explanations for problems that they haven’t qualified. Precisely what I was doing… So let’s see some facts:
The database server cannot set the file position to a particular row
within the file that represents a table. Check the accompanying ISAM
error code for more information. A hardware error might have occurred,
or the table or index might have been corrupted (truncated). Unless the
ISAM error code or an operating-system message points to another cause,
run the oncheck utility (secheck with IBM Informix SE or tbcheck with
IBM Informix OnLine) to check and repair table and index.
The ISAM processor cannot locate the requested record. For C-ISAM
programs, no record was found with the requested index value or record
number, depending on the retrieval mode in use. Make sure that the
correct index is in use. For SQL products, see the SQL error message or
return code. Probably no row was found for thi…
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
English version:
Very quick post to document something which is not properly documented. While working at a customer I had the need to change the LRU cleaning parameters (min_dirty, max_dirty) without stopping the engine. The fine manual says this can be done by dynamically change the AUTO_LRU_TUNING parameter:
onmode -wm AUTO_LRU_TUNING=1,min=0.3,max=1
And th…
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
English version:
Very quick post to document something which is not properly documented. While working at a customer I had the need to change the LRU cleaning parameters (min_dirty, max_dirty) without stopping the engine. The fine manual says this can be done by dynamically change the AUTO_LRU_TUNING parameter:
onmode -wm AUTO_LRU_TUNING=1,min=0.3,max=1
An…
This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português
In recent weeks I’ve received or seen several requests for information from newcomers to Informix. This was requested directly while working at a customer, through direct email (blog driven) and was a public request in the IIUG mailing list. I suppose I could create a great blog post talking about how this means that Informix is raising more and more interest, but sharing information was the main reason to create this blog and I intend to stick with that. So, the purpose of this article is simply to share some information with the hope that it can help people who is interested in finding more about Informix. So my suggestions are (no special order):
As Fernando Nunes already pointed out, 11.70.xC6 was released October 23. New releases always pique my interest and the first thing I do is checkout the What’s New page in the documentation. After I sift through the new features list and mentally classify them into “Yes! Finally”, “Useful”, “Meh” and “I’ll Bet Someone Needs That, But I Don’t” groups I like to take a look at t…
IIUG 2013 – The Premier Technical Conference for Informix Fanatics – will return to beautiful Southern California and the San Diego Mission Valley Marriott April 21 – 25, 2013.
The IIUG 2013 Conference Planning Committee is currently accepting presentation abstracts until November 15, 2012. If you would like to speak at this year’s conferenc…
Vercelletto.com © 2013. All rights reserved.
