index creation time?
Abrar Rashid asked how to find index creation time and progress. Art Kagel said index creation is logged, and with LOG_INDEX_BUILDS set the page writing is logged too, so onlog could be followed (with a warning that onlog on the current log can block transactions). Asked for a way to estimate the time, Art replied no.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hello, Is there any method which is used to find index creation time and progress of index. Thanks in advance.
Index create's are logged, at least the event is. If you also have
LOG_INDEX_BUILDS set in your ONCONFIG file, then the entire process is also
logged from the point at which index pages begin to be written (so once data
collection and sorting are finished). If you have a rough idea of the
ultimate size of the index in pages, you can follow along with onlog
(warning: using onlog on the 'current' logical log file can block
transactions from writing to the log).
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Mon, Mar 14, 2011 at 2:33 PM, ABRAR RASHID <mabrar@i2cinc.com> wrote:
> hello,
>
> Is there any method which is used to find index creation time and progress
> of
> index.
>
> Thanks in advance.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf307f38162e643f049e75a189
any way to estimate this time?
No. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Mar 14, 2011 at 2:58 PM, ABRAR RASHID <mabrar@i2cinc.com> wrote: > any way to estimate this time? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec53aeb8087abd5049e7604f8