Repository Indexing

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
adasgupta123
Participant
Posts: 42
Joined: Fri Oct 20, 2006 1:58 am

Repository Indexing

Post by adasgupta123 »

Hi All,

Can you plz explain what is repository indexing and why rebuilding of
index is required?
This topic I could not find in the manual.I tried to find in this forum also,
but could not find the detail explanation.I need to know this
because I need to reindex for a project.Plz help.

Thanks in advance.

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

Post by ray.wurlod »

The repository is a database schema and has several tables in which things are stored.

To enable certain constrained queries to run faster, there are indexes maintained, for example on CATEGORY.

Occasionally these can get out of date, due perhaps to contending updates. It is then that the indexes need to be re-built.
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