Features and BenefitsToad® for DB2 LUW provides:- Greater efficiency when performing daily tasks
- Greater accuracy when writing, debugging and tuning code
- Flexibility to perform many development and administration tasks from a single tool
- A smooth workflow that allows users to move from one task to another easily
- Extensive reporting capabilities that produce quantifiable data and documentation
- Access to DB2 expertise through various Toad user communities
| Features | Toad Standard | Toad Professional | Toad Xpert | Toad Database Administration | | Browse/Edit data | X | X | X | X | | Catalog Browser | X | X | X | X | | Create/alter/drop Objects | X | X | X | X | | Data Compare/Sync | | X | X | X | | Data Import/Export | X | X | X | X | | Data Report Designer | X | X | X | X | | ER Diagrammer | X | X | X | X | | Federated Object Support | X | X | X | X | | LOB Support (Browse/Edit) | X | X | X | X | | Manage DB2 Permissions | X | X | X | X | | Master Detail (RI) Browser | X | X | X | X | | Project Manager | X | X | X | X | | Query Builder | X | X | X | X | | Script Automation | X | X | X | X | | SQL Editor | X | X | X | X | | Stored Procedure Debugger | | X | X | X | | Version Control Integration | X | X | X | X | | Web Browser | X | X | X | X | | XML Support | X | X | X | X | | SQL Optimizer | | | | | | Automatic SQL Rewrite | | | X | | | Index Analysis | | | X | | | Scans Source Code for Problematic SQL | | | X | | | Interactive access path compare | | | X | | | Advanced Administration | | | | | | Attach/Detach Table Partitions | | | | X | | Catalog Statistics Update | | | X | X | | Compare and Synchronize (Schema Objects) | | | | X | | DDL Script Wizard | | | | X | | Display Active Applications with SQL Text | | | | X | | Display Active Utilities | | | | X | | Drop Impact Analysis | | | | X | | Event Monitor Management | | | | X | | Extended Alters | | | | X | | List Active Utilities | | | | X | | Monitor Database Activity | | | | X | | Object Change Recovery | | | | X | | Object Compare/Sync | | | | X | | Object Migration | | | | X | | Partitioned Table Analysis | | | | X | | Remote Script Execution | | | | X | | Space Calculator | | | | X | | Space Estimator | | | | X | | Space Exception Report | | | | X | | Statistics Migration | | | | X | | Space Usage Detail | | | | X | | Transfer Ownership | | | | X | | DB2 Utility Generation | | | | X | | SQLAnalysis (Plug-IN) | | | | X | | Historical SQL collection | | | | X | | Graphical workload analysis | | | | X | | Deadlock report | | | | X | | Other | | | | | | Citrix Support | X | X | X | X | | Technical Support | X | X | X | X |
|