Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6 - Installation Guide

Installation

System requirements

Before installing SQL Optimizer for IBM® DB2® z/OS®, ensure your system meets the following minimum hardware and software requirements:

Platform 600 MHz minimum, 1 GHz recommended
Memory

512 MB of RAM minimum, 1 GB of RAM recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system.
  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database
Hard Disk Space 150 MB hard disk space
Operating System

Windows Server 2008 R2

Windows 7 (32-bit and 64-bit)

Windows 8 (32-bit and 64-bit)

Windows 8.1 (32-bit and 64-bit)

Windows Server 2012

Windows Server 2012 R2

Windows 10 (32-bit and 64-bit)

Windows Server 2016

.NET Framework

.NET Framework 4.0

Note: The .NET Framework Client Profile is not supported.

Database Server

DB2 for z/OS 10, 11, 12

Additional Software

Internet Explorer 7.0 or later.

Adobe Acrobat Reader 7.0 or later (for viewing the Installation Guide).

Install or Upgrade SQL Optimizer

To install or upgrade SQL Optimizer

  1. Run the SQL Optimizer installation program.

  2. Complete the wizard.

Install SQL Optimizer Silently

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To perform a silent installation of SQL Optimizer

Execute the following command:

msiexec /i "path to msi file\QuestSQLOptimizerForIBMDB2zOS_x_x_x_x msi" /qn

Note: The following command line options are used:

Command-Line Option Definition
/i installs the product
/qn Sets user interface to No UI

To perform a silent installation of SQL Optimizer in a directory different from the default product directory

Execute the following command:

msiexec /i "path to msi file\QuestSQLOptimizerForIBMDB2zOS_x_x_x_x.msi" /qn INSTALLDIR="InstallDir"

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating