.srt file

[raviraju]

can you help me what is this .srt file in index rebuild?

 

[RealHeavyDude]

It is a temporary sort file that gets deleted when the index rebuild is done. Depending on the OS ( you don't say anything about your environment ) it might be visible or not ( on *nix it is an unlinked file per default - you need to specify the parameter -t to see it ). Per default it gets created in the working directory unless you specify the location with the parameter -T. You need to make sure to have enough space available for the sort files when doing an index rebuild - otherwise the index rebuild will crash leaving the database in an unusable state. You must then re-run the index rebuild until you succeed.

Heavy Regards, RealHeavyDude.

 

[TomBascom]

RHD is describing the srt* temp files.

You may be asking about the dbname.srt file that can be used to tell index rebuild where to put those srt* files. You can either create the file by naming it dbname.srt or you can use the -SS option:

http://knowledgebase.progress.com/articles/Article/P55740?popup=true

(Caution: -SS does not always work properly if the .srt file is not named dbname.srt where dbname is the actual db name.)