Rebuild All Indexes
Hi,
My customer has a CLM server which RTC, RRC and RQM 4.0.6 installed on it. Now, they want to split products into a different servers. Also they will change Operating System (Windows to Linux) so I need to rebuild all indexes. Can I rebuild indexes while current / Windows server running? I mean users will continue their daily usage while I run rebuild indexes in new server?
Thank you.
My customer has a CLM server which RTC, RRC and RQM 4.0.6 installed on it. Now, they want to split products into a different servers. Also they will change Operating System (Windows to Linux) so I need to rebuild all indexes. Can I rebuild indexes while current / Windows server running? I mean users will continue their daily usage while I run rebuild indexes in new server?
Thank you.
Accepted answer
It is not true that you necessarily have to rebuild any index to do so.
- The Text Indexes are stored in files. You can and should move the indexes to some fast network access storage or copy the files over to the new server while it is down. If the path to the index location is set correctly in the teamserver.properties and the files can be read and written by the user context that runs the server, there should be no need to recreate those files; you should use an absolute path to the index files and also include them in your backups
- The database indexes don't have to be changed if the database remains the same. If not it depends if the DBMS vendor allows to move the DB to a different system using backup/restore this should keep the indexes untouched. If not and you need to do a DB export and re-import, the indexes should be recreated in that process as far as I know
For additional information see https://jazz.net/library/article/1271 https://jazz.net/library/article/1272 and check the repotools commands. Also see https://jazz.net/wiki/bin/view/Deployment/BackupCLM
I think most of the index related commands require the server to be down.
Comments
