Quickly and accurately perform your daily development or administration tasks with Toad™ for IBM® DB2 z/OS. Its extensive automation and intuitive workflow dramatically simplify SQL management, SQL tuning, object management, and much more. This robust DB2 tool incorporates more than a decade of development expertise and user experiences to make DB2 management easier than ever.
- Powerful task automation
- Automate and schedule frequent and repetitive tasks.
- Improved code performance
- Debug stored procedures, format code and optimize SQL performance following best practices methodology.
- Easy object management
- Create and manipulate database objects through intuitive GUIs.
- Streamlined compare and synch
- Lets you compare and sync servers, schemas, and data, and easily identify differences.
- Performance-problem identification and resolution
- Enables performance tuning with automated SQL scan, optimization, and benchmarking; no other tool offers the level of performance tuning that is available in Toad Xpert.
- Group execute
- Processes scripts and code snippets against multiple servers and instances.
- Log reader
- Rolls back transactions in the transaction log without the need to restore from a backup.
- SQL script recall
- Tracks any SQL executed during your Toad session and eliminates the need to retype commonly used SQL, saving time.
- Security management
- Builds and executes security-related scripts against multiple servers to create, manage, and even replicate security for all users.
- Report generation and documentation
- Create customized reports for administration and development and export those reports in flexible formats including .xls, XML, .doc and .pdf.
- Object search
- Search for text in database objects, e.g., column names and SQL code; helps you rapidly locate code to quickly assess the impact of renaming or code changes.
- Project management
- Save and reuse powerful features for object management, SQL, and stored procedure coding.
- Query builder
- Access key data quickly; includes built-in report and pivot functionality, which allows for in-place analysis and single-click export to an Excel instance, so DBAs and analysts can easily export to their favorite tools.
- Complete suite
- Provides a comprehensive, end-to-end toolset, from development through production administration, as well as integration with Spotlight for performance diagnostics.
- Consistent toolset across database platforms
- Minimizes the learning curve across multiple platforms with a similar look and feel while providing deep functional expertise for the nuances of each platform.
Note: If an IBM DB2 for LUW 7 client is installed on the machine where Toad is going to be installed, you must upgrade the DB2 client to version 8 before installing Toad for DB2 to avoid losing functionality in some DB2 native tools.
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:
1 GHz minimum
512 MB of RAM minimum, 1 GB recommended
Note: The memory required may vary based on the following:
Hard Disk Space
212 MB to run Toad for IBM DB2
Allocate additional space for the following components as needed (provided with Xpert Editions):
Note: The disk space required may vary based on the edition of Toad selected for installation.
Windows Server 2003 with Service Pack 2 or later
The Microsoft® .NET Framework is required. The version is dependent on the operating system.
In addition to above requirement, .NET Framework 3.5 (SP1) is also required on Windows XP, Windows Vista, or Windows Server 2003.
Toad installs a DB2 client as part of the installation process.
Requirements for 32-Bit and 64-Bit Environments
Toad for IBM DB2 provides a 32-bit and a 64-bit Toad for IBM DB2 DB2 client installer. The 32-bit client installs in any Toad-supported Windows environment. The 64-bit client installs in a 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 for IBM DB2 DB2 client if another DB2 client already resides on your 64-bit computer.
Microsoft Internet Explorer 7.0 or later
Note: Toad may support other internet browsers in addition to Internet Explorer, but note that no testing was performed on it.
Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:
IBM DB2 for z/OS 9, 10, 11.1
Note: Toad may support IBM DB2 Express and SWE in addition to listed above servers, but note that no testing was performed on it.
Operating System Platforms for Toad for DB2 Agent
Toad for IBM DB2 requires that the Toad for IBM DB2 for DB2 Agent reside on each DB2 for LUW server on which you intend to execute scripts server-side (using the Toad for IBM DB2 LUW Remote Script Execution feature).
The agent supports servers running in any of these operating systems:
Note: The following additional requirements apply:
See the Toad for IBM DB2 for DB2 LUW Agent Installation Guide for complete agent requirements and installation details.
Hard Disk Space for Toad for DB2 Agent
For the Toad for IBM DB2 LUW Remote Script Execution component, 34.9 MB
Review the following information about using Toad for IBM DB2 in virtual environments:
Limited testing has been performed for Citrix XenApp 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.
Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.
Desktop Virtualization (VDI)
Toad has been tested with Quest vWorkspace 7.6 running on Windows Server 2008 R2 64-bit.
Note: Toad may work in virtualization environments other than the ones in which it was tested.
- Added support for IBM DB2 z/OS v11.1
- Integration of SQL Optimizer (available in Xpert Edition, Development Suite and DBA Suite)
- Support for Compatibility mode and ENF mode
- Supports new z/OS 11.1 statement ALTER table DROP COLUMN clause
- Ability to Add Storage to support PCT FREE FOR UPDATE clause statement in z/OS 11
- Improved Table Editor making it easier to work with columns
- Multiple database query facility for cross-database reporting
- Advanced mapping features for compare and sync
- Advanced features for automating scripts and activities
- Data compare features to sync data across databases
- Extended DB2 z/OS utility support
- Simplified tablespace management
- Fixes and enhancements to the 5.2 release
- Ability to manage temporary tables on LUW and z/OS environments
- Ability to view list of invalid objects and revalidate them
- Flush event monitors
- Ability to view statements in the Dynamic Statement Cache
- More customizable interface with dual-monitor support
- Ability to select columns in Query Builder via checkbox method
- Reverse engineering of Select statements that contain an ALIAS
- Code snippet import/export functionality