来源于:王鹏飞《运筹帷幄DB2:从Oracle运维转型》
描述 | Oracle | DB2 |
产品版本 | Oracle 11g Enterprise Edition | 1)DB2 9.7 Enterprise Server Edition 2)DB2 9.7 Advanced Enterprise Server Edition |
管理工具 | Administration Assistant | Optim Database Administrator |
监控工具 | Oracle Enterprise Manager | Optim Performance Manager |
开发工具 | SQL Developer | Data Studio |
命令行工具 | Oracle SQLPLUS | 1)CLP Plus 2)Command Line Processor(CLP) |
配置助手 | Oracle Configuration Assistant | DB2 Configuration Assistant |
查询分析工具 | Oracle SQL Analyzer | 1) IBM Optim Query Tuner 2) DB2 Visual Explain |
Forms开发工具 | Oracle Forms Developer | DB2 Table Editor Developer Suite |
工作负载管理 | Oracle Database Resource Manager | DB2 Workload Manager |
数据移动工具 | exp/imp/SQL/SQL*Loader | DB2 export/import/load |
备份恢复命令 | RMAN(backup/restore/rollforward/recover | DB2(backup/restore/rollforward/recover) |