Creating a shared repository storage

A shared repository storage is a set of database tables. You must create a shared repository storage for storing database connection and resource limit information, as well as the database objects that users will use for reporting and querying actions.

Before you begin

Before you create a repository storage, make sure you have installed and configured your database management system (DBMS). Also, make sure to install the JDBC driver JAR files and license files so that QMF can connect to the database.

About this task

To create a repository storage, complete the following steps:

Procedure

  1. In the Repositories view, click Create a shared repository storage. The Create New Shared Repository Storage wizard opens.
  2. On the Enter connection parameters for new shared repository storage page, specify the JDBC connection information and user login information to use to connect to the database that will host the repository storage.
  3. Click Next. The Create or upgrade repository storage tables page of the wizard opens.
  4. On the Create or upgrade repository storage tables page, specify that the database objects that are required by the QMF applications in order to access the repository storage will be created or upgraded.
  5. Click Next. If necessary, the Update repository storage tables page opens listing the SQL statements that will be used to create or update the required repository storage tables. If this page opens, click Next. The Protect repository storage tables page of the wizard opens.
  6. On the Protect repository storage tables page of the wizard specify whether the database repository storage tables will be protected from unauthorized users.
  7. Click Finish.