ORACLE DATABASE MIGRATION SERVICES FOR AIX AND LINUX
Users face a number of challenges when they seek to migrate standalone Oracle databases (or those used by a packaged application such as Oracle E-Business Suite, SAP or PeopleSoft) from non-IBM Microsoft Windows and UNIX to IBM AIX and Linux. The difculty is that traditional methods to migrate data do not work in the time users have available. The speed at which data can be accessed and the rate at which it grows are key factors in todays world. If either is limited, business growth can be severely impacted. Database migrations can give you the opportunity to: Maximize the value of Oracle software licenses by using dedicated database servers, Attain more processing power at a reduced cost. Leverage new database features like grid support, column level security or ultra large database support, and Save by consolidating existing servers and replacing them with fewer, more powerful ones. The IBM Migration Factory has developed a suite of comprehensive services for Oracle users that addresses the fundamental issues associated with reliably migrating databases to IBM AIX or Linux with nominal or no downtime. The option to simultaneously upgrade from one version of Oracle to another, or convert to DB2, is also available. These services leverage years of experience in planning and performing Oracle database migration. Copyright IBM Corporation 2006

CHALLENGE

Every Oracle database migration is unique. It is imperative to gather the detailed information required to effectively size and plan a successful migration. This is greatly assisted by tools used to interrogate your databases to extract the necessary information in an automated way, which saves time and helps maintain consistent and accurate data. Some considerations in Oracle migrations include: Oracle versions: like-to-like migration or potential upgrades Quantity and size of databases Associated applications or packages Your downtime restrictions and user requirements Available servers and storage during a conversion for temporary storage and testing Use of storage management software Network characteristics Your policies

PLANNING FOR SUCCESS

Help reduce disruption with proven services for businesses with nominal downtime. Robust methodologies help reduce risk and help maintain data integrity. Faster migration than traditional single-stream Oracle export/import methods will lessen the need for customer tool evaluation, training and increased license costs. The ability to jump-start migration projects can provide rapid return on investment by utilizing new servers. Professional and efcient planning and implementation is performed by experienced personnel. Database migration can be combined with complementary Migration Factory services for endto-end application migration and server consolidation.

KEY BENEFITS

HOW DOES IT WORK?
Review your current database environment in a planning session with our migration team. We tell you how long it will take and how much it would cost. You contract with IBM for agreed services. We perform automated data collection to establish the metrics for the databases to be migrated. We work with you to establish testing requirements and a cutover strategy. We prepare a detailed project plan. We manage and perform the migration of the required databases according to the plan to help ensure that risk, schedule and cost are correctly managed. We conrm that the migrated databases meet your testing requirements. We support you during cutover into production. We provide basic skills transfer for an established number of your personnel on the migration tasks performed during these services. Contact the Migration Factory Your local IBM representative 1-866-MIGR8TE (toll-free in the US) migr8te@us.ibm.com IBM Sales Team or Business Partner

SERVICES

NEED HELP MIGRATING TO IBM?
THE IBM MIGRATION FACTORY HELPS ANSWER KEY QUESTIONS
Can it be done? How is it done? What will it cost? How long will it take? What are the risks?
Leverage more powerful and supported technology Current platform may have nominal or discontinued vendor support. Retain investment Youve invested a great deal of time Copyright IBM Corporation 2006 and resources in existing applications. IBM Global Services Reduce cost of ownership Route 100 There are potential cost savings from Somers, NY 10589 replacing hardware, consolidating U.S.A. servers and using available skilled resources. Produced in the United States of Access to larger pool of skilled America technical resources 05-06 The available pool of resources All Rights Reserved declines over time for older technologies.
HOW WILL MIGRATION HELP YOUR BUSINESS?
Weve been doing one thing for 20 years migration. The Migration Factory uses proven methodologies that are designed to be cost-effective and help mitigate risk. Capabilities include: Accurate sizing and costing of a migration The expertise necessary to help control the risk associated with application migration Cost-effective application migration Migrations for custom-coded applications as well as select packaged applications and databases System and application upgrades to newer platforms Signicant knowledge, expertise and experience in moving applications and associated databases from Solaris, HP-UX, Tru64 UNIX and Linux to IBM platforms Application-centric server consolidation
WHAT DOES THE MIGRATION FACTORY OFFER?
UNIX IBM AIX Linux Sun Solaris HP HP-UX HP Tru64 DG DG-UX Sequent DYNIX/ptx SGI IRIX SCO NCR AT&T 32-bit to 64-bit enhancement Package applications SAP PeopleSoft Oracle E-Business Suite

