Oracle Database 10gとIBM DB2 UDB v8.2:高可用性分野での技術比較

Transcription

1 Oracle Database 10g IBM DB2 UDB v8.2 :

2 Oracle Database 10g IBM DB2 UDB v8.2 : : Oracle HA : Oracle DB ORACLE DB Fast Start Fault Recovery ASM Oracle Data Guard DB2 HADR DB v8.2 HADR v Data Guard: Point-in-Time ORACLE DB Oracle Database 10g IBM DB2 UDB v8.2 : 2 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

3 Oracle Database 10g IBM DB2 UDB v8.2 : Oracle Oracle Database 10g HA IBM DB2 Universal Database DB2 UDB HA Oracle Oracle Merrill Lynch Citigroup Southwest Airlines British Telecom General Motors Best Buy Lufthansa Priceline ebay Amazon.com 1 2 Oracle Database 10g Release 2 IBM DB2 Universal Database DB2 UDB 8.2 HA 2 IT HA Oracle Database 10g IBM DB2 UDB v8.2 : 3 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

4 IT 1 2 IT IT IT HA HA HA IBM Oracle HA : Oracle Oracle Database 10g 1 HA [1] [2] Oracle Database 10g IBM DB2 UDB v8.2 : 4 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

5 Oracle Database 10g HA 1: Oracle Database 10g Oracle Oracle Real Application Clusters RAC Oracle Oracle Automatic Storage Management ASM ASM Oracle Oracle Recovery Manager RMAN RMAN Oracle Oracle Database 10g Oracle RMAN Oracle Database 10g Oracle Oracle Hardware Assisted Resilient Data HARD Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 5 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

6 Oracle Data Guard Data Guard Data Guard 1 Data Guard Oracle Oracle Data Guard SQL Apply Oracle Database 10g Release 1 Oracle SMP RAC HA : Oracle DB2 IBM DB2 8.2 Oracle Oracle Database IBM DB2 UDB 1 DB2 8.2 IBM DB2 Oracle 1 IBM DB2 UDB 3 DB2 UDB Unix/Windows Oracle Database 10g IBM DB2 UDB v8.2 : 6 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

7 Oracle Oracle Database 10g Release 2 Enterprise Edition DB2 IBM DB2 Universal Database Enterprise Server Edition DB2 ESE 8.2 Oracle DB2 1: Oracle DB2 Oracle DB2 2 Oracle DB2 LOB Oracle Database 10g IBM DB2 UDB v8.2 : 7 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

8 / ILM Oracle DB2 / / / RAW CLOB/BLOB Oracle DB2 SQL (recycle bin) Oracle Database 10g IBM DB2 UDB v8.2 : 8 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

9 SQL Point-in-Time Point-in-Time Point-in-Time Oracle DB2 Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 9 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

10 ORACLE DB2 Oracle DB2 2: Oracle DB2 Oracle DB2 2 Fast mid-tier connection failover Fast Start Fault Recovery Oracle Fast-Start Fault Recovery 2 Fast Start Checkpointing Fast Start Rollback Oracle MTTR Oracle FAST_START_MTTR_TARGET MTTR Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 10 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

11 [3] DB2 DB2 static SOFTMAX DBA Oracle v$instance_recovery MTTR Oracle Enterprise Manager GUI DB2 SOFTMAX Oracle v$mttr_target_advice I/O DB2 Fast-Start Fault Recovery Oracle DB2 Oracle Oracle Oracle DB2 Oracle 1 DB2 DB2 DB2 [4] Oracle Database 10g IBM DB2 UDB v8.2 : 11 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

12 Oracle DB2 Oracle Real Application Clusters RACDB2 Database Partitioning Feature DPF DPF DB2 Universal Database Enterprise Server Edition DB2 DB2 1 Oracle9i Real Application Clusters Oracle John Kerin RAC DB2/DPF RAC DB2 DB2 Oracle Real Application Clusters DB2/DPF RAC DB2/DPF DB2/DPF IBM DB2 v8.2 High Availability Disaster Recovery HADR DB2 RAC IBM Redbook HADR [5] DB2 DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 12 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

