rebuild Index

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
diamondabhi
Premium Member
Premium Member
Posts: 108
Joined: Sat Feb 05, 2005 6:52 pm
Location: US

rebuild Index

Post by diamondabhi »

If we rebuild indices from DS.Tools, does it rebuild indices in the selcted project or all the projects on that server.

Thanks,
Diamondabhi.
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
diamondabhi
Premium Member
Premium Member
Posts: 108
Joined: Sat Feb 05, 2005 6:52 pm
Location: US

Post by diamondabhi »

Never mind, got the answer. It just rebuilds the current project.

Thanks.
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... and only if you have exclusive access!

If you don't you can leave the repository database in a worse state than when you issued the command. Luckily this can be corrected by another reindexing command, this time with exclusive access to the project.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Exactly. Nothing more distressing than rebuilding an index to fix a small problem and suddenly having what looks like a BIG problem - an empty repository. :shock:

That's when you really kick everyone out and run it again.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply