Rebuild All Indexes
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
- 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
Hi Ralph,
It says pretty much what I have said
It is not precise on the files on if you have to though. It says you should. I am not sure about the rationale. The content should be the same. I think I have used Derby/Tomcat setups and moved the backups between OS's without seeing issues. However since this is a production setup you might want to make sure and rebuild the text indexes.5. Copy or Rebuild Indexes
The index files are referenced in the teamserver.properties file with relative path locations (e.g. com.ibm.team.fulltext.indexLocation=conf/qm/indices/workitemindex, com.ibm.team.jfs.index.root.directory=indices). So these entries should not have to change when you create new install areas. But after a new installation, the index files under these directories would not match. So you must copy these files from the source to the target. If the operating systems are different, you should rebuild the indexes with repotools commands. This will take longer and must be done with the database running and the server shut down.
It says that the server needs to be down.
So, Can I run rebuild indexes command while current PROD server is running? to make shortest blackout time.