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
- Shut down the Collage Server. See "Starting and Stopping the Collage
Server" in the Merant Collage Installation and Setup Guide.
- 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
- 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.
- 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.
- Repeat step 4 for each project.
- Repeat steps 4 and 5 for each database server in your installation.
- 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