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.
Dear all,
OS: Solaris 2.6
IDS: 7.31.UC2
Problem:
SQL statement error number -750.
Invalid distribution format found for sn
I have shopfloor application (with multiple executable
4gl programs) running on the IDS database engine
(7.31.UC2). Some of the 4gl programs always hitting
the sql error -750 on those highly used tables. I know
one of the method to resolve the error is to re-build
the data distribution by running update statistics. I
have a script to run the update statistics for all the
tables with the following format.
update statistics low for table <tabname> dropdistributions;
update statistics medium for table <tabname>distributions only;
Although the above update statistis method is running
on daily basic, but the programs still hitting the
-750 error.
Is there other method to resolve the error?? Any
recommendation and advise are highly appreciated.
Thanks & regards,
Miyaki
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
sending to informix-list
miyaki wrote:
> OS: Solaris 2.6
> IDS: 7.31.UC2
> Problem:
> SQL statement error number -750.
> Invalid distribution format found for sn
>
> I have shopfloor application (with multiple executable
> 4gl programs) running on the IDS database engine
> (7.31.UC2). Some of the 4gl programs always hitting
> the sql error -750 on those highly used tables. I know
> one of the method to resolve the error is to re-build
> the data distribution by running update statistics. I
> have a script to run the update statistics for all the
> tables with the following format.
>
> update statistics low for table <tabname> drop> distributions;
> update statistics medium for table <tabname>> distributions only;
>
> Although the above update statistis method is running
> on daily basic, but the programs still hitting the
> -750 error.
>
> Is there other method to resolve the error?? Any
> recommendation and advise are highly appreciated.
You are too many revisions behind for comfort - upgrade to 7.31.UDx
for a sufficiently large value of x (about 5 or 6, IIRC).
Whether that will resolve this particular problem or not I'm not sure,
but there's at least a reasonable chance it will, and the upgrade is
highly desirable for other reasons too.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
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.