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:
- Enter SD for System Display and Search
Facility.
- At the COMMAND INPUT prompt, enter /.
- On the System Command Extension panel, type the DISPLAY
WLM,APPLENV=<env_name> command next to one of the ===>
prompts.
- 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
- Customize the AQTTIJSP job according to your needs:
- 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 (!).
- Review and optionally update the
GRANT
statements to conform to the
authorization policy at your site.
- Recommendation: Copy the AQTTIJSP job to complete the following steps on the
copy.
- 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.