Informix - Problem description
Problem IT10545 | Status: Closed |
LINUX: WITH THE FIX FOR APAR IT06767 AN UPDATE STATISTICS HIGH ON TABLE BIGGER THAN 1.1 BILLION OF ROWS CAN CRASH THE ENGINE | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Running the 'update statistics high' command on a table with more than 1.1 billion of rows can lead to the engine crash if there is enough DS_TOTAL_MEMORY memory for sorting to be done in one pass in memory. The stack of the failing thread looks like this: (oninit) srtquick (oninit) srtexec (oninit) execsort (oninit) usbldist (oninit) do_distrib (oninit) ustable (oninit) ustatistics (oninit) excommand (oninit) sq_execute (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All 11.70 and above users with large memory. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.70.xC9 * **************************************************************** | |
Local Fix: | |
Setting the environment variable PSORT_NPROCS > 1 in the oninit environment and restarting the engine can prevent the problem. | |
Solution | |
Problem Fixed In IBM Informix Server 11.70.xC9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.08.2015 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
11.70.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |