Re-Indexing Data Files

TSM uses a series of index files to keep track of the data entered. These index files enable TSM to quickly find information in the database and sort that information in the desired way.

If TSM's index files become corrupted due to system crashes or other unforeseen events, strange results can be expected. This could manifest itself by an error message occurring or simply not being able to find information that you know is definitely there.

Do not be alarmed if an index problem occurs as the index can be easily re-built from the database. Just as with a reference book, if the index is damaged you can't find anything even though the actual information in the book is still there.

To fix indexing problems you will need to perform a Re-Index. Re-indexing sorts your data so that TSM can locate it.

Note:
1. All TSM users will need to be logged out before applying the update to the TSM directory.
2. Close any integrated applications such as The Accounting Post, MYOB Post, Goldmine Link, Exchange Link or other TSM add-on programs. See the list below*

* If TSM Remote is installed, please run iisreset -stop in cmd on the server computer hosting those sites, and run iisreset -start after update.
* If TSM Mobile is installed, please open service.bat from the start menu, stop the service of “TSM_remote”, and start “TSM_remote” service after update.
* If TSM Live is installed, please open Services manager, stop TSM_LIVE and SQLANYwhere by order.
* If TSM Self Service is install, please open Services manager, stop Apache Tomcat service
Please contact TSM support if you find any problem about switching off the following TSM services.

Performing a Re-Index

If you are sure your database structure is up-to-date, unchecking the Check Data Structure can significantly reduce the time reindexing takes.

Whenever you delete records in TSM, those records are not actually physically removed from the database. As such, TSM can slow down over time as more and more deleted records accumulate in the database. There are 2 Pack options:

No Pack

Do not pack the databases

Pack

Pack the database removing deleted records

Note: You should not normally select either Pack option as records can not be undeleted once they have been packed.

How often should you reindex?

Under normal circumstances, you should reindex TSM data files weekly. However you should also reindex TSM whenever you suspect a problem in TSM or one of your computers or file server unexpectedly shut down while TSM was running.

In general, you should reindex TSM whenever problem emerges, that does not appear to be connected to any changes in your system and before you call for TSM support.

Return to "How to" FAQ

Return to FAQ