11.70 - Recreating index

What's force the instance (11.70 FC1 , Linux ) to recreate a index ??? Some messages like this: Recreating index: 'dbsname:"owner".tabname-idxname'. Appear on online.log after start the instance... Cesar

When an index is created, it is not recoverable until a checkpoint is issued. If the checkpoint is not issued and the server is bounced, then the index will be rebuilt. This will not occur if you set index page logging. From: "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> To: ids@iiug.org Date: 04/01/2011 11:38 AM Subject: 11.70 - Recreating index [23300] Sent by: ids-bounces@iiug.org What's force the instance (11.70 FC1 , Linux ) to recreate a index ??? Some messages like this: Recreating index: 'dbsname:"owner".tabname-idxname'. Appear on online.log after start the instance... Cesar ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

If you create an index, but before the next checkpoint the engine is abnormally shutdown. Instead of adding each index item row by row in a serial fashion through logical recovery, the informix server waits to the end of logical recovery and builds the index utilizing the parallel index build. In addition there is optimization for create, drop, scenario, see below: An example: checkpoint create index ix1 create index ix2 drop index ix1 logical recovery ends create required indexes (only ix2) John F. Miller III STSM, Embedability Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 04/01/2011 09:37:55 AM: > [image removed] > > 11.70 - Recreating index [23300] > > Cesar Inacio Martins > > to: > > ids > > 04/01/2011 09:38 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > What's force the instance (11.70 FC1 , Linux ) to recreate a index ??? > > Some messages like this: > Recreating index: 'dbsname:"owner".tabname-idxname'. > > Appear on online.log after start the instance... > > Cesar > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thanks John and Madison for yours answers! Is exactly what happen here... Regards Cesar On 1/4/2011 15:54, John Miller iii wrote: > If you create an index, but before the next checkpoint the engine is > abnormally shutdown. Instead of adding each index item row > by row in a serial fashion through logical recovery, the informix > server waits to the end of logical recovery and builds the index > utilizing the parallel index build. > > In addition there is optimization for create, drop, scenario, see > below: > > An example: > > checkpoint > > create index ix1> > create index ix2> > drop index ix1> > logical recovery ends > > create required indexes (only ix2) > > John F. Miller III > STSM, Embedability Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 04/01/2011 09:37:55 AM: > >> [image removed] >> >> 11.70 - Recreating index [23300] >> >> Cesar Inacio Martins >> >> to: >> >> ids >> >> 04/01/2011 09:38 AM >> >> Sent by: >> >> ids-bounces@iiug.org >> >> Please respond to ids >> >> What's force the instance (11.70 FC1 , Linux ) to recreate a index ??? >> >> Some messages like this: >> Recreating index: 'dbsname:"owner".tabname-idxname'. >> >> Appear on online.log after start the instance... >> >> Cesar >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >