In today's rapidly changing commercial environment, organizations demand a reliable database engine that easily adapts to emerging global and electronic trends, allowing reuse and synergy of existing IT assets, removing inhibitors on scalability, database design, data management and data access across legacy and emerging platforms and devices.
Why consider a switch to DB2? Simple. DB2 for i has a premier position in the global database arena, delivering superior scalability, vendor support, price-performance and unmatched ease of use, giving your developers and integrators the advantage of robust database solutions that perform, adapt and respond to your SOA initiatives.
IBM's significant R&D effort in database innovation over the last three decades has produced over 210 database-specific patents. This commitment to database leadership continues to ensure that you can access leading-edge data management technology today, and in the future.
DB2 reliably delivers the freedom to implement a broad mix of application types with confidence, including: SOA, Business Intelligence, OLAP, Data Warehousing, ERP, CRM, SCM, High Speed OLTP, 24x7x365 High Availability, Mobile device support and more?
Porting resources
Porting Guides:
- Porting guide: Porting MySQL to the IBM i platform (PDF, 535KB)
(Updated Aug 2010)
- Informix to IBM i platform version 6.0
(Updated July 2010)
- IBM DB2 for i porting guide Oracle to the IBM i platform
(Updated July 2010)
- IBM DB2 for i porting guide SQL Server to the IBM i platform
(Updated July 2010)
- IBM DB2 for i porting guide DB2 for Linux, UNIX and Windows to the IBM i platform
(Updated July 2010)
- DB2 Family Common Features Matrix
- DB2 Family SQL Reference (PDF, 9.2MB)
(Updated April 2008)
Conversion tools
- IBM DB2 Migration Toolkit
This no-charge download automates many of the tasks of migrating objects from other databases to DB2 for i, including tables, views, indexes, triggers, and stored procedures. The graphical toolkit also enables the migration of data and provides the ability to refine the migration process. Some user intervention will be required in the migration process, so it's strongly recommended to read the porting guides before using the toolkit.
- Click here to download the Toolkit supporting Oracle, SQL Server, Sybase, Informix , and MySQL. The toolkit supports the following versions of these database products:
- Oracle (versions 7, 8i and 9i)
- Sybase ASE (versions 11 through 12.5)
- Microsoft SQL Server (versions 6, 7, and 2000)
- Informix (IDS v7.3, v9 and limited XPS support)
- DB2 MTK Version 2.0.1 now includes support for MySQL (Versions 4 & 5) *NEW*
- Toolkit Resources
- Support & service information
General questions about the tool, or problems with the tool can be reported to the following e-mail address: mtk@us.ibm.com
- Porting Services - DB2 for i migration and porting services are available from the IBM Systems and Technology Group Lab Services
Education resources
Publications
- DB2 for i white papers
- Redbooks
- Stored Procedures Triggers on DB2 UDB for iSeries SG24-6503
- Diagnosing SQL Performance on DB2 UDB for iSeries (SG24-6654)
- Advanced Functions & Administration on DB2 UDB for iSeries SG24-4249
- DB2 UDB for AS/400 Object Relational Support, SG24-5409
SQL/400 Developer's Guide by Paul Conte & Mike Cravitz (29th Street Press, ISBN 1-882419-70-7)
Additional resources
- Online Newsgroups and Forums
- USENET: comp.sys.ibm.as400.misc, comp.databases.ibm-db2
- iSeries Network SQL & DB2 UDB Forum (link resides outside of ibm.com)
