Adding or removing an AI object with SQL DI web UI

SQL Data Insights (SQL DI) executes AI functions on a Db2 user table or view through a corresponding AI object that is enabled for AI query. AI objects are associated with a specific connection. You can add and manage AI objects for a connection on the AI objects page of the SQL DI web UI.

Before you begin

Make sure that you have the authorization that is required for a specific task in SQL DI. See Managing SQL DI user permissions and Configuring setup user ID for SQL DI for details.

Procedure

  1. Sign in your SQL DI web UI with a valid RACF® user ID at the following address:


    https://<SQLDI-IPAddress>:<SQLDI-PortNumber>

    SQL DI uses a login group to identify and authorize users. The default group name is SQLDIGRP. Make sure that the user ID that you specify is defined in your SQL DI login group.

  2. On the Connections page, select a connection and click the Action selection menu action menu.
  3. Select List AI objects to open the AI objects page for the connection.
  4. On the AI objects page, click Add object.
  5. On the Add object page, choose one or more schemas to display all associated Db2 tables and views.
  6. Select one or more Db2 tables or views.
  7. Click Add object to create one or more AI objects.

    If you select one Db2 table or view and click the Add object button, SQL DI will create a single AI object. If you select multiple Db2 tables or views, SQL DI will create multiple AI objects with each object corresponding to a specific Db2 table or view.

    If you select only one Db2 table or view to create a corresponding AI object and want to enable the object for AI query, click Enable AI query to accomplish both in a single step. See Enabling or disabling AI query with SQL DI web UI for instructions on column configurations.

  8. Back on the AI objects page, verify that the newly added objects show up and their statuses are Created.

    Whenever needed, you can delete an object from the AI objects page by selecting Remove from the action menu for the object.