Stored Procedures on SE Runtime
Posted in 1995
Topics: Performance & Tuning, Installation, Setup & Upgrades, Stored Procedures & SPL, Server Administration
Aaargh! Has anyone shared this experience?
We are authorized Informix developer-resellers using Standard Engine 5.01 on
AIX. We recently took advantage of the fact that Informix offers a lower cost
"runtime" version of the engine to deliver a client-server system to a
customer on a tight budget. Originally, no stored procedures were part of this
system.
Recently, we tried to improve the partitioning and performance of this system
by adding a stored procedure. We developed and tested it on our Informix
installation, a full development version of SE, at the same release number as
the customer's runtime.
But when we went to create the stored procedure on the customer's system, the
runtime choked on the DDL. We thought that perhaps the runtime would not allow
_creation_ of the stored procedure, so we used the full product to create the
stored procedure in the database, then went back into dbaccess under the
runtime to issue an EXECUTE PROCEDURE. It promptly died, saying "Cannot read
system catalog (sysprocedures)."
A call to Informix technical support yielding the following.
Me: "I'm having a problem with the runtime product."
Informix: "I need a serial number."
Me: "I'm onsite at a customer location. That will take a while."
Informix: "Well, I've got to have it before I can talk to you."
Me: "OK ... [run myself ragged for a while] ... here it is ..."
Informix: "Runtime is an unsupported product."
Me: "What?!"
Informix: "We don't provide support for runtime at all. You can't buy it, we
don't have it."
Me: "Then why the heck did I have to get a serial number??!! Can't you at
least tell me whether stored procedures are supposed to work with runtime?"
Informix: "No, we don't know anything about runtime. It's not in our database."
We are now trying to work through Informix Sales channels to figure out why
the !@#$% they are peddling a product that they disavow completely and
entirely. It seems now that not even Sales seems able to define for me just
what the runtime product is, and how it might differ from the full product.