Informix - Problem description
Problem IT32953 | Status: Closed |
UPDATE STATISTICS CAN FAIL WITH -721 OR -597 IF UPDATE STATISTICS FOR PROCEDURE IS RUN | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Stored procedures created in IDS version prior to 12.10.xC4 can cause -721 errors or -597 errors during update statistics if the server is upgraded to a version greater than or equal to 12.10.xC4. Consider the procedure named "myprocedure" that was created in 11.50 and then ultimately upgraded to 12.10.xC7 for example or even to 14.10.xC1. If you connect to the database and run update statistics, you might see the following errors: $ dbaccess mydb - > update statistics; 721: SPL routine(informix.myprocedure) is no longer valid > update statistics for procedure myprocedure; 597: [Internal] Premature End Of Buffer Rebuilding procedure will remedy the situation, but is not always a simple task for databases with a large number of stored procedures. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC1. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC2. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC1. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC2. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC2. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.05.2020 08.06.2020 08.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |