Viewing or modifying SQL DI server settings by using the shell CLI

You can use the SQL Data Insights (SQL DI) shell CLI to modify and manage the application server settings.

1. Create a credentials file for the user ID and password that you will use to access SQL DI.

   See Creating and encrypting a credentials file with SQL DI shell CLI for instructions.

2. Create the input file required for the commands that you will issue to view or modify your SQL DI server settings.
   See Creating and encrypting a credentials file with SQL DI shell CLI for instructions.
3. In a bash session, change to the $SQLDI_INSTALL_DIR/sql-data-insights/bin directory.
4. View the default SQL DI server settings by invoking the sqldi.sh shell script with the list_default_settings command.

   Assume that you created input file sqldi_settings_input. Issue the list_default_settings command with the -f option as shown in the following example:

   ./sqldi.sh list_default_settings -f sqldi_settings_input

5. Modify the default SQL DI server settings by issuing the set_settings command with the -f option.

   ./sqldi.sh set_settings -f sqldi_settings_input

6. Optionally, view the current SQL DI by issuing the following list_settings command with the -f option:

   ./sqldi.sh list_settings -f sqldi_settings_input

   See Shell commands for SQL Data Insights configuration, administration, and object model management for details about the commands.