Re: create index online
On 5 Nov, 08:24, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi all, > > I created a new index ONLINE. Thought that would cause no problems in > production. > > However, one program reported errors: > > > > > Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > 464. > > Date: 04.11.2009 Time: 18:51:54 > > > Program error at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > 464. > > SQL statement error number -710. > > > Table (informix.ap_da_v1) has been dropped, altered or renamed. > > > SYSTEM error number -21523. > > > Cannot proceed with a dirty/modified table data dictionary entry. > > > SQL statement error number -710. > > > Table (informix.ap_da_v1) has been dropped, altered or renamed. > > > SYSTEM error number -21523. > > > Cannot proceed with a dirty/modified table data dictionary entry. > > Version of IDS is 11.50.FC5. > > Is this a bug or did I understand something wrong? > > TIA, > Reinhard. What are the sql statements that are producing the -710 errors? http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.sqls.doc/ids_sqs_0441.htm "the database server does not support any other DDL operations on the indexed table, until after the specified index has been built without errors" http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.adref.doc/ids_adr_0026.htm "By enabling the AUTO_REPREPARE configuration parameter, you can avoid many -710 errors and reduce the number of reprepare and reoptimize operations that you must perform manually after the schema of a table is modified" It says you can reduce the number of reprepare operations that are required, not eliminate them completely. https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/automatic_re_prepare_in_ids says "You can still get -710 errors in your applications in one of the following scenarios: * The number and type of columns in your SELECT list have changed. * If you are executing a prepared DDL statement, you might get -710 errors. * A rare race condition in the server can lead to a -710 error.