You can use the SQL Data Insights (SQL DI) web UI to modify and manage the application server settings.
Procedure
- 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.
- On the upper right corner of the SQL DI framework, click the
(gear) icon to open the Settings page.
- On the Settings page, view and if needed, adjust the settings to the following properties:
- For
Spark, specify the number of cores and the amount of memory for your Spark driver and executor. SQL DI uses Spark jobs to transform the data in the tables or views in your AI object. Increase the number of cores and the amount of memory to improve performance if the size of the data is large.
- For
CPU threads, specify the number of CPU threads for data preprocessing and model training. Increase the number of CPU threads to reduce the model training time.
-
For Db2 load utility, use the default LOAD utility control statement or customize it for loading trained models. SQL DI uses the ZLOAD command to upload the model training results to your Db2 system. Verify that the Db2 user ID has the permissions to run the ZLOAD command and to access the data sets referenced in the load utility control statement. See Configuring Db2 for SQL DI for details.
Customize the LOAD control statement based on your Db2 settings. For a very large data, increase the space allocation and specify a data class with the extended addressability attribute, allowing the data sets to grow in size beyond 4 GB.
- For
AI query, specify the maximum number of rows to load for a query result set. By default, SQL DI loads up to 1000 rows of a query result set. You can change the default value if needed.