Unlocks a schema repository.
Applicability
Platform: Windows
Command type: installutil subcommand
Synopsis
- installutil unlockschemarepo
- [–dbset dbset_name] db_vendor server database dbo_login dbo_password "connect_options"
Description
The installutil
unlockschemarepo subcommand unlocks a schema repository.
Production
databases are locked before they are copied when you use the installutil
convertschemarepo subcommand to copy a schema repository
and create a sample database for testing the upgrade process. Use
the installutil unlockschemarepo subcommand
to unlock the schema repository and allow users to continue using
it while you test the copy.
Attention: Do
not unlock the original databases after you complete the upgrade.
Keeping the original databases locked prevents users from accessing
the wrong databases.
Options and arguments
- -dbset dbset_name
- Name of the database set or database connection.
- db_vendor
- Database vendor name. Valid values:
- MS_ACCESS
- SQL_ANYWHERE
- SQL_SERVER
- ORACLE
- DB2®
Attention: Vendor names must be capitalized as
shown.
- server
- Host name of the database server. Following is vendor-specific
information:
- MS_Access: Not used
- DB2: System host name
- Oracle: System host name
- SQL Anywhere: Service name
- SQL Server: System host name
- database
- User database name. Following is vendor-specific information:
- MS_Access: Fully qualified path name. For example, \\full\path\file.mdb
- DB2: User database name
- Oracle: Oracle system ID (SID)
- SQL Anywhere: Fully qualified path name. For example, \\full\path\file.db
- SQL Server: User database name
- dbo_login
- Login ID of the database owner.
- dbo_password
- Password associated with dbo_login.
- connect_options
- Optional parameters, which vary by database vendor. See Vendor database properties.
Examples
- Unlock a schema repository named MySR that
uses an Oracle database server with the CLOB data type. In this example,
The Oracle SID is ORC and the database owner
and associated password are srowner and sroPaSSWorD,
respectively. The -dbset option is not specified because an
existing schema repository in the database set has the default name.
installutil unlockschemarepo ORACLE MySR ORC srowner sroPaSSWorD "LOB_TYPE=CLOB"
- Unlock a schema repository after the installutil
convertschemarepo subcommand completes, where the name
of the SQL Server database that holds the new copy of the schema repository
is MyNewSchemaRepo. The MyNewSchemaRepo schema
repository is owned by the SQL Server user ID dbowner whose
password is dboPaSSWorD. The target SQL Server
host name is MySQLServer. The default ClearQuest® Super User user
id and password are admin and admPaSSWorD,
respectively. The -dbset option is not specified because an
existing schema repository in the database set has the default name.
installutil unlockschemarepo admin admPaSSWorD MYDB SQL_SERVER MySQLServer MyNewSchemaRepo dbowner dboPaSSWorD "PORT=3000"