 | Level: Introductory Bill Wilkins (wilkins@ca.ibm.com), DB2 Technical Enablement Services
01 May 2002 This article is written primarily for application developers who want to convert their applications from Oracle to IBM® DB2® Universal Database™ (DB2 UDB), but also covers topics that are relevant to database administrators. It covers the architectures of Oracle and DB2 UDB and explores specific details and conversion examples.
A common requirement for database applications is to have them run on multiple database servers. The objective of this article is to help IBM business partners and other application developers to port Oracle applications to DB2 UDB.
The article assumes you are currently working with Oracle8, Oracle8i, or Oracle9i, and are porting applications to DB2 UDB Enterprise Edition (EE) V7.2. It does not cover the details of the DB2 UDB Enterprise-Extended Edition (partitioned version of DB2 UDB). However, applications developed for Enterprise Edition are portable to the partitioned version with few modifications. In addition, the article covers topics that are relevant primarily to SQL developers porting applications from Oracle to DB2 UDB. It also covers topics that are relevant to database administrators.
The following topics are discussed:
- Architecture
- Data types
- SQL language elements
- Application development
- Concurrency control
- Database administraiton
- Problem determination
Download | Description | Name | Size | Download method |
|---|
| Article in PDF format | 0205wilkins.pdf | 915 KB | FTP|HTTP |
|---|
About the author | | | Bill Wilkins is a senior technical specialist in the IBM Information Management Business Partner Enablement group in Toronto. Prior to this he worked in DB2 performance analysis in the IBM Toronto development laboratory for six years. He is an IBM Certified Advanced Technical Expert in DB2 UDB, has contributed to two books on DB2, and has over twenty-six years of experience in the IT industry. |
Rate this content
| | | |
