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 APARs PH54968 and PH54452 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 and PH55177 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.