Managing a Relational Database Server

About this task

By adding a relational database server, you correctly configure the connection between IBM® AD Build and IBM AD Analyze. This task is step 5 of configuring an IBM AD installation through IBM AD Configuration Wizard. You can add, update or delete a relational database server as follows.

Procedure

  1. Access Start Menu > IBM Application Discovery and Delivery Intelligence > Launch IBM Application Discovery Configuration Service Admin, and go to Configure > Environments > "Your environment" > Servers and security > Relational database server. The Relational Database Server settings page is displayed.
  2. To add a relational database server, click the Add button. The Add Relational Database Server page is displayed.
  3. Enter the following information:
    Server Name (alias)
    Enter an appropriate name (alias) for the relational database server.
    Note: For a Db2® for LUW (Linux®, UNIX, and Windows) database server, the server name must follow the general Db2 object naming rules. This alias will be used to catalog Db2 for LUW server node into local node directory in case that you decide automatically create the databases within IBM ADDI (Project database, Cross Service database, Annotation database).
    Select Database Server Type
    Select the appropriate relational database type.
    Host
    Enter the host name or the IP of the computer where the relational database server is installed. IBM AD Build Configuration uses the server to publish projects.
    Port
    Enter the relational database server port. The default ports are:
    For Microsoft SQL Server
    The default port for Microsoft SQL Server is 1433.
    For Db2 for z/OS®
    The default port for Db2 for z/OS is 50000.
    For Db2 for LUW (Linux, UNIX, and Windows)
    The default port for Db2 for LUW when TLS is disabled is 50000.
    Use TLS
    Attention:
    • The Use TLS check box is used to enable Transport Layer Security (TLS) communication with Db2 for LUW and it is available only when IBM Db2 is selected as the database server type. To be able to select the Use TLS check box make sure that Hypertext transfer protocol secure (HTTPS) is set as a default connection protocol in IBM AD Configuration Server. For more information, see Configuring Security Settings.
    • For the complete steps on how to configure DB2 for LUW with TLS, see Securing IBM Db2 for LUW database connections.
    Database Name (optional)
    If IBM Db2 is selected as the database server type, the Database Name (optional) field is displayed. You can enter the name of any database on the selected server to validate the connection. This field is optional.
    Storage group (optional)
    If IBM Db2 for z/OS is selected as the database server type, the Storage Group (optional) field is displayed. Specify the storage group that is configured for IBM AD on the Db2 for z/OS server. This field is optional.
    Instance (optional)
    If Microsoft SQL Server is selected as the database server type and multiple instances are installed on the same machine, enter the required relational database server instance name (if exists).
    Username and Password
    1. For Microsoft SQL Server instance, enter the username and password for the IBM AD SQL Identity as previously defined in Microsoft SQL Server Configurations.
    2. For IBM Db2 for z/OS instance, enter the username and password as previously defined in IBM Db2 for z/OS Server Configurations.
    3. For Db2 for LUW (Linux, UNIX, and Windows) instance, enter the username and password.
    Note: If you need to update the name of the AD SQL Identity user, complete the following steps:
    1. Create a new SQL Identity user in SQL Server, and grant the same permissions to the new user as the existing SQL Identity user. For the detailed steps, follow the description in Microsoft SQL Server Configurations.
    2. Change the name of the SQL Identity user and password if appropriate in the Relational database server definition in AD's Configuration Server as described at this step.
  4. By clicking Test Connection, you can test the connection to your database. If the test connection succeeds, click Save.
  5. To edit a relational database server, go to the Actions column and select the Edit button.
  6. To delete a relational database server, go to the Actions column and select the Delete button.