Flylib.com
List of Figures
Previous page
Table of content
Next page
< 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 >
Previous page
Table of content
Next page
Oracle to DB2 UDB Conversion Guide2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 132
BUY ON AMAZON
VBScript Programmers Reference
Variables and Procedures
Regular Expressions
Remote Scripting
HTML Applications
Appendix J VBA Features not in VBScript
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Creating Tables
The PostgreSQL C APIlibpq
PostgreSQL Administration
Securing the PostgreSQL Data Files
Using Full-text Search
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
The AJAX Control Toolkit
Built-in Application Services
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Cause and Effect
Rotoscoping Techniques with Photoshop
Static Matte Painting in Photoshop
Motion Matte Painting in Photoshop
Appendix Adobe Photoshop and After Effects Resources
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Using the System.Management Namespace
Handling WMI Events
The WMI Schema
WMI Security
Digital Character Animation 3 (No. 3)
Design Styles
Surface Types
Animating with Poses
The Mechanics of Walking
Conclusion
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies