Verify that your environment meets software requirements

Edit online

Prior to beginning the customization process, ensure that your environment is running the required versions of Db2® and meets implementation requirements for functions that you plan to use.

Db2 version support

Db2 Automation Expert supports the following versions of Db2 for z/OS®, until end of support for the given Db2 version. See the topics Db2 12 function level support and Db2 13 function level support for information about specific Db2 function level toleration and support in Db2 Automation Expert.
  • Db2 12
  • Db2 13 with APAR PH51878 (UI90506) applied

Maintenance window functionality requirements

If you plan to use the maintenance window functionality in Db2 Automation Expert:

  • If you plan to use the Create and Auto-schedule option for maintenance windows when setting job generation options, the Db2 administrative task scheduler is required. See Administrative task scheduler requirements for additional requirements.
  • The TSO user ID that schedules the maintenance window is the user ID that runs all utilities in the maintenance window. Therefore, the user ID that schedules the maintenance window must have the authority to run those utilities on the Db2 objects.
  • The TSO user ID that schedules the maintenance window is the user ID that is used to the schedule the window via the Db2 administrative task scheduler. Therefore, the user ID that schedules the maintenance window also must have the authority to add scheduled tasks to the Db2 administrative task scheduler.

Administrative task scheduler requirements

If you plan to use the Db2 Automation Expert interface to the Db2 administrative task scheduler:

  • The Db2 subsystems must be configured to enable Db2 administrative task scheduler capabilities.
  • The ADMTPROC ZPARM keyword indicates the name of the JCL procedure to start the administrative task scheduler.
  • RACF® must be configured to allow PassTickets for the Db2 administrative task scheduler task that includes READ authority to the profile in their APPL class.

Requirements for smarter reorganization recommendations

If you plan to use Db2 Automation Expert with Db2 Query Monitor to leverage the smarter reorganization recommendations feature, you must have Db2 Query Monitor V3.3.0 with APAR PI92519 or later installed and configured on the subsystem. In addition, complete the steps that are required for AT-TLS security in Customizing AT-TLS security for smarter reorganization recommendations.

Requirements for streaming data to analytics platforms using IBM Z OMEGAMON Data Provider

If you plan to stream data to external data visualization analytics platforms such as Elastic via the Db2 Automation Expert API with IBM® OMEGAMON® Data Provider, you must have installed either:
  • OMEGAMON Data Provider 5.6 or later (FMID HKOA110) with APAR OA64880 applied
  • If you do not already have OMEGAMON Data Provider installed as part of an OMEGAMON suite, the OMEGAMON Data Provider installation samples FMID JZOA11A is required.
  • Streaming utility history requires a Db2 13 function level 501 or later subsystem.
  • Streaming utility object-level history requires a Db2 13 function level 504 or later subsystem.

Requirements for the Db2 Automation Expert ad-hoc utility API

If you plan to use the Db2 Automation Expert API callable service that can run ad-hoc Db2 utilities on table spaces and indexes, IBM Unified Management Server for z/OS 1.2.0 must be installed with APAR PH56865 applied. For more information, refer to software requirements for UMS in the UMS documentation.

Requirements for Db2 Utility Compare

The Db2 Utility Compare feature requires the following:
  • APAR PH61837 must be applied to Db2 Automation Expert.
  • Db2 13 function level 504 or later is required, as is activation of utility history and object-level utility history. For more information, see the topic about Db2 13 function level 504 in IBM Db2 for z/OS documentation.

Requirements for statistics monitor profiles

If you plan to use the Db2 Automation Expert statistics monitor profiles, the following Db2 stored procedures must also be configured, and users' authorization IDs must have execute authority on them:

  • ADMIN_UTL_EXECUTE
  • ADMIN_UTL_MONITOR
Note: If Db2 maintenance is applied to the Db2 ADMIN_UTL_MONITOR stored procedure, you might encounter SQL error -478, because the Db2 Automation Expert stored procedure for statistics maintenance (DAJ.ADMIN_UTL_MONITOR) depends on it. In that case, drop the Db2 Automation Expert DAJ.ADMIN_UTL_MONITOR stored procedure and recreate it after applying the maintenance. The procedure can be dropped by issuing SQL as follows: DROP PROCEDURE DAJ.ADMIN_UTL_MONITOR. Recreate the Db2 Automation Expert stored procedure by selecting and generating the jobs for the Tools Customizer step Create or update Db2 objects. Then run the generated job that is based on template DAJDDLJ. Refer to Task: Create or update Db2 objects in the customization topics for instructions.

Requirements for image copies on IBM ESS devices

If you plan to use Db2 Automation Expert to build utility JCL for image copies of objects on IBM ESS devices, you must have IBM Enterprise Storage Server® devices with Advanced Copy Services, and the DFSSMS system data mover (SDM) API (macro ANTRQST) must be at level 5 or later.

Requirements for image copies from Db2 Recovery Expert system-level backups

If you plan to use Db2 Automation Expert to make image copies from Db2 Recovery Expert system level backups (SLBs), you must have Db2 Recovery Expert V2.2 with APAR PM06332 or later installed on the subsystem.