What activities are performed when indexes are rebuilt ?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

What activities are performed when indexes are rebuilt ?

Post by zulfi123786 »

Is there any documentation that details the activities performed when indexes are rebuilt (DS.TOOLS ----> option 2)

And also which repository tables are reindexed.

Thanks
- Zulfi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The report produced by DS.REINDEX command (which is invoked from the DS.TOOLS menu) documents everything that happens. In short, for each hashed file mentioned its indexes are dropped, re-created and re-populated from the base data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply