Converting from Oracle AIX to DB2 for OS/390

This redbook describes how to define, implement, and document a migration project from Oracle on AIX to DB2 for OS/390. A sample scenario based on a subset of a real application developed in C Language has been used throughout this project. This allowed us to gain first-hand experience and gave us a starting point to evaluate alternatives and to extrapolate to more general considerations applicable to a variety of applications.

This redbook will help you plan for and conduct a conversion of your application from an Oracle AIX environment to a DB2 for OS/390 environment. It particularly applies to Version 6 of IBM DATABASE 2 Universal Database Server for OS/390, Program Number 5645-DB2.

It is primarily intended for database administrators and system designers with Oracle AIX and/or DB2 for OS/390 background: several considerations are applicable to the porting of general data and programs from the AIX platform to the S/390 platform.

We start with an introduction to the project and a summary of our conclusions. This will be especially useful for people responsible for deciding and defining the scope of similar projects.

Chapter 1. Introduction
Chapter 2. Project scenario
Chapter 3. Conversion process
Chapter 4. System environment
Chapter 5. Database conversion
Chapter 6. Data conversion
Chapter 7. Application conversion
Chapter 8. Testing, change control, and tuning
Appendix A. Sample script functions
Appendix B. Sample DB2 for OS/390 jobs
Appendix C. Sample data preparation program
Appendix D. OS/390 TSO tools and tips

Publish Date
22 December 1999

Rating:
(based on 1 review)

Rate this book

Author(s)
Paolo Bruni
Debra Eaton
Gregery Green
Luca Montini

ISBN
0738415219

IBM Form Number
SG24-5478-00

Number of pages
298