help on REINDEX

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
rajendharreddy
Participant
Posts: 46
Joined: Tue Aug 21, 2007 5:39 am
Location: Bangalore, India

help on REINDEX

Post by rajendharreddy »

Hi,

I would like to know more information about REINDEX like

1. how frequently we can REINDEX on the whole project.
2. can we REINDEX if a hash file is corrupted.

I did a search on the forum but didn't much information.

Can anyone help me on this?

Thanks.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

REINDEX only when jobs mysteriously disappear from the Director or won't properly show. Corrupted hashed files have nothing to do with REINDEX.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DS.REINDEX rebuilds indexes only on Repository tables that contain design-time metadata. Unless you are having problems with the Repository there is no need to use this command, as Ken noted.

Also, as Ken noted, this command does not repair corrupted hashed files. If you have created indexes on a hashed file and there is a VOC pointer to it then it would, but I'll bet that you haven't.
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