DB2 for z/OS

Native support has been added for IBM DB2 for z/OS V8 & V9

Vendor: IBM
Website: http://www.ibm.com/software/data/db2/zos/
Database Product: DB2 for z/OS
Description: High-performance database for availability, scalability and reliability - optimized for SOA, CRM and data warehousing.
Note: JDBC Driver db2jcc_license_cisuz.jar (provided with DB2 Connect and DB2 Enterprise Server Edition) must be downloaded from vendor and is not bundled within ADS. Copy the driver into the Aqua Data Studio/lib/drivers folder.

DB2 z/OS Support	DB2 z/OS Query Analyzer	DB2 z/OS ER Modeler	DB2 z/OS Query Builder

Features supported in DB2 for z/OS

- Schema Browser, DDL Scripting, Visual Editing - Tables, Views, Indexes, Users and Roles.
- Query Analyzer - Auto Completion, Syntax Coloring, Grid Results, Pivot Grid Results and Charting toolkit. Saving results to CSV, INSERT statements, XML, HTML and Excel worksheets.
- SQL Formatter - Formatter for SQL statements.
- Table Data Editor - Excel like editor of data in tables and query results.
- Import Tool - Import delimited data files to database or to SQL script of INSERT statements.
- Export Tool - Export to delimited data, Excel Worksheets or SQL Script of INSERT statements.
- SQL History/Archive - Provides a history of all SQL statements and scripts that have been executed within the Query Analyzer, Query Builder, Table Data Editor and SQL Debuggers.
- Schema Script Generator - Script a complete or partial database to file, including CREATE, DROP DDL and INSERT DML.
- Server Script Generator - Allows a user to generate SQL scripts for server objects such as users and roles.
- ER Modeler - Fully functional entity relationship modeler
- Schema Compare Tool - Allows comparison of Schema Objects and Databases, including functions, packages and more.
- Results Compare Tool - Allows comparison of SQL Query results.
- Object Search Tool - Assists in finding Schema and Database Objects within a Database Server.
- Visual Query Builder - Visually design queries