Installing and configuring the ad-hoc utility API for Db2 Automation Expert

Edit online

Once Db2® Automation Expert has been installed via SMP/E, several customization tasks must be completed to use the ad-hoc utility API.

Before you begin

If you plan to use the Db2 Automation Expert ad-hoc utility API, ensure that the prerequisites listed in Requirements for the Db2 Automation Expert ad-hoc utility API are met.

Procedure

Start Tools Customer for configuring Db2 Automation Expert.
On the Specify the Product or Pack Metadata Library panel, select or specify your metadata library.
On the Customizer Workplace panel, enter E next to the Product parameters field.
Select the API support task.
Generate the Tools Customizer jobs.
Two relevant jobs are produced: ssPRUTG and ssPRUTX.
Submit the ssPRUTG and ssPRUTX jobs.
Running the two jobs produces two JCL PROCS, DAJPRUTG and DAJPRUGX. The procs are used by the APIs for utility generation and running the utility, respectively.
Move the DAJPRUTG and DAJPRUGX procs to your relevant system PROCLIB library and define them as started tasks.

Note: The started tasks will be started as needed by the APIs. They must not be automatically started by your system or running continuously.
Configure UMS for Db2 Automation Expert. For discovery by UMS for API calls, update the ZWEYAML member of the UMS PARMLIB data set.
In the toolsDiscovery: section, configure the following settings:
```
toolsDiscovery:
   enabled: true
   discoverySearchPaths:
   - "DSN:daj_hlq.SDAJSAMP(DAJYPROD)"
```
Add the following to the STEPLIB DD in the Zowe ZIS AUX started task (ZWESASTC):
```
hlq.SDAJLOAD,DISP=SHR
fec-hlq.SFECLOAD,DISP=SHR
```
where hlq.SDAJLOAD is the installed Db2 Automation Expert load libary and fec-hlq.SFECLOAD is the installed FEC common code library.
Add the following to the Zowe ZIS AUX started task (ZWESASTC):
```
//DB2PARMS DD hlq.CONTROL,DISP=SHR
//DAJ#DATA DD   *       
DAJ_CONFIG_ID DAJ   
```
where hlq.control is the Db2 Automation Expert control file.
Restart the Zowe cross-memory server.
For more information, refer to Starting and stopping the cross memory server ZWESISTC on z/OS.
Restart Zowe.
For more information, refer to Starting and stopping Zowe.
Start Db2 Automation Expert, enter option 11.2, and ensure that a maintenance window named IZP AD HOC with the description AD HOC UTILITY EXECUTIONS has been created on the subsystem that you will be using the API.
This maintenance window is required for ad-hoc utilities via the API.