Creating and updating tables

The second step to creating shared repository storage is to specify whether the database objects that are required by the QMF applications in order to access the repository storage will be created or updated.

1. Open the Create New Shared Repository Storage wizard and navigate to the Create or upgrade repository storage tables page.
2. Select one of the following options:
   • Click Repository storage tables have already been created to bypass this step. You might select this option if all the repository storage tables already exist and you are certain that the tables have not changed. An example of this situation might be if you are editing the repository storage options and your intent is to re-bind packages or re-run stored procedures for the repository storage tables. Click Next. The Protect repository storage tables page of the wizard opens.
   • Click Create or upgrade repository storage tables to check if the tables have been created or have to be updated.
3. Optionally you can type the owner name in the Owner ID field, if you work with Db2® databases. The Owner ID provides the administrator privileges to the user who operates under the login without SYSADM authority.
   Tip: (for Db2 for z/OS® databases)

   When the user without administrator privileges creates or updates the shared repository storage tables and enters the owner name in the Owner ID field, the user login and Owner ID are automatically inserted to the RSBI.AUTHID_TABLE as the PRIMARY_ID and SECONDARY_ID correspondingly. This allows the user to create shared repositories with database-based security provider and automatically work with the repositories as an administrator.

4. If repository storage tables have not been created, you can select the Enable customization of database object names check box to open a window where you can customize how database objects are named.
5. Click Next.
   Depending on the status of the tables you will proceed as follows:

   • If all the tables have been created and have not changed, a message is issued. Click OK in the message window. The Protect repository storage tables page of the wizard opens.
   • If the tables have to be created or updated and you did not select the Enable customization of database object names check box, the Enter Substitution Variable Values window opens. Enter your customized database object names in the Value column and click OK. For non-Db2 for z/OS® databases, this page does not open. Then the Update repository storage tables page of the wizard opens listing the SQL statements that will be used to create or update the required repository storage tables. You can make changes to the SQL statements as described on the page. Click Next. The Protect repository storage tables page opens.
   • If the tables have to be created and you selected the Enable customization of database object names check box, then the Enter Substitution Variable Values window opens. Enter your customized database object names in the Value column and click OK.
     Note: The Value column of the window displays the default name of each database object. This gives you an opportunity to review and/or rename the objects that will be created. For example, one could preface all index names with the prefix "IX".
     The Enter Substitution Variable Values window closes and the Update repository storage table page of the wizard opens.

     Click Next. The Protect repository storage tables page opens.