When SQL Data Insights (SQL DI) is enabled for a table or view, you can run semantic
queries on that table or view to find hidden insights in the Db2® data.
Procedure
To check whether SQL DI is enabled for a table or view:
-
On the DB2 Administration Menu (ADB2) panel, specify
option 1, and press Enter.
-
On the System Catalog (ADB21) panel, specify
option T and optionally any selection criteria, and press
Enter.
-
On the Tables, Views, and Aliases (ADB21T) panel,
specify the DIO line command next to the table or view for which you want to
check whether SQL DI is enabled.
The corresponding SQL DI object is displayed. If no rows are returned, an SQL
DI object does not exist for that table or view. To create one, see Selecting a table or view for SQL DI.
-
On the SQL DI - Objects (ADB2ZDIO) panel, check the
Status column to see whether the object is enabled
for SQL DI queries.