Hi All,
I was trying to find what exactly happens when admin re indexes a project.
For couple of project corrupt issues the solution/work around was given in the IBM support docs as to re index the DS project, but no details to tell what exactly happens or what is the output of the re index option.
Can any one please share links or details.
Thanks!
Re indexing a datastage project
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Tue Feb 28, 2012 12:59 pm
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The local DataStage repository is a series of tables, some of which have indexes. Rebuilding those indexes involves dropping the indexes, re-creating and re-populating them from data in the base table.
The DS.REINDEX paragraph (=script) can be used to re-index just a specific table or all tables.
The DS.REINDEX paragraph (=script) can be used to re-index just a specific table or all tables.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.