Skip to main content

ORACLEŽ/DB2 MIGRATION ESTIMATE REQUEST

To request an Oracle to DB2 Migration Estimate from IBM, simply send an e-mail to: db2mig@us.ibm.com and an IBM DB2 Migration Specialist will contact you to initiate the estimation activity and explain the process to you.

Please use the following phrase in the e-mail subject heading:

"Oracle to DB2 Migration Project Estimate."

For an Oracle to DB2 Migration Estimate we will need to gather and discuss the following profiles and metrics with you, using a structured document that will be sent to you.

Primary motivators to moving and success measurements:

  • Improved Performance
  • Reduced Ownerships/Operating Costs
  • Access to Skills
  • Industrial DB Reliability
  • Industrial DB Scalability
  • DB Architectural Flexibility
  • Improved Data Integration

Source Oracle Environment:

  • Source operating system and hardware platform
  • Number of Oracle instances, release levels and maintenance levels
  • Tables - column structures, complex relationships, sizes, data types used, row sizes, number of rows, average number of rows per table, largest table size
  • Indexes - number of indexes, average number of indexes per table, largest index
  • Oracle Stored Procedures - numbers, complexity, samples, average lines of code per stored procedure, rollback statements, nesting, etc.
  • Oracle Triggers - complexity, samples, average lines of code per trigger
  • Columns - data type inventory, are BLOB's used, etc.
  • Replication used
  • Database maintenance schedules and scripts
  • Oracle Packages - number of packages
  • Oracle User Defined Functions - numbers, languages used, samples, average lines of code per UDF, SQL called
  • Number of Oracle applications and their processing profile (online, batch, web, read-only, WAP, etc.)
  • Any ISV applications involved (SAP, Siebel, Peoplesoft, ect.)
  • Any custom code and code profile (language, development and testing)
  • Primary development languages and tools (C, Java, PL/SQL, Developer2000, Powerbuilder, etc.)
  • Middleware used (Oracle Transparent Gateway, etc.)

Target DB2 Environment:

  • Operating system and hardware platform
  • Development languages and tools
  • Middleware