Is it possible to monitor the progess of the Purge process during a StarTeam upgrade?

0 Likes

Problem:

Is it possible to monitor the progess of the Purge process during a StarTeam upgrade?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2005 R2
  • Product Component: StarTeam Server
  • Platform/OS Version: All



In order to complete the upgrade from ST 2005 R2 to 2006 it is required to run a Purge on the database. The purge process can take a long time to complete, depending on the size of the database and it is difficult to monitor the progress of the Purge process. However, this can be done manually using the following steps,

  1. Before starting the Purge execute the following SQL statement

    SELECT COUNT(*) FROM syn_file

  2. Record the number of file revisions returned by this statement as TOTAL_FILES.

  3. Start the Purge and execute the following SQL statement

    SELECT COUNT(*) FROM purged_files_temp

  4. Record the number of files that need to be purged as FILES_TO_PURGE.

  5. Periodically execute the SQL statement from step 1.

    SELECT COUNT(*) FROM syn_file

  6. Record the number of files as ACTUAL_FILES


To monitor progress note that

  • FILES_TO_PURGE does not change
  • TOTAL_FILES will decrement

  • FILES_TO_PURGE = (TOTAL_FILES - ACTUAL_FILES)
  • When FILES_TO_PURGE = 0 (zero) this means that the Purge process has completed.

The Purge process should progress evenly and slowly and you may even be able to observe singe file decrements. During the Purge the database should be under medium load and the fileserver should be under light load. As a rough guide, Purging of 1000 files takes about 1 hour.


Old KB# 27373
Comment List
Related
Recommended