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 begin this task, make sure you have:
  • Installed and configured your database management system (DBMS).
  • Installed the JDBC driver JAR files and license files so that QMF can connect to the database.

Open the Administrator perspective if you have not already done so. To open the Administrative perspective go to the menu pane and select Window > Open perspective > Other > Administrator.

Make sure the Repository view is open in the workbench. To open the Repository view select Window > Show view > Repositories. The Repositories tab opens in the workbench.

About this task

Creating the repository storage tables is a multistep process with multiple options presented in each step. The options you select in one step will determine the next step in the process.

The steps in this topic provide an overview of the process for creating the shared repository storage on your database, so that the data in the repositories can be obtained for further relocation or distribution in a network. See the subsequent topics in this section for detailed descriptions of the wizards employed.

The maximal line length of the DDL scripts displayed when creating shared repository storage is determined by the value set in the Line width field on the General Preferences page. See Setting general preferences for more information.See Setting general preferences in the User help for more information.

To create the repository storage on your database:

Procedure

  1. Right-click in the Repositories view. Select New > Shared Repository Storage. The Enter connection parameters for new shared repository storage page of 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 that will be used 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 Upgrade 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. The Db2 Table Space Options lets you choose between Universal (UTS) table spaces and Segmented (non-UTS) table spaces if your database is Db2 12 for z/OS FL 503 or less.
    Note: These options are displayed only when you connect to a Db2 for z/OS database with FL 503 or less.
  8. Click Finish.

Results

You have created the shared repository storage on your database.

What to do next

The next step is to add repositories to the repository storage tables.