Creating the Db2ZAI metadata catalog and granting privileges to the Db2ZAI metadata scheduler ID

Before using Db2® AI for z/OS®, you need to create the Db2 for z/OS metadata catalog, which contains information about the target Db2 subsystems.

Before you begin

The user creating the metadata catalog must have system DBADM privilege (or higher), or the specific privileges granted in the COYGMADM job.

About this task

After you create the metadata catalog, grant privileges to the metadata scheduler ID and end users that require access to the Db2ZAI user interface.
Note: The user granting these privileges must have at least the privileges of a Db2ZAI metadata administrator.

To watch the configuration of network ports for a sample Db2ZAI setup, see Creating the Db2ZAI metadata catalog example.

Procedure

To create the Db2ZAI metadata catalog:

  1. Customize member COYIVMC. This member will be used in subsequent tasks for variable substitution.
  2. Customize and run the job hlq.SCOYSAMP(COYIMC01), which will create the metadata catalog.

To grant the Db2ZAI metadata scheduler ID privilege:

Follow this process to give a Db2ZAI user ID the privilege to run specific background processes. This ID can be the same as the Db2ZAI metadata administrator ID.

  1. Customize and run the job hlq.SCOYSAMP(COYGMSID) to assign Db2ZAI metadata Db2 table privileges to Db2ZAI metadata users.
    Note: You will be prompted to enter the Db2ZAI metadata scheduler ID for the Configuring IBM Db2 AI for z/OS task.
    Note: The metadata scheduler ID must be unique. The ID used for the metadata scheduler ID should not be used for the target scheduler ID for any target connections.
    Note: The metadata scheduler ID cannot be an MFA-enabled ID.