Creating the Data Gate on Cloud stored procedures

To create the Data Gate on Cloud stored procedures, you customize and run the AQTTIJSP job.

Before you begin

Important: If you have installed IBM Cloud® for use with the same Db2® for z/OS® system, you already have the required stored procedures because both products use the same stored procedures. In this case, you can skip this step.
Customize the AQTTIJSP job member (JCL) for the installation of Data Gate on Cloud stored procedures before you run the job:
  • Make sure that you have already created the Data Gate on Cloud database and tables by running the DSNTIJAS job.
  • Make sure that the Workload Manager (WLM) application environment has been started. You can check this by running the following command from the TSO or ISPF command line:
    DISPLAY WLM,APPLENV=<env_name>

    where <env_name> is the name of the WLM application environment that you configured for the Data Gate on Cloud stored procedures.

    To enter this command from the ISPF primary menu, follow these steps:
    1. Enter SD for System Display and Search Facility.
    2. At the COMMAND INPUT prompt, enter /.
    3. On the System Command Extension panel, type the DISPLAY WLM,APPLENV=<env_name> command next to one of the ===> prompts.
    4. Press Enter.

About this task

AQTTIJSP includes verification steps. These allow you to check whether your stored procedures are at the correct maintenance level. See the following table to identify the correct maintenance level:
Version of Data Gate on Cloud Maintenance level of stored procedures
1.0.0 7.5.8 or higher

Procedure

  1. Customize the AQTTIJSP job according to your needs:
    1. Replace the Db2 subsystem name and the other placeholders with the actual names as described in the customization notes within the AQTTIJSP job member.
      Important: The hyphen (-) is not a placeholder. Therefore, do not replace it with the name of a WLM environment in clauses like 'WLMENV(-)'. Replacing a hyphen in this way leads to SQL error -628 during the execution of the AQTTRIN job step. The actual placeholders are strings that start and end with an exclamation mark (!).
    2. Review and optionally update the GRANT statements to conform to the authorization policy at your site.
    3. Recommendation: Copy the AQTTIJSP job to complete the following steps on the copy.
    4. Modify AQTTIJSP according to the instructions in the job:
      • If you want install new versions of the database objects, keep the value INSTALL for the MODE parameter in job step AQTTRIN.
      • If you just want to see the SQL statements that would be executed, but do not want to run these statements, change the value of the MODE parameter to INSTALL-PREVIEW or REINSTALL-PREVIEW. The JCL is then copied to the data set that is specified in the JCLOUT DD statement, but not executed.
      • If IBM® support requests a trace file of the installation program, uncomment the following lines or blocks of code in the JCL:
        AQTTRACE
        Uncomment this step to allocate a trace data set.
        AQTTRACE DD
        Uncomment this statement in the AQTTRIN step to activate tracing.
  2. To run the job, use an ID with appropriate access rights. If possible, run the job as a user with SYSADM rights.
  3. Verify that the stored procedures are at the correct level. To this end, submit the following SQL query:
    SELECT DSNAQT.ACCEL_GETVERSION() FROM SYSIBM.SYSDUMMYU;
    The result must be 70 or a higher number.