13 RAC DB2/DPF DB2/DPF [6] n n n-1 1 HACMP MSCS REDO DB2 Redistribute Database Partition 1 DB2 Redistribute Database Partition 15 [7] DB2/DPF WHERE CustomerNumber CustomerName CPU 12 I/O DB2/DPF 1 SQL DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 13 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

14 [8] [9] SQL 2 DB2 CustomerNumber 2: DB2 Oracle Database Real Application Clusters Oracle Southwest Airlines Operations for Interactive Marketing Senior Manager Kerry Schwab IBM DB2/DPF 4 4 IBM ab c [8] [9] DB2/DPF 4 12 DB2/DPF 12 Oracle Database 10g IBM DB2 UDB v8.2 : 14 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

15 RAC Oracle Oracle Database 10g RAC RAC DB2 Oracle Database 10g RAC RAC DB2 RAC Oracle Database 10g DB2 BM HACMP RAC DB2 RAC Fast Application Notification JDBC OCI ODP.NET TCP/IP 1 Fast Application Notification DB2 Oracle DB2 Oracle Database 10g Release 2 Oracle Clusterware Cluster Verification Utility [10] Oracle Database 10g IBM DB2 UDB v8.2 : 15 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

16 Oracle DB2 3: Oracle DB2 Oracle DB2 LOB / Information Lifecycle Management ILM 90% RMAN $500,000 CSX Technology IT Charles Pack Oracle DB2 Oracle DB2 Oracle Recovery Manager RMAN RMAN DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 16 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

17 ATA Oracle Database 10g Release 1 RMAN Automatic Storage Management ASM Oracle DB2 Oracle Enterprise Manager 24 Point-in-Time DB2 RMAN SCN DB2 RMAN DB2 IBM [11] DBA RMAN RMAN DB2 RMAN RMAN RMAN RMAN RESTORE RECOVER DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 17 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

18 RMAN DB2 RMAN I/O Oracle LogMiner DB2 Oracle DB2 Oracle DB2 I/O I/O VLDB Oracle VLDB Oracle RMAN Oracle DB2 1 Oracle 1 DB2 Oracle RMAN Oracle DB2 DB2 [12] LOB Oracle Database 10g IBM DB2 UDB v8.2 : 18 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

19 Oracle LOB DB2 [11] Oracle DB2 Oracle Oracle DB2 IBM DB2 DB2 Oracle Information Lifecycle Management ILM 3 ATA Oracle Information Lifecycle Management ILM [13] DB2 Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 19 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

20 3 DB2 DB2 DB2 UNION ALL [14] Oracle DB2 ASM Oracle Database 10g Automatic Storage Management ASM Oracle Oracle Database 10g Automatic Storage Management ASM Oracle ASM ASM ASM ASM ASM DB2 Oracle Hardware Assisted Resilient Data (H.A.R.D.) [16] Oracle Oracle HARD Oracle Database 10g IBM DB2 UDB v8.2 : 20 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

21 Oracle Hardware Assisted Resilient Data (H.A.R.D.) Oracle Oracle Oracle HARD DB2 Data Guard 1 Oracle Data Guard Oracle Data Guard [17]Oracle Oracle Database Enterprise Edition 1 Data Guard DB2 HADR DB2 8.2 HADR [18]HADR IBM Informix Dynamic Server High Availability Data Replication HDR [19] Oracle Data Guard DB2 8.1 DB2 [20] db2uxt2 userexit Yes [21] DB2 5 / FTP Oracle Database 10g IBM DB2 UDB v8.2 : 21 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

22 db2 db2 rollforward db <dbname> to end of logs rollforward db DB2 IBM 8.2 HADR v8.2 HADR v8.1 DB HARD IBM Infomix START HADR STOP HADR rollforward database HARD IBM start hadr on db <dbname> as standby HARD HADR_SYNCMODE SYNC NEARSYNC ASYNC Data Guard HADR TAKEOVER HADR HADR Data Guard Oracle Data Guard: HADR Data Guard Oracle HADR Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 22 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

23 4: Oracle DB2 Oracle DB2 / / / RAW CLOB/BLOB Oracle Data Guard First American Real Estate Solutions Technical Director Ann Collins Data Guard HADR SQL Apply Oracle Data Guard Redo Apply SQL Apply 2 2 Data Guard Data Guard REDO 2 2 Oracle Database 10g IBM DB2 UDB v8.2 : 23 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

