Index Rebuild option

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
raji
Participant
Posts: 40
Joined: Tue May 16, 2006 6:06 am

Index Rebuild option

Post by raji »

Hi,

In paralle we have the index rebuild option.

Like wise whats the equivalent option in Server jobs.

Will anyone please give me a suggestion ?

Regards,
Raji
Raji

Nothing is impossible because impossible itself
says I'm Possible
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Indexes, and the rebuilding thereof, is associated with the Repository in which ALL job types (and other objects, such as Routines) are stored. Therefore, there is no different way to do it for server jobs versus parallel jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ameyvaidya
Charter Member
Charter Member
Posts: 166
Joined: Wed Mar 16, 2005 6:52 am
Location: Mumbai, India

Post by ameyvaidya »

I suspect that this post is about the Oracle Enterprise stage in PX VS the Oracle load stages in Server?
:?
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As do I. Server has no such automatic option. You would, instead, need to code something equivalent 'after sql' or in some manner of separate step.
-craig

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