installutil unlockschemarepo
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 Rational®
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"