RE: Using dostats after upgrade to 9.2x in place

Posted in 2000

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Server Administration

Jarman, Andy — Fri, 22 Sep 2000 14:57:29 +0100 — source: Informix-list mailing list archive (1991-1998)

Art, Any ideas on how to delete this redundant SP? It seems to have a leading space. Makes it somewhat difficult to delete through the normal syntax (DROP PROCEDURE...) Andy Jarman -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: 21 September 2000 16:15 To: informix-list@iiug.org Subject: Using dostats after upgrade to 9.2x in place NOTICE NOTICE NOTICE NOTICE NOTICE NOTICE NOTICE NOTICE NOTICE Note that if you upgrade an existing 7.xx server to 9.2x in place the DBA stored procedure systdist will be renamed oldsystdist and a new version installed. There are objects referenced in oldsystdist that have changed sufficiently to prevent it from re-optimizing/compiling which will cause dostats to report the error and exit without updating stats for other stored procedures in that database. This procedure exists in each and every database. The fix is to DROP PROCEDURE oldsystdist; in each database. Art S. Kagel