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 the default URL.

   http://<server-name>:8080

   The default user name is admin, and the default password is admin.
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 expanding the configuration files and 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.

   If you want to change the default UID for this Big SQL - Data Server Manager service account, select the Misc tab in the Customize Services page. You can manage the UID for this service account so that Ambari will create the user with the appropriate UID.

8. Click Next.
9. 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.
10. 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.
11. Click Complete.
    If the IBM Big SQL DSM service fails to install, run the fullBigSQLCleanup.py script, located in the /var/lib/ambari-server/resources/extensions/IBM-Big_SQL/<version>/services/BIGSQL/packages/scripts directory. The following code is an example of the command:

    
    cd /var/lib/ambari-server/resources/extensions/IBM-Big_SQL/<version>/services/BIGSQL/packages/scripts
    ./fullBigSQLCleanup.sh -u <ambari_user> -p <ambari_password> -s <ambari_server_host> -x <ambari_port>

    For more information about cleaning the Big SQL environment, see Removing IBM Big SQL.
12. Make sure that the Knox service is enabled.
13. Set up DSM to use the Knox Gateway by running the command:

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

14. You can launch the DSM service by either using the quick link in the Ambari user interface (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.