Status of Fulltext Index Creation Process

[Former Member]

Greetings!

We are creating a fulltext index over a jdbc/java call. We need to wait for the index creation to complete. How can I tell when the process is complete?

Thanks!

Mukunda

[mfath]

Hi Mukunda,

you can monitor the status of the indexing process via

SELECT * FROM SYS.M_FULLTEXT_QUEUES;

Regards, Markus

[Former Member]

Thanks Markus!

We did some testing..The index entries are inserted into SYS.M_FULLTEXT_QUEUES when the index process is started and not when it is ended.

This table provides information such as document, indexed_document, queue_document, error_document counts. Am I missing something?

Regards,

Mukunda

[mfath]

Hi Mukunda,

the indexing is finished once the queue is empty.

So you need to check for QUEUE_DOCUMENT_COUNT = 0.

Regards, Markus

[Former Member]

Perfect! Thanks Markus.