CORE CAPABILITIES

Database migration DB2 Informix Oracle Sybase SQL Server Other OS/390 Microsoft Windows Unisys Tandem Stratus HP 3000 OpenVMS
IBM, the IBM logo, AIX, DB2, DYNIX/ptx, Informix, NUMA-Q, OS/390 and Sequent are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in The United States, other countries, or both. Linux is a trademark of Linus Torvalds in the United States, other countries or both. Other company, product or service names may be trademarks or service marks of others. References in this publication to IBM products and services do not imply that IBM intends to make them available in all countries in which IBM operates. ODMS V2.9 051706

HOW DO YOU GET STARTED?

Contact the Migration Factory Your local IBM representative 1-866-MIGR8TE (toll-free in the US) migr8te@us.ibm.com IBM Sales Team or Business Partner

A guide for customers

IBM hardware-assisted data migration services
Helping simplify data migration to IBM TotalStorage systems with minimal complexity and disruption
IBM TotalStorage solutionswith their robust function and signicant priceperformance benetscan help businesses simplify their infrastructure and move to on demand computing. IBM TotalStorage solutions are designed to provide the exibility to respond to customer needs, simplify storage management and provide automation that can reduce staffing needs. Whether moving from another vendors storage to a highly scalable IBM TotalStorage solution or helping clients upgrade, move, consolidate or replace existing IBM storage, data migration can be a challenge. The need for safe, secure and nondisruptive data transfer is a growing concern for most IT departments today. Many IT groups postpone justiable upgrades because they are concerned that the upgrade process itself might disrupt ongoing business operations.
IBM TotalStorage hardware-assisted data migration services, part of the family of IBM migration offerings, can help simplify data migration in open systems and mainframe environments while addressing issues of complexity, disruption, system performance, host availability and data integrity. It combines a migration appliance tool, utilizing patent-pending IBM technology, with the experience of IBM services professionals. Together they can help speed data migration to IBM storage systems, including the new IBM TotalStorage DS8000 and DS6000 series. IBM services professionals can help manage your data migration by: Jointly building a plan for data migration activities
Performing a migration and moving data from source disks to new target disks Reviewing volume migration records, validating results and verifying connectivity from the new disks to host systems Removing the data migration hardware appliance tool
Why data migration services?
Data migration is becoming an increasingly important issue when switching from an alternate vendors storage platform, or upgrading, moving, consolidating and/or replacing existing storage. IT environments with a mixture of application servers and 24x7 service levels can make scheduling and executing data migration a complex, expensive and time-consuming task.
Installing and conguring a data migration hardware appliance tool and infrastructure-enabling components, when needed
Ive been in this business for twenty-ve years, and the support we get from IBM has been pivotal to the success were achieving in meeting our customers demands.
Steve White, Vice President of Information Systems Services, ISO
Many companies do not have an IT staff with the skills, experience and the bandwidth to make a smooth data migration transition. They want to be assured that the migration they need will be accomplished quickly and safely, without the risk of data corruption or lossand with minimal outage. Data is migrated by using a private SAN storage and hosts in FC and small computer system interface (SCSI) environments, providing transparent logical unit number (LUN) level copy of data and nondata using a private storage area network (SAN), switches and routers.

Generally no more intrusive than a bre channel switch, the data migration appliance is designed for easy installation and IBM services professionals can easily connect it to a host systems storage interfaces. Normally, no changes to customer host systems or SAN fabric are required. The datamoving elements of the data migration hardware appliance report the source storage systems vital product data. Because data does not ow through the management interface, no external access exists to the proprietary data being migrated, helping to maintain data integrity. The data migration hardware appliance is designed to be tuned for maximum host system performance to help reduce the performance impact of a data migration process on end users running their applications. The appliance is also designed to take advantage of multipath redundancy between itself, hosts and storage systems. If a problem occurs, an appliance can be removed from the environment and a system can be returned to its original conguration.
Data migration for open systems
The IBM data migration hardware appliance for open systems is a half-height, rack-mounted device with bre channel (FC) switches, patch panels, an Ethernet hub, a management console, eight data migration engines and dual power distributionall packaged in a rugged box on wheels. There is also a lite, smaller version of the appliance based on the same technology. These tools are designed to enable local and remote migration among multivendor
positioned between the customers SAN and storage, while mapping source LUNs to target LUNs. For online migrations, the migration appliance routes all online I/O from host to source LUNs and target LUNs and copies data from source LUN to target LUN. It masks target LUNs from the host during migration and offers support for fully redundant congurations. Host agents need not be installed and removed from production servers.
Recent IBM TotalStorage data migration engagements Industry