24 SQL*Plus DGMGRL Enterprise Manager Grid Control HARD SQL Apply Data Guard SQL Oracle Database 10g Release 1 Real Time Apply HADR / HADR Data Guard DR HADR HADR TAKEOVER BY FORCE Oracle Database 10g Release 2 Data Guard Data Guard DB2 24 HADR Redo Apply Data Guard REDO Redo Apply Redo Apply Oracle Database 10g IBM DB2 UDB v8.2 : 24 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

25 HARD HADR SQL Apply Redo Apply DR HADR HADR HADR / HADR / Oracle Database 10g Release 2 Flashback Across Resetlogs 1 Data Guard / DB2 HADR HADR Data Guard RMAN REDO HADR DB2 HADR HADR /UNDO 1 Data Guard HADR Data Guard 1 REDO Apply Redo Apply SQL Apply / Oracle Database 10g IBM DB2 UDB v8.2 : 25 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

26 HADR DB2 Oracle Database 10g Real-Time Apply Data Guard 1 Flashback Database HADR HADR DB2 RAC Data Guard Oracle HADR HADR DB2 Database Partitioning Feature DPF[18] IBM HA HADR HA Data Guard Oracle RAC RAC REDO RAC Data Guard Oracle HADR HADR HADR_SYNCMODE SYNC NEARSYNC ASYNC ASYNC DB2 [18] [23] HADR HADR HADR_SYNCMODE ASYNC Oracle Database 10g IBM DB2 UDB v8.2 : 26 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

27 Data Guard LAN WAN DB2_HADR_BUF_SIZE Oracle Database 10g Data Guard HADR Data Guard LAN WAN Data Guard LAN WAN DR HADR HADR / HADR HADR Data Guard Oracle Data Guard / Sun Microsystems Sun Services Global Engineering Database Services Staff Engineer Darl Kuhn IBM [24] HADR HADR 1 Data Guard ARCH REDO Oracle Database 10g Release 2 HADR Remote Catchup Pending Remote Catchup logarchmeth1 logarchmeth2 Remote Catchup Oracle Database 10g IBM DB2 UDB v8.2 : 27 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

28 Data Guard LGWRARCH REDO Data Guard HADR HADR HADR Remote Catchup Pending [18] Data Guard Redo Apply SQL Apply HADR HADR Data Guard HADR HADR Data Guard HADR Oracle HADR Data Guard OS Solaris 8 Solaris 9 Data Guard HADR HADR [18] HADR_TIMEOUT HADR_SYNCMODE Oracle Database 10g IBM DB2 UDB v8.2 : 28 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

29 HADR Data Guard HADR HADR TAKEOVER HADR BY FORCE [18]SYNC SYNC START HADR AS STANDBY HADR DB2 HADR [18] TB HADR HADR WAN Data Guard Oracle Flashback Database Data Guard Oracle Database 10g Release 1 Oracle Database 10g Release 2 DB2 Fast-Start Failover DB2 HADR Data Guard Data Guard HADR db2 update alternate server... Oracle Database 10g IBM DB2 UDB v8.2 : 29 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

30 Data Guard Oracle TAF[25] Oracle HADR HADR HADR Data Guard Redo Apply SQL Apply Oracle PL/SQL HADR / HADR [26] Oracle Database 10g Data Guard Oracle Advanced Security Option ASO REDO HADR RAW HADR RAW / Data Guard HADR HADR REDO 2 CPU Data Guard HADR BLOB CLOB IBM [27] 1GB BLOB CLOB Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 30 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

31 BankNorth Group VP of Data Administration Greg Penk Oracle B2 [28] Oracle Oracle DB2 5: Oracle DB2 Oracle DB2 SQL (recycle bin) SQL Point-in-Time Point-in-Time Point-in-Time DB2 Oracle Oracle Oacle Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 31 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

