Installing the IBM Z Database Assistant user interface

Use the instructions in this topic to install the IBM® Z Database Assistant user interface.

Before you begin

Download the user interface code from IBM Marketing Registration Services (MRS) as described in Obtaining the IBM Z Database Assistant code.
Ensure that your system has the following software:
- IBM watsonx Assistant™ for Z (Infrastructure required to support IBM Z Database Assistant agentic capabilities)
- Db2 for z/OS support PTFs (Host-side changes required for IBM Z Database Assistant integration)
- IBM Z Database Assistant license (must be available prior to configuring)
- Java Runtime version 21.0.9.1

About this task

This task describes how to install the capabilities that are provided in the IBM Z Database Assistant user interface only. The IBM Z Database Assistant AI chat interface requires additional installation.

This task is typically done by a system administrator.

Installation materials for the user interface are provided in the ibm-z-database-assistant-v1.1.0-os390-s390x-202606110000.pax.Z file that you downloaded from MRS.

Procedure

Allocate a 20 GB ZFS data set and mount it to the path that you choose as the installation directory of IBM Z Database Assistant, for example:
```
/usr/lpp/IBM/zdbav1r1
```
Upload the ibm-z-database-assistant-v1.1.0-os390-s390x-202606110000.pax.Z file into the mounted directory using FTP in binary mode.

Note: If you downloaded the file using Windows, the default Windows ftp utility might not be able to upload the file correctly. If you encounter a message such as Not a plain file, switch to a different ftp client.
Change to the <installation_directory>.
```
cd <installation_directory>
```

Extract the pax file by issuing the following command:

pax -ppx -r -f ibm-z-database-assistant-v1.1.0-os390-s390x-202606110000.pax.Z

From the installation directory, issue the following shell commands:

```
pax -ppx -r -f IBM/AURBASH
```

export BASH_HOME=<install_directory>/bash

```
export PATH=$BASH_HOME/bin:$PATH
```

Run the installation script (requires z/OS UNIX superuser authority):
```
./IBM/AURINST
```
The following directories and a readme file are created:
```
apps
bash
catalogs
configuration
dbrm
IBM
library
licenses
nodejs
readme.txt
samplejcl
servers
spark
ui
wlp
```
The samplejcl directory contains sample JCL jobs to create the metadata catalog and the target Db2® catalog tables and other sample JCL jobs. Allocate a PDS to copy the sample jobs into. Use following TSO command to copy the sample jobs from the directory into the PDS:
```
ogetx '/<installation_directory>/samplejcl' 'hlq.SAURSAMP' LC SUFFIX(samp)
```
The dbrm directory contains the DBRMs that IBM Z Database Assistant uses for SQL tuning functions. Allocate a RECFM=FB, LRECL=80 PDS data set to copy the DBRM members into. Use the following TSO command to copy the DBRM members into the PDS:
```
ogetx '/yourinstallpath/dbrm' 'hlq.SAURDBRM' binary
```