Travel

Challenge
The client outgrew its three-vendor storage environment and needed the capability to support corporate growth while reducing storage maintenance costs. The client needed to consolidate part of its storage infrastructure to improve efficiency, performance and return on its IT investment.

Solution

IBM upgraded the clients IT environment and consolidated storage on its IBM TotalStorage Enterprise Storage Server Model 800.
The simplied storage environment saves operating costs and system maintenance costs after three years, while doubling server capacity to accommodate signicant data growth. The client was able to leverage the advanced function technology and cost benets of IBM TotalStorage. IBM provided rapid data migration services to help avoid additional lease expenses while enabling data integrity. Estimated cost savings have been projected, as well as improved performance, reliability, data management and scalability for future growth.

Manufacturing

IBM congured several IBM TotalStorage storage systems and bre switches, and migrated data to them quickly.

Government

The client was looking for a solution to increase data sharing across locations and a storage infrastructure to support it.
Two IBM TotalStorage Enterprise Storage Servers (ESS) became the sole disk solution, with backups being performed over the SAN for all attached servers. Data was quickly migrated from the existing EMC disk to an IBM disk. IBM, working with the IBM Business Partner, successfully implemented a new solution and moved 150 mod 3 volumes in less than two hours.

Healthcare

The client wanted to replace EMC disks with IBM TotalStorage ESS disks, leverage its advanced technology features and rapidly migrate the date within a four hour outage window with the help of a specic IBM Business Partner.
The client has beneted from increased system throughput and storage growth for data and information.
Data migration for mainframe systems
The IBM data migration hardware appliance for mainframe systems is based on an IBM S/390 Multiprise 3000 enterprise server with the IBM z/OS operating system, and is equipped with up to 22 ESCON adapters for data migration use. This appliance is
mounted in a standard 30-inch rack on wheels, uses standard 110V AC power and requires no communication connections. It uses a specialized preloaded software utility called FDRPAS from Innovation Data Processing that is designed to move data with little or no degradation to host processing cycles for IBM mainframe systems.
This IBM service is designed to allow the migration of MVS, OS/390 and z/OS volumes, including SYSRES volumes, other system volumes, open catalog volumes, application data volumes, IBM CICS volumes, data volumes, IBM DB2 volumes, time-sharing
option (TSO) volumes, systemmanaged storage (SMS) volumes and work volumes. The migration appliance also supports parallel access volumes (PAV) and consistency groups. Special considerations and planning are required to process volumes containing active local page data sets. The data migration appliance is designed for easy installation. IBM services professionals can simply connect it to a host systems storage interfaces. If only IBM FICON adapters or ports are available on the target storage, the IBM team can provide temporary ESCON adapters for use during the migration. Because the data migration appliance can be congured before it is placed in a data path, the time to physically attach and remove it can be as little as fteen minutes. Because data does not ow through the management interface, no external access exists to the proprietary data being migrated, helping to maintain data integrity.

volume activity when volumes are moved. The data migration appliance is also designed so that if a problem occurs, it can be removed from the environment and the system can be returned to its original conguration. It is also designed to help reduce or eliminate the impact of a power failure or initial program load (IPL) during migration from source volumes. The volumes being copied would need to be restartedbut all volumes previously swapped before the event would be on the new disk subsystem and no action is necessary.
Migrations normally occur with minimum dependency on IT staffs. Because the CPU cycles or MIPs used to perform migrations are on the data migration hardware appliance tool and not on customer systems, users can continue to run their applications as before. Another advantage of the IBM hardware-assisted migration approach is that once an online migration begins, its speed can be decreased or increased to meet specic processing needs. For example, if applications running during a migration require additional resources, IBM can slow down the migration process. IBM can also help when specic volumes of data need to be migrated by a certain deadline or within a specic time frame. In addition, data can be moved, application by application, unlike most competing solutions that usually migrate from one subsystem to another. Above all, IBM hardware-assisted data
Advantages of using IBM data migration services
Using this hardware-assisted approach and its prescribed tools, IBM can deliver migration services for both open systems and mainframe data by transferring data between source and target volumes with host servers online or offline. These services can help speed data
migration services can help businesses gain a competitive advantage and reap the benets of IBM storage technologies by enabling essential storage upgradeswithout the complexities and risks of traditional data migration approaches.
The speed of data migration depends on a number of factors: the number of channels provided for the source and target storage systems, whether data goes through a director and the level of
migration, avoid disruption of production servers and minimize the potential impact on application performance.
Note: Some systems such as VM/ESA and VSE/ESA can be migrated in offline mode only. For details about this mode and other migration issues, please contact your IBM sales representative or IBM Business Partner.
IBMs methodology allows Champion to reduce the difficulties typically associated with data migration, making EMC replacements with IBM solutions attractive to our customers. The tools and resources IBM is providing through this program will help the Champion sales force generate more storage systems revenue as a result.

