IDXBuild on 75GB database

MikeHorn

New Member
Hi

AIX 5.3 Progress 91.E02

Before I start I'd just like to state that I know I'm probably not doing this as efficiently as possible, but I'm loading the database for an evaluation and doing other things whilst I wait...

After a binary dump & load of data I am running a full IDXBuild on our database. Unfortunately the load is throwing up a lot of errors - they've been scrolling down my screen for almost a day now!. (The table in question took up 6.3GB on the source database and has a lot of indexes, not all of which are strictly necessary)

Although the errors are still scrolling down my screen, the idxbuild process _should_ have completed by now, but the proutil process is still present when I do a ps -fu<userid>.

My question is this - is there any way to tell whether the idxbuild has indeed finished or must I wait for the errors to stop scrolling.
PHP:
TIA
Mike
 
If ps says that it is still running then it is still running...

Spewing errors to the screen introduces latency. You might find it faster to redirect errors to a log file and then "tail -f" the log file.
 
Back
Top