RepositoryAdmin tool reference

Metadata about the repositories that are used in IBM® InfoSphere® Information Server is stored in the metadata repository. The RepositoryAdmin tool is provided for you to define and manage this metadata for some of the repositories.

Purpose

You can use the installation program to create the repositories used by InfoSphere Information Server. You can also choose to create some of the repositories as a post-installation step, for example if you are not using the Db2® database system. If you do not use the installation program to create a particular repository, you can use the RepositoryAdmin tool to create the SQL scripts necessary to create and configure the repository. You also use the tool to register the repository (and its hosting database, database platform, and database server) with the metadata repository.

Even after installation, there might be times when you need to manage the repository registration, such as when you relocate a repository to another server or if you need to change the connection properties.

You cannot manage the following repositories with the RepositoryAdmin tool:

  • Metadata repository
  • IBM InfoSphere Metadata Asset Manager staging area
  • IBM InfoSphere Information Analyzer analysis databases

Syntax

RepositoryAdmin{.bat|.sh}
  [-{connectionManagedDSN | cm} <value>]
  [-{connectionName | cn} <value>]
  [-{connectionPassword | cw} <value>]
  [-{connectionProperties | cp} <value>]
  [-{connectionURL | cr} <value>]
  [-{connectionUser | cu} <value>]
  [-{databaseType | dt} <value>]
  [-{databaseVersion | dv} <value>]
  [-{dbName | dn} <value>]
  [-{displayDatabase | dd} [<value>]]
  [-{displayDatabasePlatform | dp} [<value>]]
  [-{displayDatabaseServer | ds} [<value>]]
  [-{displayRepository | dr} [<value>]]
  [-{displayRepositoryConnection | dc} [<value>]]
  [-{help | ?}]
  [-{listDatabasePlatforms | lp} [<value>]]
  [-{listDatabaseServers | ls} [<value>]]
  [-{listDatabases | ld} [<value>]]
  [-{listRepositories | lr} [<value>]]
  [-{listSQLScripts | lt} [<value>]]
  [-{log | l} <value>]
  [-{logerror | error} <value>]
  [-{loginfo | info} <value>]
  [-{loglevel | level} <value>]
  [-{propertyFile | pf} <value>]
  [-{registerDatabase | rd} [<value>]]
  [-{registerDatabaseServer | rs} [<value>]]
  [-{registerRepository | rr} [<value>]]
  [-{reposContext | ct} <value>]
  [-{reposDescription | de} <value>]
  [-{reposName | rn} <value>]
  [-{reposSchema | sc} <value>]
  [-{reposTool | to} <value>]
  [-{results | res} <value>]
  [-{saveSQLScripts | sss} [<value>]]
  [-{scriptLocation | sl} <value>]
  [-{scriptName | sn} <value>]
  [-{scriptTool | sto} <value>]
  [-{scriptType | st} <value>]
  [-{serverBinPath | sb} <value>]
  [-{serverHost | sh} <value>]
  [-{serverPassword | sw} <value>]
  [-{serverPort | sp} <value>]
  [-{serverUser | su} <value>]
  [-{testRepositoryConnection | tc} [<value>]]
  [-{unregisterDatabase | urd} [<value>]]
  [-{unregisterDatabaseServer | urs} [<value>]]
  [-{unregisterRepository | urr} [<value>]]
  [-{updateDatabaseServer | us} [<value>]]
  [-{updateRepository | ur} [<value>]]
  [-{updateRepositoryConnection | uc} [<value>]]
  [-{verbose | v}]

Usage

Some of the commonly-used parameters are listed in the topics that follow. The RepositoryAdmin tool must be run from the services tier. In each of the following topics, the RepositoryAdmin tool is displayed with just the name of the command with the Microsoft Windows .bat extension. However, when you run the command, provide the correct extension for the operating system and the full path to the command (or include the directory that contains the command in your PATH environment variable). The full path and extension of the command is as follows:

Windows cue graphic
is_install_dir\ASBServer\bin\RepositoryAdmin.bat
Linux cue graphicUNIX cue graphic
is_install_dir/ASBServer/bin/RepositoryAdmin.sh