Specifying connection parameters and user login information

The first step to creating shared repository storage is to specify the connection parameters and the user login information that will be used when accessing the database that hosts the repository storage.

1. Open the Create New Shared Repository Storage wizard and navigate to the Enter connection parameters for new shared repository storage page.
2. In the JDBC Driver field specify the library for the JDBC driver that will be used to access the database that is hosting the repository storage. You can select from a drop down list of libraries that you defined when you set up the JDBC driver information. You can use the ellipsis (...) to the right of the field to open the Select JDBC Driver dialog where you can create additional JDBC driver libraries.
   Note: If you work with a Db2® for z/OS® database, you can use the Direct DRDA Connection. In contrast to JDBC libraries, the Direct DRDA Connection comes with QMF and does not require additional driver installation.

   You can enable the use of SSL certificates for the Direct DRDA Connection to make the connection secure.

   Note: The Direct DRDA Connection is supported only for DB2® for z/OS version 9 and later. Do not use it for Db2 LUW or DB2 for iSeries.
3. In the JDBC URL list, specify the URL that points to the database that hosts the repository storage within which the repository to which you want to connect resides.

   The format for the URL can be displayed in the list.

   Note: You can also use the Build URL by URL-template dialog box to form the correct string.

   Click Build URL to open the Build URL by URL Template dialog box. From the JDBC URL drop-down list, select the template. In the table, specify the server, port, and database information and click OK. The result URL string is added to the JDBC URL list.

4. Click Advanced to specify any driver-specific connection string keywords and their values that will be used for the database that is hosting the repository storage tables. The list of available advanced properties will change depending on both the type of driver being used, and the version of the driver. For information on any keywords that are required by a selected database driver, consult the specific driver's documentation.
   Note: For the DB2 Type 4 UDB driver and the DB2 Universal JDBC Driver, to receive extended SQL exception error messages, check the retrieveMessagesFromServerOnGetMessage option in the Advanced JDBC Settings window.
5. To configure a PassTickets-based Single Sign-on connection between QMF and Db2 for z/OS database, click Single Sign-on.
6. If you use the Direct DRDA Connection, bind packages by clicking the Bind Packages button.
7. Select User ID and password are required to require the use of a user ID and password when accessing the database that is hosting the repository storage. If the database that is hosting the repository storage allows access without a user ID and password, selecting this option will override that allowance, and a user ID and password will be required to access the repository storage tables.
8. Specify the user ID and password that will be used to access the database in the User ID and Password fields. The user ID and password that you specify when connecting to the host repository are used to authorize the user in that repository. The user ID and password that you specify must have administrative privileges on the host database in order to create the repository storage tables. This mode is only available on Db2.
9. To remember this password every time you use the specified user ID to connect to the database, select the Remember password check box.
10. Click Test Connection to test the connection to the database. If you have specified any information incorrectly you will not be able to connect.
11. Click Next. The Create or upgrade the repository storage tables page of the wizard opens.