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.7
IDS: 7.31.UD5
Problem:
SQL statement error number -750.
Invalid distribution format found for sn
I have some programs always hitting the sql error -750
on those heavyly used tables and it was just happen on
few weeks back. The programs were never been changed
at all and the only changes was the load of
transactions on those heavyly used tables were
increased at least 20-30% due to the business grow. I
was encountered the same problem on version 7.31.UC2
as well.
I have tried to run the update statistics with the
following format on those heavyly used tables on daily
basic. However, the problem was still persisted.
update statistics low for table <tabname> dropdistributions;
update statistics medium for table <tabname>distributions only;
Is there other method to resolve the error?? Any
recommendation and advise are highly appreciated.
Thanks & regards,
Miyaki
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
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.