RADE

Source Code Manager

adl_mk_db

Creating a database
Quick Reference

Abstract

The adl_mk_db declares a new SCM database. This commands is to be used when installing SCM the first time and when adding a new SCM department database.

Synopsis

adl_mk_db database_name [-desc description] [-central | -no_central] [-dept | -no_dept] [-monitor | -no_monitor] [-h | -help | -?]

Usage

The name of a database is the one used for creating it and that is used afterwards when connecting to it. For example, the name that must be registered for the SCM central database is the same as the value of the environment variable ADL_CENTRAL_DB_ID. Refer to the "Getting Started" documentation to have more information about database names.

A SCM database can be either a central database, a monitor database or a department database but

The smallest SCM installation is composed of a single database for storing the three kinds of information: central, monitor, departmental.

When development projects grow (data managed, number of users involved, ...), it can be interesting to dispatch information among several databases that are then declared as SCM department databases.

Note that the purpose of the adl_mk_db command is to declare a new database, not to create it physically. The database must exist and the adl_mk_db will check that a connection can be made with it. Please, refer to the appropriate documentation of the underlying database management system (Oracle, DB2, etc) to know how to create a new database.

[Top]

Options

adl_mk_db accepts the following options:  

-h|-help|-? Help of the command
database_name Name of the new database to register.
-desc description Text to describe the purpose of this database
-central To specify that the database is the SCM central database
-no_central To specify that the database is not the central database
-dept To specify that the database is a SCM department database
-no_dept To specify that the database is not a SCM department database
-monitor To specify that the database is the SCM monitor database
-no_monitor To specify that the database is not the SCM monitor database

[Top]

Examples

Creation of the database named "SCMDB1.Dassault-Systemes.fr" as central, monitor and department database: 

adl_mk_db SCMDB1.Dassault-Systemes.fr -central -monitor -dept
Creating the database "SCMDB1.Dassault-Systemes.fr".
Command successful.

 

Adding a new database named "SCMDB2" as a new SCM department database:

adl_mk_db SCMDB2 -dept
Creating the database "SCMDB2".
Command successful.

 

Trying to declare the database named "SCMDB3" as a new SCM department database but "SCMDB3" is already used as a central database for another SCM installation (another SCM site), this is forbidden:

adl_mk_db SCMDB3 -dept
Verifying the departmental database SCMDB3.
#ERR# ADLCMD - 0098: The database SCMDB3 is supposed to be only a department database and SCMDB1 is supposed to be the central database, but SCMDB3
contains the version table of a central database.
Please run the profile again or call an administrator.

##### THE COMMAND ENTIRELY OR PARTIALLY FAILED #####

[Top]

References

[1]
[2]
[3]		 adl_ls_db: listing databases of current site
adl_set_db: changing characteristics of a database
adl_ren_db: changing the name of a database

[Top]

History

Version: 1 [Jan 2003] Document created

[Top]

Copyright © 2003, Dassault Systèmes. All rights reserved.