Creating the Db2 Data Gate stored procedures

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

Before you begin

Important: If you have installed IBM® Db2 Analytics Accelerator 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 Db2 Data Gate stored procedures before you run the job:

Make sure that you have already created the Db2 Data Gate 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 Db2 Data Gate 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 Db2 Data Gate	Maintenance level of stored procedures
2.5.0	7.5.8 or higher

Procedure

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.
To run the job, use an ID with appropriate access rights. If possible, run the job as a user with SYSADM rights.
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.