How to change repository location in the InConcert Server.

How to change repository location in the InConcert Server.

book

Article ID: KB0085048

calendar_today

Updated On:

Products Versions
TIBCO InConcert -
Not Applicable -

Description

Resolution:
Description: If the repository location changes, the database needs to
be updated to reflect that location if the TIBCO InConcert version is 6.2.1 or less.  From TIBCO InConcert 7.1
the batch registry commands UPDATE REPOSITORY
LOCATION and UPDATE REPOSITORY PARTITION should be used instead of the direct SQL statements below.

For example, if the
database contents are moved from one location to another
using the database import utility, the repository location
would need to be updated if that location were to change.

Moving a repository

The InConcert API does not provide a function to change the
location of a repository.  If you must relocate any InConcert
repository, you must also update its location in the database
using the appropriate SQL interface for your dbms.  For
example, use the following SQL commands to change and
verify the location of a repository:

SELECT * FROM REPOSITORIES

UPDATE REPOSITORIES SET LOCATION='&ltnewhost>' WHERE
PARTITION='&ltoldpartition>'

UPDATE REPOSITORIES SET PARTITION='&ltnewpartition>'
WHERE PARTITION='&ltoldpartition>'

SELECT * FROM REPOSITORIES

_____

In addition, all the UNIX files must be copied from the old
repository to the new repository location.

Issue/Introduction

How to change repository location in the InConcert Server.

Environment

Product: TIBCO InConcert Version: All OS: All --------------------