Reindexing V8 ?

DS_FocusGroup · Post by **DS_FocusGroup** » Wed Jun 08, 2011 10:50 pm

Hey all,

Can someone please help me understand how can we reindex in the new vesion of datastage. Before release 8 it could be done using the command prompt using REINDEX ALL command as far as i rememeber.

Many thanks.

pandeesh · Post by **pandeesh** » Thu Jun 09, 2011 2:07 am

Is it not possible via Web Console for Information Server?

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2011 5:14 am

Nothing has changed, but the command is (and was) DS.REINDEX ALL.

This indexes the local repository in the project only (which was the only repository in versions earlier than 8.0).

chulett · Post by **chulett** » Thu Jun 09, 2011 7:24 am

What is going on? What is making you feel that you need to 'reindex' anything?

DS_FocusGroup · Post by **DS_FocusGroup** » Thu Jun 09, 2011 10:17 pm

The jobs are taking along time to compile now.. as far as i remember i could change the logging method from tables back to the old one (RT_XXX) which made the compilation time less.. does anyone remeber where the flag RT_LOGGING something like this used to be set to 1 for this?

chulett · Post by **chulett** » Thu Jun 09, 2011 11:10 pm

There are several posts here on the subject of "RTLogging", for example one here. That won't help speed up compiles, however. Nor would reindexing.

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Jun 10, 2011 12:46 am

ummm any other tips pertaining to this ?

chulett · Post by **chulett** » Fri Jun 10, 2011 6:47 am

I'm not really sure, hence my lack of specifics in the hope someone else would respond. We know sometimes there's a concurrent license issue if we are talking jobs with transformer stages - i.e. only one C++ compile at a time is allowed so it's not that it takes longer to do the actual compile but rather you wait longer for your turn. And before you ask, no I don't know how to check. A search here may turn up the details, however.

Other things that come to mind... does this apply to all jobs? All projects? How busy is your system? How full is your partition? Reaching a limit on allowed directories, inodes, etc? Large number of jobs in the project? Hopefully someone else will chime in here.