DB2 9 vs Oracle 10g Admin. Technology

103 Pages·2008·2.2 MB·English

IBM Software Group
DB2 9 vs Oracle 10g Admin. Technology
2008-04-22
IBM DB2 Open Forum 3rd
Version 2.0 Aug. 20, 2006
Burt Vialpando & Vikram Khatri
©2008IBM Corporation
DB2 Information Management
Agenda
Topics
DB2 소개 및 개요
DB2 인스턴스 및 CLP
DB2 데이터베이스
DB2 백업 및 복구
DB2 HADR(High Availability Disaster Recovery)
DB2 동시성
©2008IBM Corporation DB2 9 vsOracle 10g 2
IBM Software Group
DB2 소개 및 개요
IBM DB2 Open Forum 3rd
9 slides
©2008IBM Corporation
DB2 Information Management
제품 패키징
비교
Oracle
● Oracle Lite
(cid:23) Windows CE, Palm, EPOC, Windows 95/98/NT
● Oracle Personal Edition
(cid:23) Windows
● Oracle Standard Edition
(cid:23) Windows CE, LINUX (2 dist.), AIX, HP-UX, HP Compaq, Solaris, Tru64
● Oracle Enterprise Edition
(cid:23) Windows CE, LINUX (2 dist.), AIX, HP-UX, HP Compaq, Solaris, Tru64
(cid:23) RAC is an optional purchase feature
DB2
● DB2 Everyplace 9
(cid:23) Windows CE, Palm, EPOC, Windows XP/Tablet PC, QNX Neutrino, Symbian, eLinux, Linux on PC
● DB2 Express 9
(cid:23) Windows, Linux (200 dist.)
● DB2 Workgroup 9
(cid:23) Windows, Linux (200 dist.), AIX, HP-UX, Solaris
● DB2 Enterprise 9
(cid:23) Windows, Linux (200 dist.), AIX, HP-UX, Solaris, Linux/390
(cid:23) Database Partitioning Feature optional purchase DPF
(cid:131) Try DPF or extenders free with licensing update ability !
©2008IBM Corporation DB2 9 vsOracle 10g 4
DB2 Information Management
DB2 Express-C 9
무료 라이센스 제공
DB2 Express-C 9 is:
Production Ready Innovative Technology Developer Friendly
(cid:131) Free to develop, deploy
(cid:131) Same superior data (cid:131) Dedicated team for DB2
and redistribute*
server technology and community participation &
(cid:131) No database size limit programming support as development
DB2 Express Edition in a
(cid:131) No limit on number of (cid:131) Free online community
smaller package
instances per server support
(cid:131) No user limit (cid:131) Skills & applications
applicable to all editions
* Free registration required
of DB2
DB2 Edition Comparisons
Express 9/Express-C 9 Workgroup 9 Enterprise 9
(cid:131) Linux & Windows, (cid:131) Linux, UNIX & Windows, (cid:131) Linux, UNIX & Windows,
32 and 64-bit platforms 32 and 64-bit platforms 32 and 64-bit platforms
(cid:131) 1-2 CPU Server (cid:131) 1-4 CPU Server (cid:131) No limits
(cid:131) 4GB Memory (cid:131) 16GB Memory (cid:131) Partitioning feature
©2008IBM Corporation DB2 9 vsOracle 10g 5
DB2 Information Management
동일한 코드 기반
● 100% Common Code Base Pros & Cons
(cid:23) A 100% common code base would
(cid:131) Allow for faster distribution of releases & fixes
(cid:131) Give a higher likelihood of identical functionality
(cid:131) Give similar installation procedure for all platforms
(cid:23) A 100% common code base would not
(cid:131) Benefit from performance & functionality strengths
inherent to specific platforms
● Oracle Solution
(cid:23) Oracle develops on a few OS’s, then ports to others
● IBM DB2 Solution
(cid:23) DB2 data server has about a 90% common code base for LUW
(cid:131) Varying by about 10% for operating system & hardware differences
(cid:131) All supported OS versions for LUW released simultaneously
(cid:23) IBM develops on the platforms it supports to optimize the code for them
(cid:131) Porting is not done
(cid:23) DB2 z-OS, iSeries and VM/VSE products are a different code base
(cid:131) Which take advantage of these platforms
(cid:23) DB2 end users & DBAs see little difference externally
(cid:131) Mostly for OS considerations
(cid:23) Using DPF on LUW does not require a new code install
©2008IBM Corporation DB2 9 vsOracle 10g 6
DB2 Information Management
툴 및 제품
관리 & 개발 툴 & 제품
Oracle IBM Description of Usage
Oracle 10g Enterprise Edition DB2 Enterprise 9 Relational Database Management System
• Oracle Enterprise Manager • DB2 Control Center GUI database master console, control,
• Enterprise Login Assistant • DB2 Web Query Tool management, auto login, recovery, etc.
• Database Configuration • DB2 Recovery Expert
Assistant • DB2 High Performance Unload
• Administration Assistant • DB2 Performance Expert
• Oracle SQL Plus DB2 Command Editor GUI level line oriented & script saving
Worksheet database access
• iSQL
Oracle SQL Plus DB2 Command Line Processor OS level line oriented database access
Oracle Net Config. Assistant DB2 Configuration Assistant Node cataloging & connecting, networking
Oracle SQL Analyze • DB2 Visual Explain Query analysis & visual explains
• db2exfmt, db2expln
ADDM DB2 Event Monitor / Analyzer Database event info. collection & analysis
Oracle Forms Developer DB2 Table Editor Developer Suite Forms creation, development, usage
Oracle Progress Monitor DB2 Query Patroller(9.5 Workload Query & session monitoring
Management)
Oracle Procedure Developer DB2 Developer Workbench Stored procedure & other object development
• Oracle Spatial & Intermedia • DB2 Relational Extenders Image searching, content management
• Oracle Time Series • IBM Content Manager (and family
• COM Cartridge of products which are many)
©2008IBM Corporation DB2 9 vsOracle 10g 7
DB2 Information Management
툴 및 제품
통신 & 연결 툴 & 제품
Oracle IBM Description of Usage
Files Online (iFS 8i) Data Links Manager File system for Internet use
• Oracle Transparent • DB2 Discovery Link Federation
Gateway • DB2 Connect, DB2 Relational
• Oracle Access Managers Connect
for CICS, IMS, DB2 • WebSphere Information Integrator
• Advanced Replication • MQ Series Replication, message queuing
• Message Broker • DB2 Q Replication
• Oracle Streams • DB2 SQL Replication
• Internet Commerce Server • WebSphere Portal Studio Internet servicing, connection
• Internet Application Server • IBM Enterprise Information Portal
©2008IBM Corporation DB2 9 vsOracle 10g 8
DB2 Information Management
툴 및 제품
인터넷, 자바, 데이터 웨어하우징 & OLAP 툴 & 제품
Oracle IBM Description of Usage
• JDeveloper • Visual Age Family Java & web development & object modeling
• Oracle Designer • WebSphere Studio
• Oracle Portal (WebDB) • Net.Data
• Oracle Objects • IBM Content Manager
• Oracle Data Mart Suite • DB2 Data Warehouse Manager Data Warehouse building , data movement,
• Warehouse Builder • DB2 Data Propagator management
• IBM Data Refresher
• WebSphere Inf. Integrator
Oracle Pure*Integrate Vality Integrity Data cleansing
One Meaning Information Catalog Metadata sourcing
• Oracle Express Server • DB2 OLAP Server OLAP, data marts, cubes
• Oracle Express Objects • Data Warehouse Center
• Oracle Discoverer • QMF Reporting in all its forms
• Oracle Reports • DB2 Web Query Tool for
Multiplatforms
• Oracle Data Mining Suite • DB2 Intelligent Miner Data mining
• Oracle Darwin • DB2 OLAP Server Miner
©2008IBM Corporation DB2 9 vsOracle 10g 9
DB2 Information Management
툴 및 제품
DB2 GUI 로드맵
x
DB2
Configuration
Desktop
Assistant
(db2ca) Folder
Replication
DB2 Center Control Development First Steps
Command (db2rc) Center Center (db2steps)
Window (db2cc) (db2dc)
Command
(db2cmd)
Editor Satellite
(db2ce) Administration
Center
DB2 Alert
Command Center
Line SQL Assist
Processor Task
x
Information
(db2) Center Tool
(db2tc) Folder
Activity Settings
Monitor Journal (db2ic)
(db2am) License
Center
Smart Health
Visual Data
WGiuziaderdss Center
Explain Warehouse
or Wizards (db2hc)
Center
● Tools that can be started from a command prompt show the commandin parenthesis
● Most others are accessed through the Control Center & Command Center
©2008IBM Corporation DB2 9 vsOracle 10g 10