Index rebuilt - Time Estimation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam Durai - 29 Jun 2006 19:39 GMT

A paritioned table ( spead across 7 logical partitions) has around 2
billion rows. I added around 2 million rows newly using db2 load
utility but the the table is in index build phase for the past 3 hours.

Is there is any method available
[1] To find out the time it would take to complete the index rebuilt
[2] To find our the % index rebuilt completion.

Env : DB2 UDB V8.2 FP 5, AIX 5.3

Thanks,
Sam

Reply to this Message

Shashi Mannepalli - 30 Jun 2006 03:10 GMT

Sam:

Check the db2diag.log and see if that tells you something like

ADM5540W Beginning index rebuild of "1" indexes on table "XXXXX".

The percentage ...try db2 inspect command and format the output.

cheers...
Shashi Mannepalli

> A paritioned table ( spead across 7 logical partitions) has around 2
> billion rows. I added around 2 million rows newly using db2 load
[quoted text clipped - 8 lines]
> Thanks,
> Sam

Reply to this Message