Chris Pyle, President and CEO Champion Solutions Group
IBM storage migration program
An IBM storage migration program is in place to help customers move from EMC to IBM TotalStorage products. It involves a global team of consultants and technologists who are equipped with tools to help customers make the transition. The program uses a threepronged approach: Assessing an on demand infrastructure, evaluating a customers current storage infrastructure and developing a new solution that offers greater performance and helps lower total cost of ownership (TCO)
migration program. As a part of this initiative, IBM Business Partners can engage IBM and include hardwareassisted data migration services in their transactions. These services can also provide IBM Business Partners with potential revenue opportunities for both IBM TotalStorage products and migration services. A number of IBM Business Partners, such as Champion Solutions Group and InfoSystems, Inc., can provide data migration services for open systems and access IBMs tools, services and support (including nancing and incentives). Many IBM Business Partners have already achieved success in delivering these services to their customers. For more information, visit ibm.com/partnerworld/pwhome.nsf/ weblook/sel_sip_storage.html
Providing a storage infrastructure and assessing implementation storage options that suit customer needs Deploying solutions and moving customer data from older EMC systems to new IBM TotalStorage solutions

IBM Business Partners

IBM is working with IBM Business Partners to extend the depth of IBM TotalStorage solutions and help increase sales momentum. This network of IBM Business Partners is a critical factor in the success of the data
The IBM TotalStorage hardware-assisted data migration tool is a great solution for customers. It quickly migrates the customers data while minimizing system downtime and takes the pain out of migration, making the process easy.
Clay Hales, President InfoSystems, Inc.

People you can count on

Americas Kevin Bogart, opportunity manager, IBM TotalStorage Lab Services 919 543-7919, kbogart@us.ibm.com EMEA Peter Cronauer, manager, IBM TotalStorage Lab Services 49-6131-84-0 x4288, CRONAUER@de.ibm.com AP Yoshio Maejima, manager, IBM TotalStorage Lab Services 81-46-691-4010, YMAEJIMA@jp.ibm.com Learn more! IBM TotalStorage hardware-assisted data migration services are available in all geographies. For more information contact your IBM representative or IBM Business Partner or visit: ibm.com/servers/eserver/ services/storageservices.html

Copyright IBM Corporation 2005 IBM Systems and Technology Group 5600 Cottle Road San Jose, CA 95193 Produced in the United States April 2005 All Rights Reserved IBM the IBM logo, CICS, DB2, Enterprise Storage Server, ESCON, FICON, OS/390, S/390, TotalStorage, VM/ESA, VSE/ESA and z/OS are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries or both. Other company, product and service names may be trademarks or service marks of others. This document could include technical inaccuracies or typographical errors. IBM may make changes, improvements or alterations to the products, programs and services described in this document, including termination of such products, programs and services, at any time and without notice. Any statements regarding IBMs future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only. The information contained in this document is current as of the initial date of publication only and is subject to change without notice. IBM shall have no responsibility to update such information. IBM is not responsible for the performance or interoperability of any non-IBM products discussed herein. Performance data for IBM and non-IBM products and services contained in this document was derived under specic operating and environmental conditions. The actual results obtained by any party implementing such products or services will depend on a large number of factors specic to such partys operating environment and may vary signicantly. IBM makes no representation that these results can be expected or obtained in any implementation of any such products or services. THE INFORMATION IN THIS DOCUMENT IS PROVIDED AS-IS WITHOUT ANY WARRANTY, EITHER EXPRESSED OR IMPLIED. IBM EXPRESSLY DISCLAIMS ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT. IBM products are warranted according to the terms and conditions of the agreements (e.g., IBM Customer Agreement, Statement of Limited Warranty, International Program License Agreement, etc.) under which they are provided.
storage.ibm.com/services/ featured/hardware_assist.html
References in this document to IBM products, programs or services does not imply that IBM intends to make such products, programs or services available in all countries in which IBM operates or does business. Any reference to an IBM program or product in this document is not intended to state or imply that only that program may be used. Any functionally equivalent program or product that does not infringe IBMs intellectual property rights may be used instead. It is the users responsibility to evaluate and verify the operation of any nonIBM product, program or service.