Configuring Db2 for SQL DI

To enable SQL Data Insights (SQL DI), you must customize and submit the DSNTIJAI job to create the required database and tables in Db2 for z/OS® for SQL DI.

Before you begin

You must configure the DSNUTILU stored procedure in Db2. See DSNUTILU stored procedure for instructions.

Note: DSNTIJAI uses program DSNTIAD, the package of which must be bound with APPLCOMPAT V12R1M500 or higher in order to run.

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. Copy and customize the DSNTIJAI sample job member in the Db2 SDSNSAMP library according to your needs.

    When you create STOGROUP DSNAIDSG in the DSNTIJAI sample job, use a catalog alias for the VCAT option. Make sure that the alias is assigned to SMS-managed data sets that have allocation for extended format and extended addressability. The allocation will accommodate models that are larger than 4 GB in size.

  2. Submit DSNTIJAI.
    Note: The last step, DSNTIAI4, of the DSNTIJAI job grants the necessary database permissions to SQL DI users. You must repeat step DSNTIAI4 for each user.
  3. Review the load template and add permissions.

    This step involves loading a Db2 table. SQL DI provides a template with the utility control statements for the zLoad process.

    Follow the instructions described in step 3 of Viewing or modifying your SQL DI server settings by using the web UI to review the load template file. Ensure that SQL DI users have access to the data sets referred to in the template, and that adequate temporary space has been allocated, based on the size of your source table.

    Note: The default high-level qualifier (HLQ) specified in the TEMPLATE statements in the load template is the z/OS job name indicated by the "&JO" variable. Review whether it is appropriate for SQL DI users to run the zLOAD utility in your environment.