Updating database objects

You use the Objects page of the Edit Shared Repository Storage dialog to update the database objects that are required for the repository storage.

1. Open the Objects page of the Edit Repository Storage window.
2. 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.

3. Click Update to check if the repository storage objects have been created or have to be updated. Depending on the status of the objects you will proceed as follows:
   • If all the objects have not changed, a message is issued. Click OK in the message window.
   • If the objects have to be updated, then the Update repository storage tables page opens listing the SQL statements that will be used to update the required repository storage tables. You can make changes to the SQL statements as described on the page.
4. If you have completed making changes to the repository storage properties, click OK. If you will be making additional changes, click the Connection or Protection tab, depending on the changes that you are making.