32 Oracle Flashback Drop (recycle bin) BIN$$ (recycle bin)db2 (recycle bin) DB2 [29] Oracle Oracle Flashback Versions Query 2 ID Flashback Transaction Query UNDO UNDO UNDO DB2 LogMiner DBA Flashback Versions Query SQL DDL LogMiner SQL GUI DB2 Point-in-Time Point-in-Time Oracle Oracle Point-in-Time Oracle Database 10g IBM DB2 UDB v8.2 : 32 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

33 undo DB2 Oracle Point-in-Time DB2 DDL Point-in-Time DB2 Point-in-Time [29] [30]DB2 / Oracle Flashback Table SQL Point-in-Time FLASHBACK TABLE <table> TO TIMESTAMP <timestamp> UNDO DB2 Point-in-Time Oracle Flashback Database Point-in-Time REDO Point-in-Time DB2 Flashback Database RMAN QA Flashback Database ReserveAmerica Joshua Ort Oracle DB2 Point-in-Time Point-in-Time Point-in-Time 10 GB 1 10 TB Oracle Database 10g IBM DB2 UDB v8.2 : 33 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

34 3: Flashback Database Point-In-Time RTO Oracle DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 34 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

35 ORACLE DB2 CPU DB2 Oracle 6: Oracle DB2 Oracle DB2 DBA Oracle PartitioningOption DB2 PartitioningOption DB2 DBA 3 Oracle Database 10g IBM DB2 UDB v8.2 : 35 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

36 Amazon 14 HP 32CPU 2 HP 5 Amazon.com Director of DB Services Matt Swan 1 RAC RAC ASM Oracle ASM I/O DB2 Oracle IBM DB2 8.1 Oacle Oracle DBA DB2 DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 36 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

37 HA Oracle DB2 8.2 Database Manager Configuration Database Configuration [31] HA DBA Oracle DB2 7: Oracle DB2 Oracle DB2 DB2 Oracle DB2 2 DB2 Adding a Cluster Node Oracle Database 10g IBM DB2 UDB v8.2 : 37 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

38 DB2 Oracle Oracle DB2 Oracle DB2 Oracle DB2 IBM Innocent Bystander DB2 1 DB2 IBM DB2 v8.1 DB2 v8.2 Automating Database Maintenance DB2 v8.2 Automatic Database Maintenance DB2 REORG INDEXES [32] REORG TABLE [32] Oracle Oracle DML DB2 v8.1 DB2 v8.2 Oracle DBA Amazon.com Director of DB Services Matt Swan Oracle Oracle9i DB2 Oracle Database 10g IBM DB2 UDB v8.2 : 38 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

39 2 Oracle8i DB2 DB2 Control Center Indexes Control Center Tables Reorganize Indexes REORG INDEXES ALL FOR TABLE Oracle Oracle / IOT IOT IOT IOT Amazon Amazon.com Director of DB Services Matt Swan Oracle Database 10g Release 2 CHECK NOT NULL Oracle Database 10g IBM DB2 UDB v8.2 : 39 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

40 DB2 DB2 Oracle Oracel DB2 Oracle DB2 Oracle Oracle Oracle DB2 Oracle Oracle Maximum Availability Architecture MAA [33]Oracle Maximum Availability Architecture MAA Oracle MAA Oracle Oracle Oracle Maximum Availability Architecture Oracle MAA MAA MTTR Oracle High Availability Systems Engineering Group MAA Oracle Oracle9i Oracle Database 10g MAA Web [33] Oracle Database 10g IBM DB2 UDB v8.2 : 40 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

41 MAA MAA Oracle Enterprise Manager Oracle Application Server Oracle E-Business Suite Oracle Collaboration Suite Oracle Oracle HA IBM DB2 HA Oracle Oracle Oracle Database [34]Oracle [35] [36] Maximum Availability Architecture Ohio Savings Bank Oracle Global IT Oracle Database 10g Maximum Availability Architecture WAN Oracle E-Business Suite Data Guard RAC BACS LTD BT Group Chicago Stock Exchange Genentech BACS LTD Oracle9i BT Group Oracle9i 20 1 Chicago Stock Exchange Oracle HP 100% Genentech Oracle9i Real Application Clusters 2 Oracle Database 10g IBM DB2 UDB v8.2 : 41 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

42 Southwest Airlines Talk America Southwest Airlines Oracle Database 10g RAC ASM 10 Data Guard ADT Security Services Amadeus Fannie Mae First American Real Estate Solutions Swedish Post VP Bank Data Guard SQL Apply Data Guard Data Guard POC: Oracle Database 10g Oracle9i Data Guard Oracle Database 10g Data Guard Data Guard SQL Apply DR Data Guard SQL Apply RMAN ChevronTexaco CSX Fannie Mae Starwood Hotels Trilegiant Purdue Pharma L.P Colgate-Palmolive RMAN DUPLICATE DBA RMAN 16TB 1TB/ Oracle Database 10g RMAN RMAN 8TB RMAN RMAN Banknorth Group, Inc ReserveAmerica Oracle 10g Oracle Database 10g IBM DB2 UDB v8.2 : 42 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

43 Oracle Oracle Oracle Oracle Oracle RAC Data Guard RMAN DB2 Oracle Oracle RAC Data Guard RMAN Oracle Maximum Availability Architecture Oracle Oracle Oracle DB2 DB2 Oracle Oracle Database 10g IBM DB2 UDB v8.2 : 43 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

44 1. Oracle 2. Oracle 3. Oracle9i 4. High Availability and Crash Recovery in Oracle9i Database pdf 5. IBM Redbook DB2 UDB V8.2 on the Windows Environment 6. DB2 Universal Database for Windows High Availability Support Using Microsoft Cluster Server Overview (TR ) df 7. IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Chapter 11: Redistributing Data Across Database Partitions 8. IBM DB2 Universal Database Administration Guide: Planning, Version 8.2, Chapter 5: Physical Database Design 9. IBM DB2 Universal Database Application Development Guide: Programming Client Applications, Version 8.2, Chapter 31: Programming Considerations for Partitioned Database Environments 10. Oracle 10g Real Application Cluste IBM DB2 UDB v IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 1: Developing a Good Backup and Recovery Strategy 12. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 2: Database Backup 13. Overview: Oracle Information Lifecycle Management Partitioning in DB2 Using the UNION ALL View uzarte.pdf 15. Overview: Automatic Storage Management Overview: Oracle Hardware Assisted Resilient Data (HARD) Initiative Oracle Data Guard Oracle Database 10g IBM DB2 UDB v8.2 : 44 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

45 doverview.html 18. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 7: High Availability Disaster Recovery (HADR) 19. A look at the new functions in DB2 Universal Database V8.2 /index.html 20. The Basics of DB2 Log Shipping mcinnis.html 21. Setting Up a User Exit on DB2 UDB V8 to Archive Database Logs e.html 22. An Overview of Transactional Logging in DB2 Universal Database e.html 23. IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Appendix A: DB2 Registry and Environment Variables 24. Technical Comparison of DB2 HADR and Oracle Data Guard Oracle MetaLink Note : Data Guard 9i Configuring Transparent Application Failover in a Data Guard Environment IBM DB2 Universal Database Introduction to Replication and Event Publishing : Comparison of Q replication to high availability disaster recovery (HADR) 27. IBM DB2 Technote HADR and LOB replication, view.htm 29. IBM DB2 Universal Database Data Recovery and High Availability Guide and Reference, Version 8.2, Chapter 4: Roll Forward Recovery 30. IBM DB2 Technote What is the purpose of the minimum recovery time for a tablespace? IBM DB2 Universal Database Administration Guide: Performance, Version 8.2, Chapter 13: Configuring DB2 32. IBM DB2 Universal Database Command Reference, Version 8.2 Oracle Database 10g IBM DB2 UDB v8.2 : 45 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

46 33. Maximum Availability Architecture MAA Oracle Customers Oracle High Availability Case Studies Real Application Clusters Oracle Database 10g IBM DB2 UDB v8.2 : 46 Oracle Corporation Technical Comparison of Oracle Database 10g vs. IBM DB2 v8.2: Focus on High Availability

47 Oracle Database 10g IBM DB2 UDB v8.2 : : Ashish Ray : Donna Cooksey Joseph Meeks Larry Carpenter Lilian Hobbs Paul Tsien Tammy Bednar Timothy Chien Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. : : : Copyright 2005, Oracle. Oracle Oracle Corporation