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 HCL Compass 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"

See also

unlockuserdb, convertschemarepo