Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ben Thompson — — source: Usenet: comp.databases.informix
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.