Re indexing a datastage project

techiexavier · Post by **techiexavier** » Tue Nov 03, 2015 11:27 pm

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!

chulett · Post by **chulett** » Wed Nov 04, 2015 8:25 am

I've never found any links or seen any details other than "it rebuilds the indexes in the project". That was enough detail for me.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 04, 2015 3:36 pm

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.