Toad for
IBM DB2 z/OS
Visit shop.quest.com to buy this product online.
Buy online »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Tech Brief
Discover insider secrets that will help you become an effective DB2® administrator in record time.
Read now »

White Paper

In this white paper, DB2 expert Jim Wankowski examines the key architectural and administrative differences between DB2 LUW and DB2 z/OS.

Read now »

Toad for IBM DB2 z/OS

Simplified Administration and Performance Management

Toad® for IBM DB2® z/OS simplifies database administration and development through an intuitive graphical interface. Its interactive tuning lab makes it easy to improve SQL quality. With this DB2 administration tool, you can fly through object management, comparison, and synchronization. It even helps you create custom reports in record time.

Find the Toad for DB2 bundle that’s right for you »

  • Delivers catalog browsing and reporting at a glance
  • Offers streamlined SQL development and deployment
  • Improves SQL quality through an interactive tuning lab
  • Simplifies DB2 object management, comparison, and synchronization
  • Helps you create custom reports
  • Fosters knowledge exchange through a healthy online community

System Requirements

Client Requirements

Note: If a DB2 for LUW 7 client is installed on the machine where you are installing Toad, you must upgrade the DB2 client to version 8 before installing Toad for DB2 to avoid losing functionality in some DB2 native tools.

Platform1 GHz minimum
Hard Disk Space212 MB of disk space required to run Toad

Allocate the following additional space as needed:
  • If installing the Toad SQL Tuning for DB2 z/OS component, allocate an additional 45 MB.
  • If installing Toad SQL Analysis for DB2 LUW, allocate an additional 47 MB.
  • If installing the Quest SQL Optimizer for DB2 LUW, refer to the Release Notes for that product for disk space requirements.
Memory512 MB of RAM minimum, 1 GB recommended

Note: The memory required may vary based on the following:
  • Applications that are running on your system when using Toad
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Supported Operating SystemsAny of the following:
  • Windows Server 2003 (32-bit)
  • Windows XP Professional (32-bit)
  • Windows Vista (32-bit)
  • Windows Server 2008 (32-bit)
  • Windows 7 (32-bit or 64-bit)
Note: The Toad SQL Analysis for DB2 LUW client is not supported on Windows Vista, Windows Server 2008, or Windows 7.
.NET Framework.NET Framework
Microsoft .NET Framework 3.5 (Service Pack 1)
Notes:
  • The .NET Framework Client Profile is not supported.
  • To run Toad, the .NET security policy must be set to unrestricted. See User Privilege Requirements for more information.
Additional RequirementsWeb Browser 
Microsoft Internet Explorer 6.0 or later

Existing DB2 Client Support
Toad installs a DB2 for LUW 9.7 client as part of the installation process. The DB2 9.7 client can co-exist with an existing DB2 8 client; however, it is incompatible with a DB2 7 client. If a DB2 7 client is already installed on the system, the Toad installation stops and cannot complete. To avoid losing functionality in some DB2 native tools, first upgrade to the DB2 8 client; then restart the Toad installation.

Requirements for Windows 7 32-Bit and 64-Bit Environments
Toad provides a 32-bit and a 64-bit Toad DB2 client installer. The 32-bit client installs in any Toad-supported Windows environment. The 64-bit client installs in a Windows 7 64-bit environment only. Additionally, a 32-bit and a 64-bit IBM DB2 client cannot exist on the same computer. Based on this restriction, install the appropriate 32-bit or 64-bit Toad DB2 client if another DB2 client already resides on your 64-bit computer. 

Monitor Resolution
SVGA monitor with a minimum resolution of 800x600, 1024x768 is recommended.

Language Supported:

  • US English