Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2011-11-27T21:37:05Z by MatthiasNicola
RD6G_werwer_wewerwer
1 Post
ACCEPTED ANSWER

Pinned topic URGENT: Full-text indexing

‏2011-11-25T16:47:24Z |
Hi all,
I have a db2 pureXML database with 2,5 million XML documents.
I am trying to implement a FULLTEXT index on these documents with db2text.

I followed the intructions but when I run the command:

db2text update index...

the computer stars the processing but never ends (It has been runnig for 7 days).
I think this is too much time. Thr question is:

1. Is it normal to take so much time?
2. Is there any way to know if the database is in fact indexing the data (the CPU and memory comsumtion are practically null)

MANY THANKS IN ADVANCE !!!
Updated on 2011-11-27T21:37:05Z at 2011-11-27T21:37:05Z by MatthiasNicola
  • MatthiasNicola
    MatthiasNicola
    321 Posts
    ACCEPTED ANSWER

    Re: URGENT: Full-text indexing

    ‏2011-11-27T21:37:05Z  in response to RD6G_werwer_wewerwer
    Hi there,

    if you have an urgent problem it would be best if you would open a ticket (PMR) with IBM to get dedicated help.

    7 days certainly sounds too long. However, the time to build a text index also depends on the size of the XML documents, your hardware, and the system configuration such as how many disks for the data vs. text index.

    You say that CPU usage is close to zero. How about I/O?
    Did you check if there are any applications waiting on locks?
    If anything hangs then it's hard to diagnose this without more detailed information. Getting IBM support involved would be best.

    Thanks,

    Matthias


    Matthias Nicola
    http://www.tinyurl.com/pureXML
    http://nativexmldatabase.com/