Software requirements for Db2 Administration Foundation
Before you install and configure IBM Db2 Administration Foundation for z/OS for use with the Unified Management Server, make sure that your environment meets the following minimum software requirements.
Important: Unified Management Server
1.2.0 requires
Db2
Administration Foundation 1.2.0. Db2
Administration Foundation 1.1.0 is not supported by
Unified Management Server
1.2.
- The Zowe version 2.3.0 or later is installed.
- All of these versions of Db2 for z/OS
are supported as of the General Availability (GA) date of Unified Management Server
1.2. If a version of Db2 for z/OS is
withdrawn from service, it will no longer be supported by Unified Management Server:
- Db2 for z/OS, 12.1 (5650-DB2)
- Db2 for z/OS Value Unit Edition, 12.1 (5770-AF3)
- Db2 for z/OS, 13.1 (5698-DB2)
- Db2 for z/OS Value Unit Edition, 13.1 (5698-DBV)
- Db2 supplied administrative
enablement stored procedures ADMIN_COMMAND_DSN, ADMIN_COMMAND_DB2,
ADMIN_INFO_SYSPARM, and DSNUTILV must be operational.Note: IBM Db2 Administration Foundation for z/OS does not require the Db2 Administrative Scheduler.
Requirements for additional capabilities
Several features of Db2
Administration Foundation require
additional software. The following list describes the requirements to use these
features.
- To tune SQL statements from the Db2
Administration Foundation user interface, you
must install and configure one of the following SQL Tuning Services
products:
- IBM Database Services Expansion Pack is available at no additional cost to licensed Db2 Accessories Suite for z/OS users and includes a subset of all the available SQL Tuning Services features.
- IBM Db2 Query Workload Tuner for
z/OS 6.1 can be purchased separately or as part of the
Db2 Performance Solution Pack for z/OS, which contains all the
features that are included in IBM Database Services Expansion Pack
along with a more robust set of SQL analysis and tuning
features.
For more information about the features included in these two offerings, see Overview of IBM SQL Tuning Services.
- To manage accelerators and accelerated queries from the Db2 Administration Foundation user interface, install and configure IBM Db2 Analytics Accelerator 7.5.9.0.
- To load table data to one or more accelerators in a Db2 for z/OS subsystem,
install Db2 Analytics Accelerator
Loader version
2.1 and apply APAR
PH54984
. Also, ensure that APARsPH54968
andPH54452
are applied. - To enable the Storage tab for indexes and table spaces,
ensure that Db2 Administration Tool
version 13 is installed and that APARs
PH54968
andPH55177
are applied.
Note: These additional software
components must be installed on the same system that IBM Unified Management Server is installed. Otherwise,
UMS will shut down when you attempt to use these components.