Installing Db2 Administration Foundation

To work with and manage Db2 for z/OS® on your subsystems, you must have Db2 Administration Foundation installed and configured properly.

Before you begin

Review the software requirements for Db2 Administration Foundation. For details, see the Software requirements for Db2 Administration Foundation section.
The latest PTF for IBM Unified Management Server for z/OS must be installed.
You need to retrieve the UMS installation folder path on z/OS UNIX System Services and the config_hlq of your UMS installation data sets.
Note: This is not the installation path. It is the path of IZP_UMS_VARDIR.
The SMP/E install for Db2 Administration Foundation should be in the same SMP/E global zone as UMS.

Procedure

To stop the Unified Management Server started task, run the following command:
```
/S <stc>,ACTION=STOP
```
where <stc> is the name of the started task. The default name is IZPSRV. You might have configured a different value during UMS installation.
Shut down Zowe.
1. Go to System Display and Search Facility (SDSF) in 3270.
2. Stop ZSS cross-memory server.
```
/p <job_name>
```
  If Zowe defaults have been chosen, job_name should be replaced with ZWESISTC.
3. Stop Zowe server.
```
/p <job_name>
```
  If Zowe defaults have been chosen, job_name should be replaced with ZWESVSTC.
To perform the Db2 Administration Foundation SMP/E installation, see the Db2 Administration Foundation Program Directory. Note the z/OS UNIX location where Db2 Administration Foundation is installed.
To copy modules into libraries for Db2 experiences and to create AFXDAFPO JCL and a PARMLIB member IZPDB2PM, which are required in later steps, complete the following steps:
1. Edit <RUNHLQ>.JCLLIB(IZPEXPIN), which was installed as part of UMS.
  
  Note: The UMSVLOC variable should already be set to the UMS USS Read/Write data location.
2. On the following line, specify the z/OS UNIX directory where Unified Management Server read/write data is located, as specified by IZP_UMS_VARDIR.
```
//SET1 SET UMSVLOC='#izp_ums_vardir'
```
3. On the following line, specify the z/OS UNIX directory where Db2 Administration Foundation was SMP/E installed. The default location is <dir>/usr/lpp/IBM/afx/<vrm>/bin.
```
IZP_EXPERIENCE_LOC=#exp_install_location
```
4. Submit the JCL.
If you receive a return code other than 0, examine the output, correct errors, and resubmit the job.
To set information necessary for later steps, specify the following parameters in the data management product PARMLIB member IZPDB2PM:
IZP_DB2_ALL_SYSNAMES
List all system names on which to APF-authorize load module libraries for Db2 experiences (smphlq.SIZPLINK and smphlq.SIZPLLIB), which are packaged with Db2 Administration Foundation. Separate multiple names with a space and enclose the list of names in quotations. For example:
```
IZP_DB2_ALL_SYSNAMES: "SYS1 SYS2"
```
IZP_DB2_IPL
Specify the name of the PROCLIB member to run after an IPL to invoke the APF authorization facility. The default member is IZPDB2IP. For example:
```
IZP_DB2_IPL: IZPDB2IP
```
Note: Ignore the IZPDAFPM member.
This will be placed into the location specified by IZP_PROCLIB.
The following parameters related to the ISPF message library are required:

defaultPlanName

Name of the default plan that Unified Management Server will always bind to a particular subsystem
To create IZPDB2IP JCL, which is required in the next step, edit the JOB statement of AFXDAFPO in the location specified by RUNHLQ.JCLLIB, and submit the job.

For a description of the IZP_PROCLIB parameter, see Populating IZPUMSPM PARMLIB.

IZPDB2IP JCL will be located in the PROCLIB specified by IZP_PROCLIB.
To APF-authorize load module libraries for Db2 experiences (smphlq.SIZPLINK and smphlq.SIZPLLIB), edit the JOB statement of IZPDB2IP JCL, and submit the job. After an IPL rerun the IZPDB2IP JCL. Alternatively add the two libraries to the PROGxx z/OS PARMLIB member to persist it across IPLs.
Grant users the access to the Db2 catalog tables by completing the steps described in Granting catalog access to Db2 tables.
Start Zowe.
1. Start ZSS cross-memory server.
```
/s <job_name>,reusasid=yes
```
  If Zowe defaults have been chosen, job_name should be replaced with ZWESISTC. You must specify reusasid=yes after <job_name>.
2. Start Zowe server.
```
/s <job_name>,instance='<zowe_instance>'
```
  If Zowe defaults have been chosen, job_name should be replaced with ZWESVSTC. Replace <zowe_instance> with the absolute path of your Zowe instance directory.
To start Unified Management Server, run the following command:
```
/S <stc>
```
where <stc> is the name of the started task (the default is IZPSRV).
In a supported browser, log in to Zowe at the following URL and open IBM Unified Experience for z/OS.
```
https://<hostname>:<port>/ZLUX/plugins/org.zowe.zlux.bootstrap/web/#/
```
where <hostname> and <port> are the host name (or IP address) and port of the Zowe host computer.
Optional: Verify that Db2 Administration Foundation is correctly installed by completing the steps mentioned in Verifying the installation of Db2 Administration Foundation.

What to do next

If you want to generate the DDL of an explored object, you must configure a Workload Manager (WLM) environment for your subsystem:

Create a WLM environment by using the template in JCLLIB(WLMPROC) that points to the load libraries in <HLQ>.SIZPLLIB.
Start the WLM by using the template in JCLLIB(WLMPROC) that points to the WLM you created in step 1.
While registering the subsystem, specify the name of the WLM in the Workload Manager environment field on the Configuration tab.
Note: If the subsystem is already registered, edit the subsystem, specify the WLM environment, and click Update.