Dostats issue with functional index

#1

Hi All,

I have been having a problem with dostats where I can't use it on a
particular table:

informix@server:~> dostats -d dbname -t tablename

Working on database: dbname.
tablename(MEDIUM)...SUCCESSFUL
(HIGH)...
Cannot Update statistics for table: tablename, column ;
SQLCODE = -201, ISAM = 0, POS = 44
UPDATE STATISTICS HIGH FOR TABLE tablename ();

It turns out that the problem is that there is a functional index on
this table on one of the varchar columns in this table:

create index "informix".upper_name on "informix".tablename ("informix"
.toupper(name)) using btree ;

CREATE FUNCTION "informix".toupper (instring varchar(255))
RETURNING varchar(255) WITH (not variant);

RETURN upper(instring);
END FUNCTION
;

Any ideas, other than dropping and recreating the index before and after
using dostats?

Ben.

#2

Art S. Kagel replied:

Quote:

This is a known problem, at least known to me. I have the fix but my
company is still debating whether they will permit me to continue to
publish the utilities package. Meantime, if you or anyone else, is
having this problem with functional indexes please email me directly
(kagel (AT) bloomberg (DOT) net) and I'll send you the next release which has the
fix. Ben, I need a valid email address, so email me. Hopefully this
will get cleared up soon and I can post a long overdue update to utils2_ak.

Many thanks for this. I have replied by e-mail but my real address is
the address I use to post with "no" and "spam" removed from the middle part.

Ben.

#3

On Wed, 17 Aug 2005 15:14:09 +0100, Ben Thompson
<ben (AT) nomonitorsoftspam (DOT) com> wrote:

Quote:

Art S. Kagel replied:
This is a known problem, at least known to me. I have the fix but my
company is still debating whether they will permit me to continue to
publish the utilities package. Meantime, if you or anyone else, is
having this problem with functional indexes please email me directly
(kagel (AT) bloomberg (DOT) net) and I'll send you the next release which has the
fix. Ben, I need a valid email address, so email me. Hopefully this
will get cleared up soon and I can post a long overdue update to utils2_ak.

Did I miss something here?

JWC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dostats issue with functional index

comp.databases.informix comp.databases.informix

Dostats issue with functional index - 08-16-2005 , 03:41 AM

Re: Dostats issue with functional index - 08-17-2005 , 09:14 AM

Re: Dostats issue with functional index - 08-18-2005 , 09:22 PM