Installing Data Server Manager

To extend the power of the Hortonworks Data Platform (HDP), install and deploy Data Server Manager, which is the IBM® integrated database management tools platform for IBM Big SQL.

1. Open a browser and access the Ambari server dashboard.
   The following is how the Ambari web URL is constructed.

   http://<server-name>:<server-port>

   For example, if your Ambari host is ambari1.mydomain.com and the port is 8081, the URL to use is http://ambari1.mydomain.com:8081.

   The default user name is admin, and the default password is admin. Use HTTPS if your Ambari server has SSL enabled for the Ambari Web UI.

2. In the Ambari web interface, click Actions > Add Service.
3. In the Add Service Wizard, Choose Services, select the IBM Big SQL DSM service. Click Next.
4. In the Assign Masters page, decide which node of your cluster you want to run the specified Data Server Manager master.
5. Click Next.
6. In the Assign Slaves and Clients page, all of the defaults are automatically accepted and the next page appears automatically. Since the Big SQL - Data Server Manager service does not have any slaves or clients, the Assign Slaves and Clients page is immediately skipped during the installation.
7. In the Customize Services page, accept the recommended configurations for the Data Server Manager service, or customize the configuration by modifying the values. Make sure that you enter the following information in the Advanced dsm-config section:

   dsm_admin_user field

   Type a Knox user name that will become the administrator for Data Server Manager.

8. If you want to change the default UID for the Big SQL - Data Server Manager service account, in the Customize Services page, navigate to the Service Accounts details in the Misc tab. Modify the DSM User service account's UID for Ambari to create the user with the desired UID.
9. Click Next.
10. You can review your selections in the Review page before accepting them. If you want to modify any values, click the Back button. If you are satisfied with your setup, click Deploy.
11. In the Install, Start and Test page, the Data Server Manager service is installed and verified. If you have multiple nodes, you can see the progress on each node. When the installation is complete, either view the errors or warnings by clicking the link, or click Next to see a summary and then the new service is added to the list of services.
12. Click Complete.

    If the IBM Big SQL DSM service fails to install successfully, you must fully remove DSM before you try to install it again. For more information, see Removing IBM Big SQL.

13. Enable Knox.
14. Set up DSM to use the Knox Gateway by running the command:

    /usr/ibmpacks/bin/5.0.2.0/knox_setup.sh -u <ambari login username> -p <ambari login password>

15. You can launch the DSM service by either using the quick link in the Ambari web UI, or by typing the following address in your web browser:

    https://<knox_host>:<knox_port>/<knox_gateway_path>/default/dsm

    Where:

    knox_host

    The host where Knox is installed and running

    knox_port

    The port where Knox is listening (by default this is 8443)

    knox_gateway_path

    The value entered in the gateway.path field in the Knox configuration (by default this is 'gateway')

    For example, the URL might look like the following address:

    https://myhost.company.com:8443/gateway/default/dsm

    When you are prompted by Knox, enter a valid Knox user name and password.