At 18:27 01/01/18 -0800, Patrick McDonough wrote:
Hi Patrick.
Please execute this following SQL.
update statistics for procedure
I resolved -640 error.
Regards.
>Upgraded a 7.31.UC6 server to 7.31.UD1(Solaris 2.6) and get the following..
>
>"-640 QPlan sanity failure (2028.0). " whenever a stored proc is executed.
>
>Update statistics fixes it initially, but it still occurs periodically.>
>Patrick McDonough
>Intraware
>
>
--
Tsutomu Ogiwara
Technical Group & Red Brick Group, Informix Sales Promotion Dept
CTC, ITOCHU Techno-Science Corporation
Yasukuni Kudan-Minami Bldg., 2-3-14, Kudan-Minami Chiyoda-Ku TOKYO,
102-0074 JAPAN
Phone:+81-3-5212-4891 Fax:+81-3-5212-4889
E-mail:Tsutomu.Ogiwara@ctc-g.co.jp / tsutoo@my-deja.com