When you no longer want to run SQL DI queries on a table or view, you can drop the
associated model table and remove the SQL DI object from the Db2® table
SYSAIDB.SYSAIOBJECTS.
Procedure
To remove SQL DI artifacts for a table or view:
On the DB2 Administration Menu (ADB2) panel, specify
option Z, and press Enter.
On the System Administration (ADB2Z) panel, specify option
DI, and press Enter.
On the SQL Data Insights Menu (ADB2ZDI) panel, specify
O, and press Enter.
On the SQL DI - Objects (ADB2ZDIO) panel, specify
the DEL line command next to the SQL DI object that corresponds to the table or
view for which you want to remove the SQL DI artifacts.
The DEL line command performs the functions of both the R (Remove object) line
command and the D (Drop model tables) line commands.
On the SQL DI - Delete artifacts (ADB2ZDOA) panel, confirm the
artifacts that you want to delete, and press Enter.
Figure 1. SQL DI - Delete artifacts (ADB2ZDOA) panel
ADB2ZDOA DD1A SQL DI - Delete SQL DI artifacts 16:38
Delete SQL Data Insights SQL DI artifacts using the following opti
Object ID . . . . . . 81
Object schema . . . . DSNAIDB
Object name . . . . . CHURN
Model ID . . . . . . 81
Press ENTER to delete SQL DI artifacts or END to cancel.