Solutions

MCLG: How to rebuild Sybase admin and project databases in Collage



ID:    S123941
Published:    09 July 2005

Operating System(s)

  • All Windows
  • Linux
  • Solaris
  • Unix
  • Windows 2000
  • Windows NT

Product(s)

  • Collage
 

Description

After purging the project audit log, old versions of assets are removed from the project but the actual file size of the database does not get any smaller until a rebuild of the database is done. It is recommended that a backup of the admin or project database be done before rebuilding. See the Merant Collage Installation and Setup Guide for more details on backing up databases.

Resolution

  1. Shut down the Collage Server. See "Starting and Stopping the Collage Server" in the Merant Collage Installation and Setup Guide.
  2. Open a command prompt on the system where the Admin database resides, and go to the following directory:

    Windows: Install Directory\Collage
    The default path is: C:\Program Files\Serena\Collage
    Solaris: Install Directory/collage
    The default path is: /opt/collage
  3. Enter the following command to rebuild the Admin database:

    Windows:
    collage.bat sybase-rebuildadmin <user name> <password> <database name>
    Unix:
    ./collage.sh sybase-rebuildadmin <user name> <password> <database name>

    Where user name is the database user name which by default is dba, password is the database password for this installation of Collage, and database name is the name of the admin database. For example:

    Windows:
    collage.bat sybase-rebuildadmin dba sql admin.db
    Unix:
    ./collage.sh sybase-rebuildadmin dba sql admin.db

    When the command prompt comes back the Admin database is now rebuilt. This may require some time, depending on the system performance and the size of the database.
  4. Enter the following command for each project that you will rebuild:

    Windows:
    collage.bat sybase-rebuildproject <user name> <password> <database name>
    Unix:
    ./collage.sh sybase-rebuildproject <user name> <password> <database name>

    Where user name is the database user name which by default is dba, password is the database password for this installation of Collage, and database name  is the name of the project database. There are three files that make up a project database two .db files and a .log file. Only run the rebuild command against the .db file that does not have _data in the name. For example:

    Windows:
    collage.bat sybase-rebuildproject dba sql site.db
    Unix:
    ./collage.sh sybase-rebuildproject dba sql site.db

    When the command prompt comes back the project database is now rebuilt. This may require some time, depending on the system performance and the size of the database.
  5. Repeat step 4 for each project.
  6. Repeat steps 4 and 5 for each database server in your installation.
  7. Start all of the Collage servers. See "Starting and Stopping the Collage Server" in the Merant Collage Installation and Setup Guide. You can now log into and use the rebuilt projects.

IMPORTANT!  When you first log into a project that was created in a previous version of Collage or PVCS Content Manager, you will be prompted to upgrade the project to the current version. This is a required additional step which enables the current version of Collage to work with the projects.

Migration ID

KB70190

Applies To

Collage All

Rate this Solution

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs