List of Figures

 < Day Day Up > 



Preface

Figure 0-1: From left to right, Ranjit, Ken, Fadel, Whei-Jen, Stefan, Artur

Chapter 1: Introduction

Figure 1-1: Oracle architecture overview
Figure 1-2: DB2 architecture overview
Figure 1-3: Oracle memory architecture
Figure 1-4: DB2 UDB memory architecture
Figure 1-5: Oracle process architecture
Figure 1-6: DB2 processor architecture
Figure 1-7: Oracle database files
Figure 1-8: Oracle directory structure using OFA
Figure 1-9: DB2 Instance and database files
Figure 1-10: DB2 directory structure for a simple create database command
Figure 1-11: DB2 UDB directory structure
Figure 1-12: Configuring the database connection using Configuration Assistant
Figure 1-13: Shared disk architecture
Figure 1-14: Shared nothing architecture

Chapter 3: MTK

Figure 3-1: The IBM DB2 Migration Toolkit (MTK)
Figure 3-2: MTK GUI interface
Figure 3-3: Specify source
Figure 3-4: Convert
Figure 3-5: Refine
Figure 3-6: Generate Data Transfer script
Figure 3-7: Deploy to DB2
Figure 3-8: MTK conversion tasks overview
Figure 3-9: The MTK SQL Translator

Chapter 4: Porting with MTK

Figure 4-1: MTK Project management screen
Figure 4-2: The Specify Source tab
Figure 4-3: Detail of the Connect to Database screen
Figure 4-4: The Extract screen with the ORA_USR schema selected
Figure 4-5: The Extract screen with tables, views and sequences selected
Figure 4-6: The Extract screen with schema and categories expanded
Figure 4-7: The Extract screen with tables, views and sequences selected
Figure 4-8: MTK during the Extract process
Figure 4-9: The categories for the second Extract file
Figure 4-10: The Specify Source tab after all extraction files have been created
Figure 4-11: Viewing extracted files in the Text Editor
Figure 4-12: The Convert tab
Figure 4-13: The Global Type Mapping screen
Figure 4-14: The Advanced Options screen
Figure 4-15: Executing the conversion
Figure 4-16: The Refine tab
Figure 4-17: The Messages sub-tab
Figure 4-18: The Messages sub-tab opened to a specific line in the Oracle source
Figure 4-19: The DB2 file view for message 120
Figure 4-20: Message Help screen displayed for message 120
Figure 4-21: Editing the EMP_ID column in the Text Editor
Figure 4-22: The Generate Data Transfer Scripts tab
Figure 4-23: Advanced Options screen for LOAD
Figure 4-24: The Generate Data Transfer Scripts screen after scripts generated
Figure 4-25: The MTK Deploy to DB2 task screen
Figure 4-26: The Deploy to DB2 screen with deployment information entered
Figure 4-27: The Verification report
Figure 4-28: The Set Context screen after a file has been selected as Context.
Figure 4-29: The Convert tab - context file indicated and the remaining file selected
Figure 4-30: The Refine tab after the conversion of procs_pkgs_trigs.src
Figure 4-31: The Deployment screen before launching procs_pkgs_trgs.db2
Figure 4-32: The Verification Report showing the tally of deployed objects
Figure 4-33: The Verification Report showing objects missing from DB2

Chapter 5: Conversion Reference

Figure 5-1: The Development Center
Figure 5-2: The DB2 Command Window on AIX

Chapter 6: Data Conversion

Figure 6-1: Data movement strategy in a high availability environment

Chapter 7: Application Conversion

Figure 7-1: DB2 CLI and ODBC
Figure 7-2: SAP R/3 database migration project
Figure 7-3: SAP R/3 database migration timeline
Figure 7-4: Siebel migration process

Chapter 8: Script Conversion

Figure 8-1: Backup Wizard
Figure 8-2: Task Center

Chapter 9: Testing

Figure 9-1: Phases during a migration project
Figure 9-2: Table "table01" definition for Example 9-1
Figure 9-3: Data file "table01.unl" for Example 9-1
Figure 9-4: Development Center debug window.
Figure 9-5: Sample db2level output
Figure 9-6: Searching for problem resolutions using TechNotes
Figure 9-7: Sample TechNotes search results
Figure 9-8: Sample TechNotes document link
Figure 9-9: Subscribing DB2 alert
Figure 9-10: Presenting event monitor data using db2eva GUI tool
Figure 9-11: A Visual Explain access plan graph
Figure 9-12: Explaining logical log
Figure 9-13: Visualizing CHNGPGS_THRESH parameter
Figure 9-14: Maximum number of locks available for default settings on UNIX
Figure 9-15: Explaining lock snapshot information
Figure 9-16: Running RUNSTATS on multiple tables
Figure 9-17: Selecting tables for RUNSTAT command.
Figure 9-18: RUNSTAT command options
Figure 9-19: Scheduling Configuration Advisor recommendations
Figure 9-20: Configuration Advisor recommendations
Figure 9-21: The Design Advisor



 < Day Day Up > 



Oracle to DB2 UDB Conversion Guide2003
Oracle to DB2 UDB Conversion Guide2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 132

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net